Skip to main content

Notifications

Microsoft Dynamics AX (Archived)
Unanswered

On-hand is incorrectly pegging planned batch orders before production lines in master planning

Posted on by Microsoft Employee

We are experiencing an issue where on-hand is incorrectly pegging future planned batch orders (formula lines) before pegging firmed production lines that lies more closer in time.

Coverage code is set to Requirement, where coverage time fence=365, positive days=365 days, negative days=365. Planned batch orders are firmed approximately 90 days before production start for an order but it can differ.

I have no safety stock (minimum) setup and the parameter is set to consume on-hand before all other inventory.

If I set positive days= 90 days the problem "disappear" since the planned batch orders starting 90 days from now will not be able to "reach" the on-hand  stock anymore. However, this solution is not good enough. I want the positive days to remain as long as the coverage time fence (to be able to use the on-hand stock full coverage time fence) but at the same time I want the on-hand stock to peg the production lines more close in time before pegging future planned batch orders.

Any ideas?

We are working in AX 2012 R3 CU11.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-hand is incorrectly pegging planned batch orders before production lines in master planning

    Did you find a solution or the cause of the problem? I'm in a similar situation: There is a sales order line with requirement date 01/08/2018 and several Formula lines, but MRP don't see the on-hand inventory for sales order line and apply a future date of 12/12/2019. Setup is similar: coverage time fence=365, positive days=365 days, negative days=365

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: On-hand is incorrectly pegging planned batch orders before production lines in master planning

    The planned order is a planned order, it makes no real sense that this is simply taking the on-hand stock and pegging it to future planned orders when you have actual orders closer requiring the stock. The planned orders are re-generating looking at your screen shots and there is no standard ability to prioritise customers etc. This means that the planned order must be driven by a higher level requirement that is actually due prior to the other planned orders, meaning the chain of the initial demand is prior to the other orders.

    Look at what is driving planned order SE13-001749399. Follow this up the chain - what is the date of the real initial demand? You never answered the action messages question, are there any?

    I am assuming this is a vanilla planning system with no customisations to planning?

  • guk1964 Profile Picture
    guk1964 10,877 on at
    RE: On-hand is incorrectly pegging planned batch orders before production lines in master planning

    I don't fully understand your comment about negative days and coverage.

    Have you tried reducing that own to a few days and using dynamic negative days which will then pick up the LT?

    .Note if the demand comes for stock replenishment for min max, or for an internal production order then the LT used will be from the item, not from the vendor.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-hand is incorrectly pegging planned batch orders before production lines in master planning

    Almost the same picture here unfortunately. The difference is that we initially gets negative numbers for the on-hand stock at warehouse 13. This is because negative days on coverage group RM50= 400 which is equal to the lead time for the products.  However, as you can see the problem still appear with on-hand stock pegging future formula lines before production lines.

    CaptureMRP3.PNG

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: On-hand is incorrectly pegging planned batch orders before production lines in master planning

    Can you change the coverage group at 13 to RM50 and rerun a full regeneration? Does the picture change?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-hand is incorrectly pegging planned batch orders before production lines in master planning

    Hi Steven,

    Sorry, I was showing a print screen from a test system with old data. However, same situation in the Production environment where the data is up to date. Regeneration is run every day from the periodic option.

    As you can se in the picture below, planned transfers are suggested earlier than needed (since on hand is pegged against Formula lines instead of the firmed production lines) and we start to "build" on-hand inventory levels at warehouse 13 that we do not want.

    CaptureMRP2.PNG

    Please let me know if you have any ideas about what can be wrong.

  • Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: On-hand is incorrectly pegging planned batch orders before production lines in master planning

    Why is there no replenishment order on 08.03.2018 when the stock goes negative in picture 1? When was the static plan last run? You are selecting line 2 are warehouse 13 which has a planned order type of Transfer, so we should be seeing transfers from warehouse 2.  Are the planned orders for the held stock approved orders (so do not get re-generated?). Are you running full regen from the periodic option?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-hand is incorrectly pegging planned batch orders before production lines in master planning

    Picture 1 

    73768.Capture.PNG

    Picture 2 

    73768.Capture.PNG

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: On-hand is incorrectly pegging planned batch orders before production lines in master planning

    Hi Steven,

     

    Picture 1 - Example of Net Requirement for item X. On-hand stock on warehouse 13 =6 pcs. We have several production lines (firmed batch orders) scheduled up until 18/6-2018 (se picture 2). However, as Picture 1 shows below - the on-hand stock is pegging towards future formula lines instead of pegging towards production lines that is scheduled more close in time.

    61764.Capture.PNG'

    Picture 2: Net Requirement for item X. Picture shows that we have production lines scheduled up until 18/6-2018.

     We do not use Action or future messages.

  • guk1964 Profile Picture
    guk1964 10,877 on at
    RE: On-hand is incorrectly pegging planned batch orders before production lines in master planning

    Are the earlier planned orders marked in any way to other orders?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans