Adjusting the quantities of an inventory location should be performed in case there is discrepancy between the quantities in Megaventory and the physical quantities. To start the process, click INVENTORY > Inventory Taking.
- 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
Serial Numbers in Inventory Taking:
If Serial Numbers are used for a product that uses Serial Numbers, all Serial Numbers have to be added in the same row of the product, separated by comma in the same column (the serial numbers column).
It is required that the number of Serial Numbers must match the number of the Physical Count quantity (physical count quantity is column G in the example below).
For example, if you are increasing quantity of a SKU -that uses serial numbers- from three (3) to five (5) units (an increase by two units), then, you should enter five (5) comma separated serial numbers under the serial number column. Three (3) serial numbers must be existing serial numbers and should reside in the inventory location that the inventory taking operation is taking place. Two (2) serial numbers must be new.
If you are decreasing quantity of a SKU -that uses serial numbers- from five (5) to three (3) units (a decrease by two units), then, you should enter three (3) comma separated serial numbers under the serial number column. existing comma separated serial numbers under the serial number column. These three (3) serial numbers must be existing serial numbers and should reside in the inventory location that the inventory taking operation is taking place.
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.