SMACC Docs

Opening Stock File

The opening stock file allows you to download the sample format file and upload the (same format of) excel file for the opening stock.

  Opening Stock File (1)

Downloading the Opening Stock File

To download the opening stock file, go to Inventory > Masters > Opening Stock File, the opening stock file page is displayed. The file you will download here is the sample file for future entries to be uploaded. Opening Stock File (2) Click on the Update button and the display is shown: Opening Stock File (3) Warehouse code: This field allows the selection of the warehouse from a drop-down list. Warehouse Name: This field is auto-fetched by the system based on the Warehouse code. Click on the Download File button to download the file you previously uploaded on the system. Opening Stock File (4) Note: You can update the field by adding the stock of inventory to be updated. Opening Stock File (5) Add the entries as per your new stock in the sample file. Opening Stock File (6) Now save the same file with a new name. Note: This new name of the saved file will be uploaded in the uploading section.  

Uploading the Opening Stock File

To upload the opening stock file, go to Inventory > Masters > Opening Stock File, the opening stock file page is displayed. Opening Stock File (7) Click on the Update button and the display is shown: Opening Stock File (8) Warehouse code: This field allows the selection of the warehouse from a drop-down list. Warehouse Name: This field is auto-fetched by the system based on the Warehouse Code. Opening Stock File: "Choose the same format of the updated Excel file to upload". Click on Save to save the information on this page.  
Was this article helpful?

Start with SMACC today

Try free for 14 days — no credit card, no commitment.