Using Excel to enter Stock Count Quantities
Another option to enter stock count quantities into the system after inventory has been counted is by exporting the count sheet from the system to Excel, and then re-importing that file with the newly entered quantities. To do this, the user opens the desired stock count form and first mouses over the “Action” button and selects “Export Count Sheet”. This will export the information from the stock count into an excel file. The user can then enter the correct quantities into the Excel file in column “F” titled “Qty”. When finished entering the quantities, be sure to save as .csv format. Then … Continued