MRP purchase orders consolidation

[Former Member]

Hi

In the MRP order recommendations section I would like to combine all the purchase orders that have the same supplier and due date but different item in each one.(one supplier is providing 200 different items for our company).

It is now consolidationg the total quantity of an item in 1 single purchase order but I was wondering if we can do the same for different items from the same supplier.

thanks for your help

Edited by: shampisr on Jun 16, 2011 1:18 PM

[Former Member]

There is a better way to do this.

On the order recommendation window, click the form settings window. Go to the document window. Select Consolidate Recommendations.

These are the rule for document grouping:

• For purchase orders and purchase quotations, group recommendations with the same vendor into one purchase order or purchase quotation.
• The consolidated document may contain multiple lines due to different warehouses, items, due dates, and delivery dates.
• For production orders, group recommendations with the same due date into one production order.
• You can manually change the Due Date for recommendations. After you make the changes, the application takes the changed due date into calculation.

• For inventory transfer requests, group the recommendations with the same From Warehouse and Due Date.

Finally, if you have two lines in a PO order recommendation with different dates and you change the delivery date to the same date, it will become one line in a document and the quantities combined.

What sucks is that quantity based BP special prices do not get applied in the PO document for the new quantity based prices (if you set that up). When you try to change the pricing in the PO to force it to recalculate, it will not, as it appears to be using the order recommendation prices that were generated prior  to the PO creation. If you make a new line in the same PO for the same part, quantity based BP special prices will work. Go figure!

It also appears that a developer made some enhancements to the basic MRP to solve that issue. See slide 15.

http://www.slideshare.net/keithetaylor/material-planning-for-sap-business-one

I know this is an old post but maybe this will help someone.

[former_member799304]

Hi Colin,

Yes, your observations and recommendations are done usually by the Admin or Superuser at B1.  But inspite of this, you do not get a single Purchase or Production order for one single item.

So the best way to work around is to have one date specified for one week if MRP is weekly or one date for every fortnight, if every fortnight.  The problem will get resolved.  Alternatively, to note that there could be a delay in process of Purchase or Production order due to one date and run of MRP either weekly or every fortnight.

Thanks and regards.

[former_member799304]

hi,

Do u run MRP daily/weekly/monthly?

if weekly or monthly, use one single day as delivery date, so that u get consolidated PO for purchase items.

secondly, identify suppliers for items/item groups.

this would help, i presume

thanks and regards.

[Former Member]

Thanks Junior1505

this solved the problem, I changed the delivery date so it is the same and when updating it created 1 single PO for all the ticked purchase orders.

[former_member799304]

hi,

nice and good to hear that ur problem was solved.

personally thank and pass on the the same to the forum members, cause they helped me educated in B1.

regards.

Vijay M. Patil