Page 1 of 1

Rounding Factors for consolidated purchasing

PostPosted: Mon Aug 21, 2017 6:28 pm
by MMPP
We often consolidate purchase requisitions for multiple plants into one purchase order. Is it possible to apply rounding factors to the consolidated lines in the PO?

For example, we have a rounding factor of 1000 for a given material. We need a total of 1000 for 3 plants. Right now MRP creates 3 PReqs with 1000 for each plant (3000 total). Any way to make this come out to 1000 total?

This isn't the case for every raw material, just some of them.

Re: Rounding Factors for consolidated purchasing

PostPosted: Tue Aug 22, 2017 1:37 am
by Ha Tran
Hi,

Are you after the solution to automatically determine the PR Item quantity at the time of MRP run, taking into account the rounding value?

Cheers,
HT

Re: Rounding Factors for consolidated purchasing

PostPosted: Tue Aug 22, 2017 9:47 am
by MMPP
Yes, I think so, but for multiple plants combined, so that the purchasing agent doesn't end up ordering 3000 when only 1000 are needed.

To clarify my example -
Plant 1 needs 250
Plant 2 needs 400
Plant 3 needs 350

all 3 are rounded up to 1000 (rounding factor), so total ordered is 3000. But we really only need 1000, which is also the rounding factor. So only 1000 should be ordered, not 3000.

Re: Rounding Factors for consolidated purchasing

PostPosted: Sun Aug 27, 2017 8:31 pm
by Ha Tran
Hi,

I would suggest you to get it done via the BAdI activation. You can find the list of related BAdIs during MRP run via the attached link -
https://blogs.sap.com/2013/08/12/badis-for-mrp/


Cheers,
HT

Re: Rounding Factors for consolidated purchasing

PostPosted: Mon Aug 28, 2017 9:43 am
by MMPP
Thank you for the link HT, very helpful.
Perhaps what we are asking for is too difficult. Going through the different BAdI's and user exits there isn't something that seems to fit. Of course everything is possible with just enough ABAP, but I don't want to break MRP either.
Perhaps I need to look at the PO creation side instead of MRP. Adjusting the rounding factor if several PReqs (same material, different plants) are combined into one PO.

Re: Rounding Factors for consolidated purchasing

PostPosted: Wed Aug 30, 2017 9:43 pm
by Ha Tran
Hi,

If you are after this option, you should be careful in defining your logic so as to avoid getting the standard error message 06076 when you are ''rounding up'' the quantity.

Cheers,
HT

Re: Rounding Factors for consolidated purchasing

PostPosted: Thu Aug 31, 2017 9:25 am
by MMPP
Thanks for all your help! Yes, I will need to deal with that error message since the PO qty > PR qty. No idea how to implement this though, do you know if there is a user exit which kicks in when PReqs are added to a PO?

Re: Rounding Factors for consolidated purchasing

PostPosted: Tue Sep 05, 2017 7:30 pm
by Ha Tran
Hi,
You can change the existing configuration to change the status of this message 06076 from ''Error'' into ''Warning''.

Cheers,
HT

Re: Rounding Factors for consolidated purchasing

PostPosted: Tue Sep 05, 2017 7:33 pm
by MMPP
Thanks again, yes, I am aware of that. I was wondering "if there is a user exit which kicks in when PReqs are added to a PO".

Re: Rounding Factors for consolidated purchasing

PostPosted: Fri Sep 08, 2017 12:16 am
by Ha Tran
Hi,

Unfortunately, SAP has had only one related user exit EXIT_SAPLME59_001 that enables the grouping of PR into PO. However, this function module will only be kicked in while the PR is converted into PO via ME59 transaction.

Cheers,
HT

Re: Rounding Factors for consolidated purchasing

PostPosted: Fri Sep 08, 2017 11:46 am
by MMPP
Ah, that is very limiting. We use ME21N to pull PReqs into POs. May just not be possible, even though it seems like centralized purchasing for multiple plants would be a fairly common scenario. Thanks so much for your help, as always!

Re: Rounding Factors for consolidated purchasing

PostPosted: Mon Sep 11, 2017 9:24 pm
by Ha Tran
Hi,

Another workaround solution you can consider is to build the custom program which shall be run as the batch job to automatically convert your PR into PO. By doing it, you can add your custom logic as well as call the standard BAPI for PO conversion instead of relying only on user exit / BAdI.

Cheers,
HT

Re: Rounding Factors for consolidated purchasing

PostPosted: Tue Sep 12, 2017 9:49 am
by MMPP
Yes, that could work. Would that take advantage of ME59? Thanks for all the suggestions, this gives me something to think about!