Stock: Can I import stock item opening balance?

Question : Can I import stock item opening balance?

Version : 1.8 / 1.9 / 2.0


Answer :

Yes.

1) Log in AutoCount Accounting Management Studio, go Import > Import Stock Item Opening


2) Import item opening screen will be prompted, and you need to copy the data cells from excel template and paste it here.


The following is an Excel template of import stock item opening balance. You need to copy the data cells including headers.

Copy the data from template, then go back to AC Accounting Management Studio > Import Stock Item Opening, and click on Paste from Clipboard.


3) The ‘Status’ column will show New / Update / Error. If some information is missing or wrong, the status will appear as ‘Error’.


4) Click on Import.


And import successfully completed.


5) You may log in AutoCount, go to Stock > More Stock Maintenance > Item opening balance maintenance to check. Filter the item and click on Apply Filter.

The item opening balance will be showed.


By : Azirah 180727, Lay Swan 180801, P180803



Go to menu

  AutoCount Accounting 2.0 & 2.1


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations