D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

AX 2012 MRP - Requirement Profile

  • 1.  AX 2012 MRP - Requirement Profile

    SILVER CONTRIBUTOR
    Posted Jul 30, 2019 01:20 PM
    So this is a 2 question post / discussion.
    The first is when items are received they go into a quarantine warehouse. Now these show as an expected receipt on the non-quarantine warehouse. So question 1 is has anyone found out a way so that when printing out the Requirement Profile to exclude a warehouse. I looking into the 1:N and the n:1 to try to pull in warehouse so I could filter it out with no luck.

    Second question we have some items that have pages and pages of Master Planning data in the form of sales orders. There's some that have 20+ pages just for a single item due to the amount of sales orders.
    So does anyone have a simplified way to either consolidate these or filter these out from the requirements profile (MRP) as well. When looking at these one at a time from the Net Requirements function it's a snap, but not so much on the printed MRP reports.

    As always thank you in advance for your time even if just reviewing with no solution.

    #AX2012
    #Functional
    #MasterPlanning
    ​​​​​

    ------------------------------
    Ted Jillett
    Business Systems Analyst, Manufacturing AX
    Insulet Corporation
    Acton MA
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: AX 2012 MRP - Requirement Profile

    TOP CONTRIBUTOR
    Posted Jul 30, 2019 11:12 PM
    Edited by Andrew Lencsak Jul 30, 2019 11:13 PM
    Hi Ted,
    My first question as a former planner and a Dynamics evangelist is: Why are you printing out Master planning reports? :) I'm only a little bit kidding...
    The intention of the module is to use the features to prevent users from having to rely on paper documents and over analysis.
    How are you printing out this information? Typically, you'd have to do that item by item to print the Requirement profile unless your company built a version/view of all net requirements rather than going into to the form by item, as many companies have since that's not a standard view.
    For the requirement profile printout, can you use Ctrl + G to filter by grid then just use an exclamation mark (!) before the warehouse value you want to exclude?
    I would do the same to exclude sales orders by using the exclamation point to exclude the reference type of sales orders from the lines.

    If not needing to have a printout that covers many items and can view single item at a time, the Summary tab in the requirement profile will breakdown supply and demand by order type, so you can see the summed sales order demand. Apologies for the below screenshot being in D365:



    ------------------------------
    Andrew Lencsak
    Solution Architect
    DXC
    Nashua, NH
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: AX 2012 MRP - Requirement Profile

    SILVER CONTRIBUTOR
    Posted Jul 31, 2019 05:56 AM
    Andrew;
         Thank you for replying. This is a request from our purchasing and supply chain department. I have shown them the planned purchase order and actions report to analyze the MRP but some people just like to see everything, even-though it's a waste of paper. We've modified the report to add the addition of the buyer code since that is linked to the item but in no easy way do I see a way to filter for dimensions. Please see below for the image from 2012.

    Wonder if anyone knows the best way for the 1:n or n:1.
    Thanks

    Requirement profile


    ------------------------------
    Ted Jillett
    Business Systems Analyst, Manufacturing AX
    Insulet Corporation
    Acton MA
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: AX 2012 MRP - Requirement Profile

    TOP CONTRIBUTOR
    Posted Jul 31, 2019 07:15 AM
    Hi Ted,
    I'm looking at my 2012 environments and do not see that report. Are you sure it's not custom? Or can you confirm which AX2012 Release and CU so I can compare apples to apples?

    Thanks
    Drew

    ------------------------------
    Andrew Lencsak
    Solution Architect
    DXC
    GA
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: AX 2012 MRP - Requirement Profile

    SILVER CONTRIBUTOR
    Posted Jul 31, 2019 07:37 AM
    Andrew;
       We're on 2012 R3 and was also available in 4.0. I do not know about D365 yet. So this is under Master Planning > Reports > Coverage > Requirement profile.

    Thanks for taking some interest.

    Ted Jillett

    ------------------------------
    Ted Jillett
    Business Systems Analyst, Manufacturing AX
    Insulet Corporation
    Acton MA
    ------------------------------

    Conference-AXUG_200x200


  • 6.  RE: AX 2012 MRP - Requirement Profile

    TOP CONTRIBUTOR
    Posted Jul 31, 2019 07:56 AM
    Hi Ted,
    I can see through your screenshot and check the same path in all of my standard environments and do not see a Requirement profile report/inquiry. Are you sure this is not custom built?

    Thanks
    Drew

    ------------------------------
    Andrew Lencsak
    Solution Architect
    DXC
    GA
    ------------------------------

    Conference-AXUG_200x200


  • 7.  RE: AX 2012 MRP - Requirement Profile

    SILVER CONTRIBUTOR
    Posted Jul 31, 2019 10:49 AM
    Hi Ted.
    From your screenshot the query is named 'FSIInventRequirementProfile..'
    Maybe that FSI is the erp vendor?

    ------------------------------
    Glenn Linaa
    Tasklet Factory Mobile WMS
    aalborg, Denmark
    ------------------------------

    Conference-AXUG_200x200


  • 8.  RE: AX 2012 MRP - Requirement Profile

    SILVER CONTRIBUTOR
    Posted Jul 31, 2019 10:56 AM
    To Everyone that replied;
       Yes just confirmed that this is a custom report that was developed when we went live with 2012. Thanks for all of the time that you put into replying. I've addressed the out of the box solutions with out supply chain team and they are now pretty comfortable with the Net requirements, Actions, and planned purchase orders in order to successfully do their job.

    Thanks Again
    Ted

    ------------------------------
    Ted Jillett
    Business Systems Analyst, Manufacturing AX
    Insulet Corporation
    Acton MA
    ------------------------------

    Conference-AXUG_200x200


  • 9.  RE: AX 2012 MRP - Requirement Profile

    TOP CONTRIBUTOR
    Posted Jul 31, 2019 09:38 AM
    Hi Ted,
      A couple things:

    1.) I'm in agreement with Andrew, the Requirement Profile report you are describing is probably custom and users are best served by staying in the application when reviewing planning data.  It's much easier to affect changes when you are right in the Net Requirements / Planned Orders screens vs. working off a physical report and "looking things up" in the system.

    2.) For aggregating all your demand / supply lines in specific periods, do your users use period templates?  You can set them up at Org Admin -> Common -> Calendars -> Period Templates.  You can associate a period template with a coverage group and then it will default into the Net Requirements -> Period Tab. You can also switch to any other valid period template.  This shows a consolidated view of Net Requirements.


    3.) I'm guessing your Requirement Profile report is fed by an RDP, not an AOT query.  If that's the case, any advanced filters you do on Items is just going to filter the list of items that go into the rest of the RDP logic.   You really want your base query to have InventTable joined to ReqTrans and InventDim, then you can filter out ReqTrans records by warehouse.  

    I hope some of that was helpful.  Best of luck!

    ------------------------------
    Colby Gallagher
    Manufacturing Systems Consultant
    Agility Business Solutions
    Brecksville OH
    ------------------------------

    Conference-AXUG_200x200


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