Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

How can you add up the quantities via the MRP

Posted on by 5

Hello all,

We run every monday a MRP run for couches. This end up in a planned order.

The question: is it possible to sum up the qty per item? This so we don't get two lines with item 16783588 with qty1, but one line with item 16783588 and qty 2

pastedimage1657872436674v1.png

Is there a parameter in which you can arrange this?

Hope to hear from you.

Martijn

Categories:
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,989 Super User on at
    RE: How can you add up the quantities via the MRP

    Hi Martijn,

    Great! Would you mind marking the reply with the solution as an answer? It will then set the status of this question to Answered which could be beneficial for other persons with the same question.

  • Martijnbos Profile Picture
    Martijnbos 5 on at
    RE: How can you add up the quantities via the MRP

    Hi Andre,

    Thanks. That's the solution. I changed the neg and pos days into 7 days. And now i have one line with 2 pcs

    Regards,

    Martijn

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,989 Super User on at
    RE: How can you add up the quantities via the MRP

    Hi Martijn,

    Have you tried changing values for the negative days and positive days?

  • Martijnbos Profile Picture
    Martijnbos 5 on at
    RE: How can you add up the quantities via the MRP

    Sorry for the late respons. I just this:

    2 different salesorders with item x. Both req del date the same. This ends up in one PO with 1 line and 2 pcs. SO this ok.

    After that this case:

    1 SO with del date of 23-9

    1 SO with del data of 24-9

    The cov period is 7 days. But this end up in one PO with 2 lines

    pastedimage1663930483188v1.png

    And also checked this parameter.

    pastedimage1663930646013v2.png

    So what went wrong? I really dont understand this.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,989 Super User on at
    RE: How can you add up the quantities via the MRP

    Hi Martijn,

    What is the delivery date on the different sales orders? If this would be within the period as mentioned by Guy, it will group them in one planned PO line.

  • Martijnbos Profile Picture
    Martijnbos 5 on at
    RE: How can you add up the quantities via the MRP

    Thanks for your answer. The problem is not that I get multiple orders. The problem is that I have multiple lines on the PO with the same item.

    Example:

    we sell during a week 3 couches on 3 different salesorder. These are all with item number 123456. After running the MRP I get one PO.

    But in this PO a het three lines with qty 1.

    And I want one line in the PO with qty 3.

    Is that possible?

  • Verified answer
    GuyUK Profile Picture
    GuyUK 28,373 on at
    RE: How can you add up the quantities via the MRP

    Check the Coverage settings for the Item (either via Item coverage, or the Coverage group on the Item). If you find you have the Coverage code set to Requirement, consider using a Coverage group which has the Coverage code set to Period, and a Coverage period of 7 days.

    This can give the possibility for demand for the item over a 7 day period to be grouped on to a single Planned order. 

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans