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.