| Description |
*Use Case:*
Employees in a warehouse/store perform a daily or a scheduled counting of available stock on hand of an item. They have a list of items where they indicate the actual available stock. This usually called a count sheet or count cards. After the physical counting, they will enter this into i21 to match with the available on hand currently saved on the system.
In inventory count screen, the list of items are loaded and the value of the Physical Count is initially NULL/EMPTY. This means that the item hasn't yet started its stock counting or the employee hasn't yet entered the physical count into the system. When the physical count is entered, the system calculates the variance between the actual physical count and the quantity on hand (system count) that is available on the system. Otherwise, the variance remains zero. The example below depicts the actually data on the inventory count detail grid.
| *Item* | *On Hand (System Count)* | *Physical Count* | *Variance* |
|Corn|50.00|55.00|5.00|
|Wheat|100.00|{color:#bdc3c7}NULL{color}|{color:#bdc3c7}NULL{color}|
|Soybean|250.00|0.00|-250.00|
*Issue:*
The problem is when you export the grid to Excel or CSV file, since the data type of the Physical Count and Variance column is numeric, the NULL values are replaced by 0. This causes a display issue in the Excel or CSV file since the Variance becomes 0 when it should be empty.
*Expected:*
There must be an option in the datagrid column's config to enable EMPTY value when exporting numeric fields.
!pastedImage_d135340_0.png|height=347,width=377!
|