Tracing Back A Direct Cost Applied Entry

Jonathan2708

Hi,

Having run Inventory Adjust Cost Entries, and Post Cost To G/L, I now have a Direct Cost Applied entry in my G/L for quite a large amount that I cannot identify the source of. I have looked in the registers/other ledger tables but cannot find a common entry no. or transaction no. Can anybody give me hints as to how to trace how the direct cost was raised?

Any help appreciated,

Jonathan

ara3n

The G/L entry table has a field called Value Entry No. that links to the value entry no. that should allow you to link back to item ledger

ssingla

Have you unticked the automatic costing boolean on the Inventory Setup. If Yes then how u post your Post Cost to G/L Batch job? Is it Per Entry or Per Posting Group. If it is per entry then you can just go on your G/L Entry and then go for Navigate. It will show G/L as well as Value Entry associated with it. If the value entries are more than open them and see for abnormal cost amount Actual.

Jonathan2708

Hi Rashed,

Thanks for the reply. Unfortunately the 'Value Entry No.' field is blank. I can't see any field value that helps me trace it back.

Jonathan

ara3n

How are you running adjust cost and post cost to gl as sisingle is mentioning.

Jonathan2708

Hi,

It was posted using the 'Per Posting Group' method.

ssingla

By doing Posting per Group the link between Value Entry and G/L Entry is lost but thats not the end of road (Though I have never walked on it).
You can filter the value entry for the general bussiness and product posting group which is linked with the G/L account. To see the group go on the accounts card and then click on Account Button and option "Where Used List". Then filter the value entry on source code "INVTPCOST" and you will get the entries.

Reconcile and I hope they will match. The value entry will also give you the link to the item ledger entries which resulted in such adjustment.

ssingla

Just a minute...... You said Direct Cost Applied........
There is one more thing to make sure the entry is correct. In the General Posting setup if the G/L account defined in the Direct Cost applied account is linked directly with the Purchase Account and the Credit Memo Account then Purchase account - Credit Note Account = ABS(Direct Cost Applied Account).

Jonathan2708

Hi Sandeep,

Many thanks for the advice, I think this could help me.

Jonathan