The Initial Stock has to be done only once and the process sets the initial quantities and costs of the products already in stock at the time the company starts using Megaventory.
Before starting, you need to import your Products (Menu > Data Import > Products and Services):
You can also add products one by one using the interface (Menu > Products and Services > New Product - Service):
The initial product quantities and product values are uploaded to Megaventory by the Inventory Taking module which starts by selecting a New Adjustment:
The step-by-step process starts by selecting an inventory location.
Step 1 - Selecting an Inventory Location
Step 2 - Downloading The Excel Spreadsheet
The spreadsheet file comes pre-populated with all the products that are already defined in the account. To download the file, one should click on the Excel icon.
Step 3 - Select the appropriate Document Templates
Step 4 - Filling in the data and uploading
As shown in the example below, only the green-colored columns (Quantity, Unit Cost and Remarks) should be filled-in. In case some Products have zero quantity, those rows can be deleted from the file -or- a zero (0) can be entered in the Quantity field. The Unit Cost is entered at the main default currency that is defined in the account. The Remarks field is optional.
After finishing with filling in the information, the user should save the file as ‘CSV (Comma delimited)’. In case the file contains Unicode characters (for example Chinese, Greek, Arabic etc. characters) then the file should be saved as ‘Unicode text (txt)’ or 'Unicode CSV' instead. That will preserve the extra information that is present in such non-single byte characters.
After saving the spreadsheet (Google docs, open office, MS excel) file locally in the computer, the file may be selected and uploaded.
Once the file is uploaded, the quantities and inventory value will be updated in the inventory location that was selected in step 1 by the automatic creation of an Adjustment Plus document.