Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested answer

BOM Journal - Purchased Item Cost Allocation

(0) ShareShare
ReportReport
Posted on by 52

 

My this question relates to my earlier thread "Purchase order explosion at Product Receipt".

I have created a Purchase order for a BOM Item and posted a product receipt for that purchase order. The cost for that item had been updated.

Now I have created a BOM Journal, to split the BOM Item to BOM Lines.

Issue:

Physical quantity has been updated as per the defined BOM Version, but the cost from main item didn't allocated to the items.

Bill of Material

pastedimage1656224793053v1.png

BOM Journal Lines

pastedimage1656224911008v2.png

BOM - Transaction Lines

pastedimage1656225390802v3.png

 

Q1: How to get the purchased cost of main item to BOM Line items? 

Q2: What Main accounts to be used in order to get the correct impact on inventory asset account and to avoid posting it to expense account?

  • huijij Profile Picture
    19,811 on at
    RE: BOM Journal - Purchased Item Cost Allocation

    I'm very sorry, as far as I understand there is currently no function that can achieve the above requirement, or you can wait for someone more experienced to answer it.

  • Talha1651 Profile Picture
    52 on at
    RE: BOM Journal - Purchased Item Cost Allocation

    Hello Judy,

    What I am trying to achieve is to allocate the cost of 1 purchased item, to the sub-components (BOM Line items) using the BOM journal.

    But the issue is BOM journal gets the cost of BOM line items (i.e sub-components) cost (if exist) and post the the physcial and financial impact accordingly.

    OR

    The other way around is to put the cost price manually against each BOM Line item to get the desired result.  (the desired result is shown in image below)

    pastedimage1656394035848v1.png

    How to automatically get the purchase price of 1 item, allocated to BOM Line items. Further, while making the BOM Journal my main purchased item is entered with a negative quantity.

    pastedimage1656394273100v2.png

      

  • Suggested answer
    huijij Profile Picture
    19,811 on at
    RE: BOM Journal - Purchased Item Cost Allocation

    Hi Talha,

    Q1: To calculate costs for a single manufactured item, you initiate BOM calculations from the Item price page.

    Q2: Do you mean which main account type to use?

    docs.microsoft.com/.../main-account-types

    If you are referring to this, I suggest you use the first main account type from the above document.

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Zain Mehmood Profile Picture

Zain Mehmood 237 Moderator

#2
Siv Sagar Profile Picture

Siv Sagar 109 Super User 2025 Season 1

#3
Danny Bilodeau Profile Picture

Danny Bilodeau 88 Moderator

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans