web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Inventory Profit and L...
Microsoft Dynamics AX (Archived)

Inventory Profit and Loss account types..

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I've got a problem when posting an inventory BOM assembly entry by Report as finished, that the voucher created is as follows:

BOM is composed of two raw items, raw items has different GL account than the BOM item.

Raw Material 1 cost =1

Raw Material 2 Cost =2

Voucher resulted from Assembly by report as finished:

Dr Inventory profit         1

Dr Inventory profit         2

Dr Inventory BOM          3

Cr Inventory loss         3

Cr Inventory raw          1

Cr Inventory raw          2

 

Why on earth is the system using the Profit and loss accounts here, and is there a way to change this behavior, my customer is assembling over 10000 BOM per day and this is creating a hell of transaction..

Please help.

 

Thanks,

Sherine.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

    Hi Sherine,

    As the BOM can have a standard cost which does not match the cost price of the raw materials, the above situation is needed. A next situation can occur:

    Dr Inventory profit         1

    Dr Inventory profit         2

    Dr Inventory BOM          5

                    Cr Inventory loss          5

                    Cr Inventory raw          1

                    Cr Inventory raw          2

    If the inventory profit and loss accounts were not used, there would be a situation like this and the posting has an imbalance:

    Dr Inventory BOM          5

                    Cr Inventory raw          1

                    Cr Inventory raw          2

    If you set the BOM journal name to post in summary, the ledger transactions are cumulated per date, account, dimensions, posting type.

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

    Thank you very much for your reply, it sounds logic to me now why this account is used..

    And yes changing to summary minimized the number of lines :)

    I have to get use of your experience in this area to ask you one more question as follows:

    When I want to return one of the raw items of the BOM, I enter (-1) quantity BOM in the report as finished, my problem is the journal entry resulted from this is as follows:

    Notes:

    BOM is composed of two raw items, raw items has different GL account than the BOM item.

    Raw Material 1 cost =0.316

    Raw Material 2 Cost =0.8925

    Voucher resulted from Disassemble by report as finished:

    Dr Inventory profit          0.72

    Dr Inventory Raw            0.316

                         Cr Inventory BOM        0.72

                         Cr Inventory loss          0.316

    I then ran re-evaluation for the item

    Dr Inventory BOM        0.1017

                        Cr Inventory profit          0.1017

    As you see the inventory BOM account is not credited by total amount of both items, only the first raw item, the second was not detected and there is a variance which I can't know it's origin which was fixed by re-evaluation....

    Any idea why does this happen!!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

    Hi Sherine,

    I have never used the report as finished in this way. Are you using the periodic form or the inventory journal?

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

    I am using the Inventory BOM journal..

    So do you have in mind another way to disassemble a BOM that has already been reported as finished for the purpose of returning one of its components?

    Thanks,

    Sherine.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

    Hi Sherine,

    I have not checked using the BOM journal for just one component. Usually you can reverse the complete BOM first. Then post new transactions. When you post it negative, it will also reverse the creation of the BOM.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans