Unanswered

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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (13)

Answers (0)

gkumar 740 on at

Like (0)

Report

Hi Icepennan,

Can you try the below setting changes and confirm if either of these wok for you:

1.In the Coverage group, can you check if consume on hand inventory is set to "Before all other supply".

2.You have set negative days to 365,which in some sense also means you can delay the customer order by these many number of days;ideally this number should be very small,can you change to say 5 or other smaller number and re -run the plan.

Thanks,

Ganesh

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

Could you post a picture of the net requirements so we can see the picture. As the demand is requirement how is the supply created for the actual production lines - what are the action/future messages if any on the actual production lines?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ganesh,

Thank you for your answer!

1) Coverage group is set to consume on hand "Before all other supply"

2) I have tried to change the negative days multiple times. Unfortunately, it does not help me if I change the negative days to a smaller number. For e.g. I tried with negative days= 0 /2.

Any other ideas?

Was this reply helpful? Yes No
guk1964 10,888 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Picture 1

Picture 2

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Weaveriski 23,618 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No