Stock: How to import stock item opening balance with serial number

Question: How to import stock item opening balance with serial number?

Version: 1.8 / 1.9 / 2.0

Answer :

There are 3 methods to import stock item opening balance with serial no.

Import a Range of Serial Number, such as from A001 to A005

The following is an Excel template of import stock item opening balance with serial no. You can maintain the SerialNo column using ‘->’ symbol to indicate the serial numbers within a range.

Then copy the data (Header and Detail) from template, log in to AutoCount Accounting Management Studio > Import > Import Stock Item Opening and click on Paste from Clipboard.

After import successfully completed, the serial number result will show as below.

Import Serial Number Not in Range

You can maintain the SerialNo column with commas to separate the serial numbers individually.

Alternatively, you can maintain the Serial No row by row as the following Excel template.

Note:
Before click on Paste from Clipboard, change the Duplicate Item Code Action from OverWrite to Expand, else it will overwrite and will not have 2 records.