Stock Balance Adjustment
Inventory is also called as Stock balance update, Initial feeding of your stock balance from this module. Let's check in Sample data and will feed the stock balance, both negative and positive balances are also possible with it.
Format Data:
Date Location Stock ID Batch Expiry Date Qty Standard Cost Memo
Here these are all your sample data. Here you need to feed the information carefully.
- Date of the stock change
- Location, its your inventory location, use it from your inventory location code.
- Stock ID - It's your item ID
- Batch and Expiry Date - these two columns are useful for the medical, and grocery items. which doesn't apply with general items.
- Qty - Quantity
- Standard cost - the Standard cost of the item
- Memo - This is for comment purpose, Suppose if you have any extra information. it has to be used there.
Memo and Error
During the upload, Incase if any error, that will allow you to new file. This new downloading file will have one new column Memo at the end, check the problem on that rows with that error and fix them and upload it again.
Export
Each of our module has both export and import. With help of this you can export the data from our system .