D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

BOM Journals posting through Inventory gain/loss

  • 1.  BOM Journals posting through Inventory gain/loss

    TOP CONTRIBUTOR
    Posted Jul 20, 2018 07:55 PM
    Edited by Zvika Rimalt Jul 20, 2018 07:57 PM
    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
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: BOM Journals posting through Inventory gain/loss

    TOP CONTRIBUTOR
    Posted Jul 23, 2018 03:22 PM
    Hi Zvika,
     I would assume you would have to modify the posting structure somehow. If it helps, I found this explanation of the AX2012 R3 postings versus earlier versions on MSDN:
    BOM Journal postings in AX 2012 R3 vs. earlier versions of AX 2012
    Microsoft remove preview
    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.
    View this on Microsoft >


    ------------------------------
    Andrew Lencsak
    Senior Application Consultant/Solution Architect
    eBECS Limited
    Atlanta GA
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: BOM Journals posting through Inventory gain/loss

    Posted 26 days ago
    Edited by Phil Dawson 26 days ago
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role