Get older Last Direct Cost of an item

NavRT1

Greetings all,

I currently need to retrieve the average of an item's Last Direct Cost by month.

According to this piece of code, we can get it from Purchase line as hinted in the help file:
http://mibuso.com/forum/viewtopic.php?p=206243#p206243

However, I am not sure if this is enough...
Does it get updated right after a purchase invoice line posting ?
I found odd that the last posted invoice does not equal to the LDC value in the item field. Could it affected by the cost adjust too? if yes how can I recalculate the right LDC ?

I thought that I could simply calculate the average of the "Direct Unit Cost" for a past given month of a purchase line item but it seems that
is not enough.

Many Thanks!

FDickschat

You can get all posted purchase amounts from the value entries. Just filter by
Item Ledger Entry Type = Purchase
Entry Type = Direct Cost
Invoiced Quantity >0
Item No.
(Variant Code)
(Location Code)

and divide "Purchase Amount (Actual)" by Invoiced Quantity

Be aware that the result set will include not only purchase invoices but also cancelled purchase receipts and purchase return shipments.