You can import opening balances into Stock Control from another software package or another Sage 200 company.
There are two options you can choose when importing opening balances:
This option checks the import file is correctly prepared. It checks the database identifiers are specified correctly and the data is compatible with existing data in your system's database.
This option checks the import file is correctly prepared and then applies the opening balances to the stock items. Invalid records are rejected.
Stock levels for items are updated.
Provided the Stock Control module is set to use multiple locations, you can create new bins for stock items. The system uses the bin name specified in the import file to create the location.
If the Stock Control module is integrated with Nominal Ledger, nominal posting are generated. The nominal postings incorporate a narrative. This can come from the import file by specifying a narrative for each record in the import file. The alternative is to leave the narrative fields blank in the import file and enter a narrative as you start to import. This way the system applies one narrative to nominal postings. This may save time when preparing the import file.
Where stock items maintain a movement history, an entry is added to the history file.
Regardless of which option you choose the system displays a brief summary of the results. This indicates the number of successful records and the number that failed. Those records that failed can be viewed in an attached error log.
You must:
There are two methods to import opening balances. One to deal with batch/serial numbered (traceable) item opening balances, the other non traceable item opening balances.
Open: Stock Control > Utilities > Import and Export > Import Opening Balances.
Open: Stock Control > Utilities > Import and Export > Import Batch/Serial No Opening Balances.
If you are using multiple locations and want to create bins for stock items, select the Create Bins automatically if they have not already been set up in the Stock System check box.
Each time the system finds a bin in the import file that does not exist in the Stock Control module a new bin is created for the associated stock item.
What do you want to do?
Reference