I am experimenting with Inventory Journals of type BOM, to simulate the creation of kits I notice something undesirable with the way GL voucher/posting is created.
My expectation would have been – all components are removed from inventory (credit), and the finished good value is add (debited into inventory account).
Instead, what I see: the components are removed from inventory (credit), and the value is debited into “Inventory Expenditure, Loss” account. The finished good is entered into inventory (debit), and the value is credit from “Inventory Expenditure, Gain” account.
So this mixes the BOM journal “activity” with posting generated as a result of writing up/writing down inventory quantities.Ā
We stamp “product category” financial dimension on our inventory gain/loss ledger accounts in order to be able to analyze our total margin per product category.
The problem the above posting creates is that for items we use to construct kits, it will look like a lot of inventory is being “lost” (while in fact it just get converted into the kit), and for the kit, it will look like we are “finding” a lot of inventory when we would look at the GL.
Is there a way to prevent the BOM jornal from generating posting from/to the Inventory Expenditure Gain/Loss ?
—————————— Zvika Rimalt Functional Consultant Vancouver BC ——————————
Phil Dawson
Member
July 20, 2020 at 3:57 AM
HiĀ Zvika,
I know this is an old post, however did you ever get around this?Ā I am having similar issues.Ā
Andrew has pointed out below the reason why it is happening, however I was wondering if you did anything to change the behaviour back to what most people expect.
Cheers Phil
—————————— Phil Dawson Sunpork Fresh Foods Pty Ltd —————————— ——————————————-
BOM Journal postings in AX 2012 R3 vs. earlier versions of AX 2012
I have recently done some investigation in regards to the accounting transactions taking place during the posting of BOM journals in AX 2012 R3, and have found that there is a difference in the accounting transactions taking place in AX 2012 R3 vs. what was experienced in earlier versions of AX 2012.
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
Welcome to our new site!
Here you will find a wealth of information created for peopleĀ that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!