web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How can you add up the quantities via the MRP

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Verified answer
    Guy Terry Profile Picture
    28,901 Moderator 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. 

  • Martijnbos Profile Picture
    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
    André Arnaud de Calavon Profile Picture
    299,397 Super User 2025 Season 2 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
    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
    299,397 Super User 2025 Season 2 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
    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
    299,397 Super User 2025 Season 2 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,028

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 878 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 579 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans