Knowledgebase
NolaPro CS > NolaPro CS Support Desk > Knowledgebase

GL Accounts did not Import with Inventory Items

Solution

Before you Import Inventory Items make sure to set the Default Plant Location and Default Price Level in Admin -> Inventory Setup -> Genreal Setup. If the defaults are not set the first location and price level found will be updated. 

Now re-import your items and the GL Accounts will fill in. 

Advanced users with knowledge of the database can run an sql query to set the proper GL account for your items. Look at a recent entry in the item table. Update the following fields for all your items to give them the same value:

inventoryglacctid salesglacctid

update item set inventoryglacctid='xxx', salesglacctid='xxx' where companyid='1';

This will update all your items with the same gl account.

 
Was this article helpful? yes / no
Article details
Article ID: 45
Category: Imports
Date added: 2010-03-16 16:33:14
Views: 1526
Rating (Votes): Article rated 3.1/5.0 (34)

 
« Go back