unit cost issues

whighsmith

Yeah yeah I know what you are all thinking, another person hasn't posted his purchase invoices or run the adjust cost function.... but I have! I've been fighting the battle for 5 years to keep item costs accurate in my company and just now I have a questions to the pros...

Strange situation,

new order on 10/11/07 for itemX
purchase receipt for itemX posted 4/15/08
sales/warehouse shipment posted on 4/15/08
purchase invoice posted 4/15/08
sales invoice posted 4/18/08.

Adjust cost entries batch ran on 4/18/08

Looking at the value entries on the item ledger transaction, I can tell my adjust cost job updated the cost of the sales transaction correctly.

BUT when I look at the cost on the sales invoice, it was not updated and still shows as zero. Do you know why this is? I thought this should have been updated by the adjust cost batch. The statistics for this sales invoice shows as zero.

Thanks for the help, let me know if you have any questions about setup etc.


--see my pics:
http://www.willhighsmith.com

bbrown

Adjust cost only update the inventory ledgers (and GL). It does not update the source documents.

whighsmith

So invoice statistics will always be wrong?
And Profit (LCY) field on the customer ledger entry for this transaction will always be wrong?

Alex_Chow

whighsmith wrote:

So invoice statistics will always be wrong?
And Profit (LCY) field on the customer ledger entry for this transaction will always be wrong?

Version 5.0 fixed this problem.

Savatage

There are other Statistical Reports available & they Use Value Entries to calculate.