Unanswered

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

(0) Share

Report

Posted on by Community Member 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

All responses (13)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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 23,616 on at

Like (0)

Report

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 10,877 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.
Weaveriski 23,616 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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.

Please let me know if you have any ideas about what can be wrong.
Weaveriski 23,616 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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

Picture 1

Picture 2
Community Member Microsoft Employee on at

Like (0)

Report

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.

'

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 10,877 on at

Like (0)

Report

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?