Dynamics Community Forum Thread Details

Incorrect cost from BOM journal

I found some items cost from BOM journal was incorrect.

Could you please advise the root cause?

Now we found some transactions can not entry to table "INVENTTRANSORIGINASSEMBLYCOMPONENT"

Below query show missing record in table INVENTTRANSORIGINASSEMBLYCOMPONENT

Select a.JOURNALID,a.DESCRIPTION,

b.INVENTTRANSID,c.INVENTTRANSID,c.RecID,

d.COMPONENTINVENTTRANSORIGIN

from INVENTJOURNALTABLE a with(Nolock)

left outer join INVENTJOURNALTRANS b with(Nolock) on b.JOURNALID = a.JOURNALID

left outer join INVENTTRANSORIGIN c with(Nolock) on c.InventTransId = b.InventTransId

left outer join INVENTTRANSORIGINASSEMBLYCOMPONENT d on d.COMPONENTINVENTTRANSORIGIN = c.RECID

where a.JOURNALTYPE = 3

and b.BOMLINE = 1

and a.POSTED = 1

and b.qty <> 0

and d.COMPONENTINVENTTRANSORIGIN is null

Could you please advise all INVENTTRANSORIGINASSEMBLYCOMPONENT.COMPONENTINVENTTRANSORIGIN

should be equal INVENTTRANSORIGIN.RecID ?

Please advise how to solve this problem?

and please advise the dataflow of costing when post BOM journal.

Thank you,

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Incorrect cost from BOM journal