D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Consolidate Planned Orders

  • 1.  Consolidate Planned Orders

    Posted Oct 08, 2019 01:58 PM
    We are trying to consolidate line items with the same Item Number, order date and delivery date from multiple Planned PO's with the same Vendor, into one line item for each of those same Item Number lines.
    Wirh considering huge number of Planned order lines, manual grouping is not usefull for us.
    It will be appreciated if you have any suggestions.

    Reza Pakdel
    Methods Improvement Supervisor
    Ofogh Koorosh Chain Stores
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Consolidate Planned Orders

    Posted Oct 09, 2019 03:55 AM

    What type of coverage group is listed against your items currently?


    If you use a Requirement type coverage group you will get one planned order for each line of demand.  However, if you use a Period type coverage group master planning will look for all demand across that period and group all the orders together.  The length of the period you use will depend on your lead times, minimum/maximum order quantities/price breaks and how often you wish to receive orders for that product.


    Sent from Mail for Windows 10


    Jenni Prior
    Supply Chain Planner
    This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the originator of the message. This footer also confirms that this e-mail message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Talley Group Ltd. Talley Group Ltd is an English registered company (registered no. 520386) with its address at Talley Group Limited, Premier Way, Abbey Park Industrial Estate, Romsey, Hampshire, SO51 9DQ

    Academy - Online Interactive Learning from Experts

  • 3.  RE: Consolidate Planned Orders

    Posted Oct 11, 2019 01:51 PM
    Thx a lot for you reply Jenni,
    The point is that coverage code in Coverage Group setting both in settings and  item's item-coverage is Period and equal to 5.The issue raises from this point that the system creates seperate planned orders for Minimum and Demand forecasts.
    It seems the system dosnt consolidate requirements of demand forecast and minimum.
    I changes fulfill minimum from tadays date to first issue but didnt solve the issue.I appreciate if you could help.

    Reza Pakdel
    Methods Improvement Supervisor
    Ofogh Koorosh Chain Stores

    Academy - Online Interactive Learning from Experts

  • 4.  RE: Consolidate Planned Orders

    Posted Oct 09, 2019 09:10 AM
    Hi -

    + 1 for exploring Coverage. Consider Periodic and a 1 day Period. Also explore MRP Parameters "Group by" settings.


    Dave Phillips
    Sr Support Escalation Engineer
    Fargo ND

    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role