Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Net Requirements Change

  • 1.  Net Requirements Change

    Posted Oct 14, 2016 12:27 PM

    Is there a way in AX 2012 R3 to change Net Requirements so that it does not show Planned production orders? Obviously, a filter does this, but that does not change the Accumulated quantity field.

    ------------------------------
    Kevin Lanier
    SC
    ------------------------------
    AXUG Summit - Post


  • 2.  RE: Net Requirements Change

    Posted 13 days ago
    i have a similar issue along the lines with accumulated function in net requirements. when i try to correct the values manually from the DB site it some how gets repopulated. but the irony is i am not able to back trace the function cos there is no set column in TransReq for accumulated field. i could not find how the value is even getting calculated. any help would be really appreciated in this regard.

    ------------------------------
    yogi chauhan
    MicroMetl Corporation
    Indianapolis IN
    ------------------------------

    AXUG Summit - Post


  • 3.  RE: Net Requirements Change

    TOP CONTRIBUTOR
    Posted 13 days ago
    Hi,
    The accumulated quantity is what the on-hand would be on that date if the transactions were to all take place. For example if my onhand today is 100 and I have a Sales order issue (inventory going out) for 30 for tomorrows date, my accumulation would be 70.

    If I also had a receipt (inventory coming in) for 20 tomorrow, my accumulation would be 90  (100onhand - 30 going out + 20 coming = 90).

    Accumulation basically is onhand + receipts - issues

    ------------------------------
    Andrew Lencsak
    Solution Architect
    DXC Technology
    Atlanta GA
    ------------------------------

    AXUG Summit - Post


  • 4.  RE: Net Requirements Change

    Posted 12 days ago
    i understand the formula you gave to get the accumulated value. my issue is i have to make the changes to accululated values from db site cos some data is corrupted along the lines and it keeps showing up on the sales order. it should be 0 according to business.

    so i went ahead and updated the "InventSum" table with AvailOrdered = 0  also i updated REQTRANS table and set qty=0 and ACTIONQTYADD = 0

    but every time the some batch process runs and repopulates these fields. being new to AX i am trying to figure out the origin of where this values are getting repopulated from and i cant find it.

    ------------------------------
    yogi chauhan
    MicroMetl Corporation
    Indianapolis IN
    ------------------------------

    AXUG Summit - Post


  • 5.  RE: Net Requirements Change

    TOP CONTRIBUTOR
    Posted 12 days ago
    The batch job is the standard Master planning regeneration. Every time it runs, it reanalyzes supply and demand to update this table. You should not alter the logic or try to recalculate values in this table, that could cause some pretty big issues. Not sure why you would have to do anything from the database to recalculate those values, that would really be risky and not a good practice.
    Master planning hits many tables in AX to come up with these values but the main one that produces the results is ReqCalcTrans and ReqTrans

    Do you have any concrete examples of what the user thinks is incorrect? Very often users claim Net requirement shows the incorrect results because of misunderstandings of the setups and configuration that drive these results. I would recommend having the users review their results with an experience Functional consultant from your partner because it could just be a configuration. If it is in fact an issue with the calculation in the database, then you can raise a case with Microsoft to review it and see if you have any customizations or modifications to business logic that is causing this or if you have data corruption.

    ------------------------------
    Andrew Lencsak
    Solution Architect
    DXC Technology
    Atlanta GA
    ------------------------------

    AXUG Summit - Post


  • 6.  RE: Net Requirements Change

    TOP CONTRIBUTOR
    Posted 13 days ago
    Hi Kevin, I see your original post is 2 years old. I have a question on why you would ever want to filter out Planned production orders from net requirements as you're kind of ignoring the purpose of that form when you do that. Net requirements should show all demand and supply, one of the main purposes of Master planning is to create planned orders for insufficient quantities for users to firm into orders they will fulfill. What exactly are you trying to achieve by hiding those from that form.

    ------------------------------
    Andrew Lencsak
    Solution Architect
    DXC Technology
    Atlanta GA
    ------------------------------

    AXUG Summit - Post


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