Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Production order- Posting multiple item ledger entires creating extra demand on components needing to be flushed out

Posted on by 5

Hi All,


First time posting on the forum, uncovered a curious problem with how business central deals with production orders which are under delivered due to scrap quantity or delays on remaining quantity meaning a second output is needed to fulfil finished quantity on orders. I have put a example of the error codes we are getting even though the component stock in bins adds up for quantity needing to be consumed.

It looks like when you have multiple ledger entries from outputs the last quantity outputted creates a extra demanding on components on the production order line. This causes stock registered on other orders being taken from the extra demand created by these double output orders leaving them with not enough stock in the bin to flush out and finish themselves.

Any help understanding this issue would be greatly appreciated so we can find the best process to fix the solution.

Thanks,
Tom

pastedimage1678107195427v1.png

  • DAnny3211 Profile Picture
    DAnny3211 9,217 Moderator on at
    RE: Production order- Posting multiple item ledger entires creating extra demand on components needing to be flushed out

    hi

    Here are some suggestions on how to approach this:

    Set up a separate item for scrap: It's common practice to set up a separate item in NAV for scrap, so that it can be properly accounted for in production orders. This way, when you post the production order, you can post the scrap to the separate item and adjust inventory accordingly.

    Use the "Scrap Quantity" field: In the Production Order line, there is a "Scrap Quantity" field where you can enter the amount of scrap expected for each production order line. This will help ensure that the system correctly accounts for the scrap quantity and adjusts inventory accordingly.

    Use the "Output Journal": It sounds like you are already using the Output Journal to post the scrap, but perhaps there is some confusion around the proper way to do so. When posting the scrap in the Output Journal, you should select the scrap item, enter the quantity scrapped, and select the appropriate production order line. This will ensure that the scrap is properly accounted for and inventory is adjusted accordingly.

    Review your BOM: It's possible that there is an error in your BOM (Bill of Materials) that is causing the extra consumption of components. Double-check the BOM to ensure that it accurately reflects the required components for the production order.

    Review your Routing: Similarly, there may be an issue with the Routing that is causing the extra consumption of components. Review the Routing to ensure that it accurately reflects the production process and required components.

    Seek help from a Dynamics NAV expert: If the above suggestions do not resolve the issue, it may be beneficial to seek the help of a Dynamics NAV expert to review your system setup and provide recommendations on how to properly account for scrap in production orders.

    DAniele

  • Tom Kirk Profile Picture
    Tom Kirk 5 on at
    RE: Production order- Posting multiple item ledger entires creating extra demand on components needing to be flushed out

    Hi,

    Thank you so much for the helpful response, I haven't seen many people having similar problems so this is valuable to help find out how business central works best.

    Big challenge for our business is working out the best process to deal with our scrap/underdelivered products we are producing on production orders. Component line scrapping works fine as we tend to scrap using the physical inventory journal or movement work sheet to keep on top of stock. I did think this was a background setting problem with no indication as to why the extra consumption demand is happening.

    Example I don't understand the logic of the scrap output function. The production order for x5 demand is posted as x4 output and x1 scrap (M4X7SCREW01CL), we post these from the output journal to suggest you are finishing off the full demand on prod order but in fact x4 are finished and the x1 scrap output disappears. Once the RL time cards have been posted the RL becomes a finished production order but when you look at the consumption an extra quantity on the component line (M4X7SCREW01BR) is consumed.

    I will take the suggestion from your previous reply and see if we can find a fix from that,

    Thanks,

    Tom

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,217 Moderator on at
    RE: Production order- Posting multiple item ledger entires creating extra demand on components needing to be flushed out

    hi

    It sounds like you may be experiencing an issue with the way that Business Central handles production orders that have been partially completed due to scrap or delays. Specifically, it seems that when there are multiple ledger entries for the same output, the last quantity outputted creates an extra demand on components, which can cause stock shortages on other production orders.

    One potential solution to this issue could be to adjust your production planning and scheduling processes to take into account the possibility of scrap and delays. For example, you could build in additional time and resources to account for scrap, or you could order extra components to have on hand in case of delays.

    Additionally, you may want to review the configuration of your production orders and the way that Business Central is calculating the component demands. You could also consider reviewing the settings in the item cards for the components to ensure that the calculation method is set up correctly.

    Another potential solution could be to review the production order routing and make any necessary adjustments to ensure that the components are consumed in the correct order and that the required quantities are being used.

    It may also be helpful to consult with a Business Central expert or your software provider to troubleshoot the issue further and find the best solution for your specific situation. They may be able to provide additional guidance or insights into the root cause of the problem and how to address it.

    DAniele

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans