Inventory files can be directly uploaded from the iOS app.
The file from the app is named "inventory_XXXXXXXX.json" where XXXXXXXX is the current time of the upload.
The time is added to provide uniqueness to the file naming.
In case the file exists when trying to be uploaded, the app user will get a message letting him/her know to try again in a second or two.
The Process Inventory Files button processes all json files.
This processing also processes file names like UPLDXXXX.SKU when they are placed in the uploads directory.
If the entry is already in the database, the entry is skipped.
The entry is unique by:
The first time the inventory is loaded is sorted by area, section, and sequence. Columns can be sorted as needed
rows with red text show items that were not found in the item master.
The PROCESS INVENTORY FILES button takes all the files that were uploaded from the app and added into the inventory.
The VIEW INVENTORY button shows a table with the current inventory after processing the files.
The CREATE OUTPUT FILE button creates AUDIT.TXT and AUDIT_NO_FOUND.CSV files.
Once the files have been created, the VIEW AUDIT.TXT and VIEW AUDIT_NO_FOUND.CSV buttons will show what is included in those files.
The SUMMARY button shows a table with items that were counted or items that were not counted but they have quantity on hand in the AuditPriceboo.csv file.
The INITILIZE INVENTORY button allows to delete the current inventory.
The files are not deleted. It will be better if they are copied to another location before removing them
Your attention is required
Actions taken here are not reversible. Please act with care