Is it possible to have Items in the Req. sheet show what Sales Order they originated from? If this is not possible is there another way of knowing the origin of the items in the Req sheet?
*This post is locked for comments
Andrew, thanks for your response.
I've checked all of the above. I was hoping for understanding how MRP looks at the specific requirements placed in the Tracking Order inquiry for lot-for-lot items. Something like an algorithm or a step-by-step to calculate what demand is selected/counted for an action message. If I could follow the steps and arrive to the same order quantities, then I could understand better how to set the parameters, regardless if the are set for all the instances, or just for the location with a SKU record.
Thanks again,
Hi Victor,
First check that you don't have a sku record for the item / location as this will over ride the item..
Second check the Dampaner parameters on the Manufacturing Setup card as they are global if nothing on the item/sku.
Dampened will stop the qty going down or the date going later, but should have no other effect.
Also check the order modifiers ie min order qty, order multiple etc.
Is order tracked policy set to tracking only on the items. It should be.
Also check that the planning flexibility on the on the prod order lines is not set to None.
Also were the prod orders created manually as that might cause a problem.
It's difficult to debug the planning ws without the system in front of you, so I hope that helps
Andrew
Andrew, the explanation of the aggregation process sounds logic, but I'm struggling with a case that is a little more complex than that.
When I'm using Dampener parameters in an item that has a lot accumulation period of 1D, planning policy of Lot-for-lot and 0 safety stock, MRP is planning excess inventory and the order tracking in the messages of the Planning Worksheet do not match the quantities in the system.
Startign point:
Sales Orders:
| Order No. | Quantity | Date |
| S07 | 25,000 | 08/30/18 |
| S08 | 10,000 | 09/07/18 |
Production Orders:
| Order | Status | Quantity | Due Date |
| M15 | Firm Planned | 25,000 | 08/30/18 |
| M16 | Firm Planned | 10,000 | 09/07/18 |
Messages After running MRP:
| Message | Order No | Original Due Date | Due Date | Original Quantity | Quantity |
| Reschedule | M15 | 08/30/18 | 09/08/18 | 25,000 | |
| Reschedule and Ch Quantity | M16 | 09/07/18 | 08/30/18 | 10.000 | 31,000 |
When I review the order tracking for each message, This is what I have for the first message:
| Quantity: | 25,000 |
| Untracked quantity: | 25,000 |
This is the Order Tracking for the second message:
| Quantity: | 31,000 | |
| Order No. | Quantity | Date |
| S07 | 3,000 | 08/30/18 |
| S08 | 6,000 | 09/07/18 |
| S07 | 22,000 | 08/30/18 |
The two quantities of order S07 match an order that has a single row.
The resulting messages plan an excess inventory of 21,000 units. If I remove the dampener parameters, MRP plans a final inventory of 0 (zero) instead.
I think if I could learn how those quantities are calculated for the order tracking, I could figure out how to set the parameters correctly to be able to use dampener parameters without the risk of creating excess inventory.
Can you provide any insight on how these Tracking Order numbers are calculated?
Thanks,
The Lot-for-Lot option aggrigates by time buckets using the lot accumilaction period.
It takes into account existing Stock nad supply.
Andrew, could you elaborate on how the demand is aggregated? I noticed some of the Order Tracking lines do not match Sales Order lines and I am trying to understand how Nav calculates order quantities for the Planned Orders i.e. how a sales order line or a portion or a sales order line is quantified for the calculation of the demand that will be covered by a supply (production or purchase) order.
It could never work completely because some demand is aggregated together 'Lot-for-lot'. So one line does not equate to one sales order. You can show the order tracking on a FactBox if that helps.
If you want simple Order-for-order planning then look at the "Order Planning" screen instead.
Thanks Suresh, This gives us some direction, my company recently went live and we are trying to get up to speed. I cant believe this functionality is not built in
Matt,
We recently made similar kind of modification, you need to customize it to achieve your requirement.
Thanks for the reply. Yes this does help, but I was hoping that I could sort Req. sheet by Sales Oder or by origin. We need prioritize some of our orders and it seem as if the Req. sheet is just a bucket parts ready to be ordered that cannot be easily sorted by origin.
In the Req. Worksheet, select one of the lines and try to click on "Order Tracking". You should see information in the order tracking window.
Additional information is available by clicking the "Untracked Qty." button in the order tracking window.
This way you should get the information related to the source of the line.
Can you check that please and see if it helps?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (