ifile Adjusting InventoryAA-00328Adjusting Inventory with ifile.csv The "ifile" is a comma separated file used for inventory counting or any inventory adjustments when using a PDT (Portable Data Terminal). This is used for entering sales into the cash register, PO, and inventory counting. The "ifile" can be used also to bulk change counts without a PDT. Artisan looks up UPC, Alt Code 2 (Artisan bar codes) and Artisan item code (SKU). Steps: 1- MAKE A BACKUP, this should always be done any time you are working with inventory and there are chances of making mistakes. 2- Using Microsoft Excel or any spreadsheet program make a CSV file name ifile.csv with two columns, preferably using Item Code for column A, but can also use UPC and ALT CODE 2, then Quantity for column B. DO NOT USE HEADERS IN EXCEL. See example below. For Item code POSKBD with a quantity of 50 units the following record should be on the .CSV file: POSKBD(Column A) 50 (Column B)
3- Once you have made your import file in Excel save as Comma Separated Value (CSV) ifile.csv and save the ifile.csv to the Artisan data directory(C:\Artisan\Data) or \Artisan\Data\ depending where it resides.
. 4- Enable PDT inside Artisan Go (at the top) => Device Configuration > Portable Data Terminal.
5- Importing the counts in via inventory counting.
6- Review the counts. Artisan => main menu => inventory and pricing => stock management => physical inventory counting => review enter counts & make adjustments. Once reviewing looks good go to next step. 7- Accepting counts. Artisan => main menu => inventory and pricing => stock management => physical inventory counting => Accept new counts.
8- If you did option #1 of the last step then you still need to zero the counts for the batch that was adjusted, i.e. vendor, category or group of items.
|