BOM Journals posting through Inventory gain/loss

  • BOM Journals posting through Inventory gain/loss

    Posted by Zvika Rimalt on July 20, 2018 at 7:55 pm
    • Zvika Rimalt

      Member

      July 20, 2018 at 7:55 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
      ——————————

    • 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
      ——————————
      ——————————————-

    • Andrew Lencsak

      Member

      July 23, 2018 at 3: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
      ——————————
      ——————————————-

    Zvika Rimalt replied 8 years, 2 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘BOM Journals posting through Inventory gain/loss’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

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!