Page 1 of 1

Split freight invoices proportionally based on PO price

PostPosted: Thu Jan 21, 2016 6:03 am
by epifaphi
We have a requirement to split freight invoices for several Purchase Orders proportionally based on PO price and quantity (table part of MIR7).

For example:

we have $1000 invoiced for freight of Item A (price 10, quantity 40) and Item B (price 20, quantity 30). This should be automatically splitted as: $400 for Item A and $600 for Item B.

Questions:

- Is there some standard functionality for this?
- If we use custom development for this, which user-exits can be used in MIR4/MIR7 (during parking, posting or changing invoice)?

Re: Split freight invoices proportionally based on PO price

PostPosted: Fri Jan 22, 2016 4:51 am
by darkduck
Do you mean you want to increase the cost of the items with the actual freight costs?
Or something else?

Re: Split freight invoices proportionally based on PO price

PostPosted: Mon Jan 25, 2016 5:28 am
by epifaphi
darkduck wrote:Do you mean you want to increase the cost of the items with the actual freight costs?
Or something else?


We have planned freight costs collected on "GR/IR freight" account. After posting of Freight invoice we have a posting: DR: "GR/IR freight" CR: Vendor. This is happening now with the MIRO/MIR7 postings. And we are ok with current posting scheme.

Our objective is to automate distribution of invoice amount to multiple freighted PO line items in MIRO/MIR7 table part (can be done during changing or posting of IR). Currently it's done manually in Excel and then copypasted to relevant fields.

Re: Split freight invoices proportionally based on PO price

PostPosted: Tue Jan 26, 2016 8:39 am
by darkduck
There's a button "More allocation criteria" next to the PO number field in the MIRO screen. Does it help?

Re: Split freight invoices proportionally based on PO price

PostPosted: Wed Jan 27, 2016 2:31 am
by epifaphi
darkduck wrote:There's a button "More allocation criteria" next to the PO number field in the MIRO screen. Does it help?


Not really. It will help us to select items on which we will allocate amounts. But after selection we need to calculate "amounts" automatically (based on item price and entered quantity). By default SAP suggested full not invoiced amount.

So, expected process looks like:

1) user runs MIR7 and enter header data (incl. Invoiced Amount)
2) specifies POs for allocation and selects "Planned delivery costs"
3) select POs items for allocation
4) enter quantites from PO
5) based on item price and entered quantity system calculate distribution of "Invoiced Amount" to selected items (proportionally) and update the amounts.

Steps 1-4 are currently done in SAP, step 5 is done in Excel. Requirement is to automate Step 5, as system has all required information, while user need to do some intensive pre-work on copying prices, quantites to Excel model, copy/pasting it back, making errors etc.