Stock: Can I import stock item opening balance?

From AutoCount Resource Center
Jump to navigation Jump to search

Question : Can I import stock item opening balance?

Answer :

Yes.

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

Import item op1.png


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

Import item op2.png


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

Import item op3.jpg

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’.

Import item op4.png


4) Click on Import.

Import item op5.png


And import successfully completed.

Import item op6.png


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.

Import item op7.png


By : Azirah 180727, Lay Swan 180801, P180803



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations