Unit cost problems 1

[bawa63]

When we were importing data into GP before going live, some of our unit costs were wrong. Also we have done lot of transactions ( purchasing as well as selling after that). Now i see that the COGS account goes haywire becauce of the unit costs. I want to fix these unit costs for all items preferably thru SQL and not through GP. We use FIFO perpetual for our inventory (which is another mistake). On investigation, i found the Unit costs are stored in 3 tables, namely IV00101, IV00103 and IV10200 tables. Are these the only tables it is hitting? Can i change the values in these tables and assume things will be fixed? What's the best way to find which tables GP is hitting when say i post an inventory transaction? This would give me more insight into which tables to check additionally if any?

 

[PTina]

You can change the unit cost in Great Plains via:

Tools --> Utilities --> Inventory --> Adjust Costs.

I have found this to work well for me and I don't have to try to figure out which tables to update from the back end. Changing data from the back-end also increases the chances of errors.

 

[bawa63]

Tina, thanks for the help. One more question, if i adjust costs for the items already sold, will it affect any history or GL accounts that were previously posted?

 

[PTina]

No GL will not be updated, a report comes off with the accounts to be updated which you can use to enter journals. This option adjusts the figures posted to the inventory module.

 

[bawa63]

Thanks a lot for the reply. That solves my problems.