The Inventory Adjustment module is used to adjust the inventory quantities in the Megaventory account to match with those of an actual physical count. The same module is used to log the Initial Quantities of products in each inventory location and is often used as the first step after a full or partial Database Reset and before going ahead with live/production data and day-to-day issue of documents with Megaventory.
To start the process, click Inventory > New Adjustment:
The four-step inventory adjustment process starts by selecting an inventory location.
In case there are no Purchase/Receipt documents in the selected inventory location then, the second step operation will require setting the Initial Quantities in the selected inventory location.
In case there are Purchase/Receipt documents in the selected inventory location then, the second step operation will prompt the user for the download of the Adjust Product Quantities spreadsheet.
Regarding the user permissions, since the download of the spreadsheet file (step 2 in the Inventory Adjustment process) contains quantity/availability information for the selected inventory location, the user permissions for step 2 of the Inventory Adjustment module are inherited from the Inventory (On-Hand Inventory and Alerts) module. Since the upload of the spreadsheet file (step 3 in the Inventory Adjustment process) adjusts quantity and costs for the selected Inventory Location, the user permissions for step 3 of the Inventory Adjustment module are inherited from the Documents (Inventory Transactions and Invoices) module. See User Permissions for more.
Regarding the spreadsheet, you will have the choice to:
Only include the Products of the Clipboard
To include all products
If you have chosen to include all products, you can simplify the spreadsheet by simply deleting the products for which you won't perform an inventory adjustment. However, if you decide to keep all the products and simply change the quantity of those that require an adjustment, you will get an error message if you leave the physical qty column empty.
You will need to fill in all the numbers (e.g. by copying them from the Megaventory qty column to the physical qty column) and then to change the physical qty only for the product codes that need changing.
Remember that if you are increasing the quantity, you will have to provide the Unit Cost (column H of the spreadsheet).
if the product does not have a unit cost, Megaventory assigns the purchase price instead as unit cost (if the user has view product permissions).
The last step now is to upload the file you have saved as .csv or Unicode .txt if the file contains special characters.
Or login to your account.