Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Credit note SO invoice with Report as finished BOM

(0) ShareShare
ReportReport
Posted on by 125

Hello everyone,

My scenario:

BOM item ABC contains item A, item B, item C. Item ABC is setup as Auto - report as finished (Not production module)

SO line with item ABC, when i post invoice the process with BOM line automatically is OK. But when credit note SO invoice, credit BOM journal line does not marking to original BOM journal line.

The result is cost price item A, B, C is zero (not correct). I have to work around marking 2 BOM journal to ensure the exact cost price at closing period .

Can any setup i miss, I want credit BOM journal auto marking.

Please help me

  • Nhu Quynh Profile Picture
    125 on at
    RE: Credit note SO invoice with Report as finished BOM

    Hello Dolores,

    Thanks for your idea, can you give me the link detail of this report.

    I have found in https://experience.dynamics.com/ but it's difficult.

    I want to know this report and vote to it.

    Many thanks,

  • Suggested answer
    Dolores Young Profile Picture
    on at
    RE: Credit note SO invoice with Report as finished BOM

    Hi,

    The behaviour is a design limitation of Dynamics.  It has been reported before and there is an entry in the Ideas portal, which you may want to vote for.

    Kind regards

    Dolores

  • Nhu Quynh Profile Picture
    125 on at
    RE: Credit note SO invoice with Report as finished BOM

    Hi Ludwig,

    Thanks for your support, this is my discussion:

    1. Why is it that you use a BM journal for exploding and posting the lines of your BOM?

    => This is my requirement: BOM item contains approximately 10 items and BOM item is non-stock. BOM item only use when customer order. To convenient, I want my users only post invoice (BOM journal is posted auto).

    This is my reference topic: kurthatlevik.com/.../

    1. In the sales order lines we have we have a functionality 'explode BOM lines' that does the same.

    => 10 items component is too complex to explode on sales order, I want to show only BOM item. Because my sales order have to show at least 5 BOM items.

    1. Irrespective of that, from your last screenprint, I can see that the original sales order and the return order are linked via the return lot id field. The cost prices of those linked sales orders should be ok then.

    => It’s OK

    1. I don't know for what purpose you use your BOM journals but in the last screenprint, I cannot see a cost price in the highlighted section.

    => This is my problem, because it’s the receipt BOM component so it’s zero price. But I expect D365 will auto marking with origin BOM journal. When closing inventory, D365 will auto adjust orgin BOM component to make it zero, to equal to credit BOM component (if 2 BOM journal marking).

    Note: Marking is the function to mark 2 transaction, it will be adjusted equally each other at closing period.

    1. Also, your BOM lines show different lot ids and no relation to each other meaning that they are not 'linked'.

    => BOM line has the same BOM journal number. If you marking original BOM lines to credit BOM line, D365 will show reference lot id per BOM lines in invent trans (but D365 does not marking, it's the problem)

    1. I would like to understand why you use the BOM journals here.

    => To consume item component, see the answer for the question 1.

    1. I don't see the necessity because we have a functionality available in the SO that seems to me doing the same.

    => You can see the answer for question 2

    1. The problem that you have with your BOM is that they are not marked and that only issue transactions can be marked with receipt transactions.

    => No, if the issue trans marked with receipt trans, then they will be vice versa.The problem is 2 BOM are not marked automatically when credit note SO (because credit BOM is auto from D365). Then, user miss the problem and understand that it’s ok, but it’s not ok for the cost price. Can you help me to find out solution ?

    1. For that reason, you might always run into this issue.

    => Yes

    1. What you can do is trying to run an inventory recalculation to check whether this helps.

    => No, I tried but it’s not fine. As you know, only marking 2 BOM to make it corrected. If receipt price for BOM line is zero (not marking), it makes item cost price wrong.

    1. With a FIFO or weighted average costing approach, you run however always the risk that cost prices differ unless they are marked.

    => Yes, Only marking function makes cost price right.

    Many thanks for your detailed discussion. Please help me to find out the problem. I see this process is so convenient to my users.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Credit note SO invoice with Report as finished BOM

    Hi,

    Why is it that you use a BM journal for exploding and posting the lines of your BOM?

    In the sales order lines we have we have a functionality 'explode BOM lines' that does the same.

    Irrespective of that, from your last screenprint, I can see that the original sales order and the return order are linked via the return lot id field. The cost prices of those linked sales orders should be ok then.

    I don't know for what purpose you use your BOM journals but in the last screenprint, I cannot see a cost price in the highlighted section.

    Also, your BOM lines show different lot ids and no relation to each other meaning that they are not 'linked'.

    I would like to understand why you use the BOM journals here.

    I don't see the necessity because we have a functionality available in the SO that seems to me doing the same.

    The problem that you have with your BOM is that they are not marked and that only issue transactions can be marked with receipt transactions.

    For that reason, you might always run into this issue.

    What you can do is trying to run an inventory recalculation to check whether this helps.

    With a FIFO or weighted average costing approach, you run however always the risk that cost prices differ unless they are marked.

    Best regards,

    Ludwig

  • Nhu Quynh Profile Picture
    125 on at
    RE: Credit note SO invoice with Report as finished BOM

    Hi Ludwig,

    Thanks for your support. This is my step and setup:

    1. My setup

            Item model group for BOM item

    pastedimage1596366336231v1.png

            Item model group for BOM component

    pastedimage1596366349116v2.png

    Calculation group for all item

    pastedimage1596366359648v3.png

    My BOM

    pastedimage1596366366284v4.png

    1. Process

                   This is my origin SO with item report as finished. Then, I post invoice (without packing slip step)

    pastedimage1596366401262v5.png

                    Auto posted BOM journal

    pastedimage1596366410029v6.png

                    Create credit note SO manually (Order type = Sales order), Action Pane Sell/ Credit note. Then, choose the origin SO to credit note.

    pastedimage1596366427424v7.png

                    Post SO credit invoice (without packing slip step), auto posted credit BOM journal

    pastedimage1596366463788v8.png

                    The result, cost price is not correct. If auto marking 2 BOM journal, at period closing, the cost price will be adjusted  by D365. But i have to work arround marking

    pastedimage1596366474913v9.png

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Credit note SO invoice with Report as finished BOM

    Hi Nhu,

    Many thanks for the update. I checked LCS but could not find a hotfix that seems to be related to your issue.

    Can you thus share a screenprint of the original sales order and another one of your return order?

    Also can you let us know the exact steps that you used to create the return order?

    How did you add the lines in the return order and what other steps have been executed to create and process the return order.

    Many thanks and best regards,

    Ludwig

  • Nhu Quynh Profile Picture
    125 on at
    RE: Credit note SO invoice with Report as finished BOM

    Hi Ludwig,

    My version is D365 FO 10.0.11

    This is normal transaction, not intercompany.

    Please let me know your suggestion.

    Thanks a lot 

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Credit note SO invoice with Report as finished BOM

    Hello Nhu,

    Do you have this problem in D365FO or in AX2012/AX2009?

    Based on your tags, I would expect that you face this problem in D365FO.

    Is that right?

    Can you also let us know what system version you operate exactly?

    Also, can you let us know if you are dealing with an intercompany transaction?

    Best regards,

    Ludwig

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,208 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,968 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans