Implemented Import CSV file for Stock Take, Warehouse Transfer & Production
I operate a central Warehouse and send out Warehouse Transfer Order to 10 smaller retail chains. Currently, only a small team at our Central Warehouse uses DEAR and we have to monitor Inventory for all retail chains and the central warehouse.
We use Excel (.xlsx) file format to communicate Warehouse Transfer Orders. Every other day, personnel at each retail chain would email us their transfer order with said .xlsx file attached. We got columns such as SKU, Product Name, Stock on Hand (Retail), Qty Ordered, Qty Delivered, Remaks, etc.
Obviously, personnel at retailer would fill QTY Ordered, and we'll fill in the QTY delivered as we make delivery.
Everything DEAR needs to complete a Warehouse Transfer is contained within this .xlsx file, SKU, Product Name, Qty Delivered.
If we're to be able to Import Warehouse Transfer Order Lines from CSV file, like we do with Purchase Order Lines....
We can download the .CSV template; highlight the records from .XLSX, copy and paste special (paste value) to the .CSV file. Then simply upload this CSV file.
And just like that we can save hours of tedious work and reduce errors from repetition.
4 people like this idea