This website is not affiliated with, sponsored by, or approved by SAP AG.

Rounding Factors for consolidated purchasing

Logistics : MM and its sub-modules (WM, IM, PO, LIS)

Moderators: Snowy, thx4allthefish, Ha Tran, svetja

Rounding Factors for consolidated purchasing

Postby MMPP » Mon Aug 21, 2017 6:28 pm

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.
MMPP
 
Posts: 400
Joined: Tue May 27, 2003 9:42 am
Location: My Desk

Re: Rounding Factors for consolidated purchasing

Postby Ha Tran » Tue Aug 22, 2017 1:37 am

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
Ha Tran
 
Posts: 28314
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: Rounding Factors for consolidated purchasing

Postby MMPP » Tue Aug 22, 2017 9:47 am

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.
MMPP
 
Posts: 400
Joined: Tue May 27, 2003 9:42 am
Location: My Desk

Re: Rounding Factors for consolidated purchasing

Postby Ha Tran » Sun Aug 27, 2017 8:31 pm

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
Ha Tran
 
Posts: 28314
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: Rounding Factors for consolidated purchasing

Postby MMPP » Mon Aug 28, 2017 9:43 am

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.
MMPP
 
Posts: 400
Joined: Tue May 27, 2003 9:42 am
Location: My Desk

Re: Rounding Factors for consolidated purchasing

Postby Ha Tran » Wed Aug 30, 2017 9:43 pm

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
Ha Tran
 
Posts: 28314
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: Rounding Factors for consolidated purchasing

Postby MMPP » Thu Aug 31, 2017 9:25 am

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?
MMPP
 
Posts: 400
Joined: Tue May 27, 2003 9:42 am
Location: My Desk

Re: Rounding Factors for consolidated purchasing

Postby Ha Tran » Tue Sep 05, 2017 7:30 pm

Hi,
You can change the existing configuration to change the status of this message 06076 from ''Error'' into ''Warning''.

Cheers,
HT
Ha Tran
 
Posts: 28314
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: Rounding Factors for consolidated purchasing

Postby MMPP » Tue Sep 05, 2017 7:33 pm

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".
MMPP
 
Posts: 400
Joined: Tue May 27, 2003 9:42 am
Location: My Desk

Re: Rounding Factors for consolidated purchasing

Postby Ha Tran » Fri Sep 08, 2017 12:16 am

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
Ha Tran
 
Posts: 28314
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: Rounding Factors for consolidated purchasing

Postby MMPP » Fri Sep 08, 2017 11:46 am

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!
MMPP
 
Posts: 400
Joined: Tue May 27, 2003 9:42 am
Location: My Desk

Re: Rounding Factors for consolidated purchasing

Postby Ha Tran » Mon Sep 11, 2017 9:24 pm

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
Ha Tran
 
Posts: 28314
Joined: Sun Mar 30, 2003 8:29 pm
Location: Perth, Western Australia

Re: Rounding Factors for consolidated purchasing

Postby MMPP » Tue Sep 12, 2017 9:49 am

Yes, that could work. Would that take advantage of ME59? Thanks for all the suggestions, this gives me something to think about!
MMPP
 
Posts: 400
Joined: Tue May 27, 2003 9:42 am
Location: My Desk


Return to Logistics MM

Who is online

Users browsing this forum: No registered users and 16 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.