Hi Ludwig,
Thanks for your support, this is my discussion:
- 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/.../
- 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.
- 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
- 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.
- 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)
- I would like to understand why you use the BOM journals here.
=> To consume item component, see the answer for the question 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
- 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 ?
- For that reason, you might always run into this issue.
=> Yes
- 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.
- 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.