Adjusting the quantities of an inventory location should be performed in case there is discrepancy between the quantities in Megaventory and the physical quantities.
- If the Include Products of the Clipboard Only option is checked, then, the Inventory Adjustment Spreadsheet will include only those products that are currently in the Clipboard. This feature is handy when the user wishes to adjust the quantity of a few products only rather than all the products of the account.
In the example of the figure below only the green-colored columns (Physical Count Quantity, Unit Cost and Remarks) should be filled-in. In case the Current Megaventory Quantity for a Product matches the Physical Count Quantity for that Product, the row can be optionally deleted from the spreadsheet file. The Unit Cost is entered at the main default currency that is defined in the account and only in the case in which the Physical Count Quantity is greater than the Current Megaventory Quantity. In case the Physical Count Quantity is lesser than the Current Megaventory Quantity, the current Product unit cost is used to reduce the Product quantity. The Remarks field is optional
Finally, if Serial Numbers are used for a product that uses Serial Numbers, all Serial Numbers have to be added in the row of the product, separated by comma. The number of Serial Numbers must match the number of the Physical Count quantity. The system will automatically add new Serial Numbers or discard the existing ones.
To upload the file, the user should follow the same procedure as in the Initial Quantities case. After uploading the file in the account, the system creates two documents: an Adjustment Plus to increase the Megaventory quantity to match the quantity of the physical count and an Adjustment Minus to reduce the Megaventory quantity to match the quantity of the physical count.
- The user permissions for the Inventory Taking module are inherited from the Documents (Inventory Transactions and Invoices) module.
- Note also that in case of existing unit cost values these will be included in the downloaded spreadsheet if the requesting user is an admin only.