Our client wants to see actual (adjusted) item costs on job ledger entries. As standard, job ledger entries hold the cost picked up from the item at the time of entry. I am reluctant to tamper with the ‘Adjust Cost - Item Entries’ job, so I am imagining a separate batch job which picks up the cost-adjusted item ledger entry(ies) per job ledger entry and updates the ‘Unit Cost’ and ‘Total Cost’ on the job ledger entry.
However, it doesnt look as if there is enough information in the standard system to definitely identify which item ledger entry(ies) relate to any given job ledger entry. The client uses lot numbering, although I dont think this is relevant.
Does anyone have any suggestions about how I could approach this please.
I already have made a specific report to adjust job ledger entries based in item ledger entry cost. Using document number, posting date and item number, you can related item ledger entry and job item consumption.
I don’t remember exactly but if I’m not in mistake there was a restriction in posting a journal with several lines of same item.
Restriction has in posting journal. You can’t have several lines with same document number and in same date and matching item number. If you did that, you couldn’t match between item ledger entries and job ledger entries.