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

Split freight invoices proportionally based on PO price

Financials (FI, CO, TR, EC)

Moderators: Snowy, thx4allthefish, darkduck, Baz

Split freight invoices proportionally based on PO price

Postby epifaphi » Thu Jan 21, 2016 6:03 am

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)?
epifaphi
 
Posts: 60
Joined: Wed Jun 13, 2007 6:42 am

Re: Split freight invoices proportionally based on PO price

Postby darkduck » Fri Jan 22, 2016 4:51 am

Do you mean you want to increase the cost of the items with the actual freight costs?
Or something else?
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2459
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?

Re: Split freight invoices proportionally based on PO price

Postby epifaphi » Mon Jan 25, 2016 5:28 am

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.
epifaphi
 
Posts: 60
Joined: Wed Jun 13, 2007 6:42 am

Re: Split freight invoices proportionally based on PO price

Postby darkduck » Tue Jan 26, 2016 8:39 am

There's a button "More allocation criteria" next to the PO number field in the MIRO screen. Does it help?
SAP FI FAQ: http://en.sap.darkduck.com

Just before submitting any question, have a look at http://www.catb.org/~esr/faqs/smart-questions.html please...
darkduck
 
Posts: 2459
Joined: Thu Aug 25, 2005 3:55 pm
Location: whereami?

Re: Split freight invoices proportionally based on PO price

Postby epifaphi » Wed Jan 27, 2016 2:31 am

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.
epifaphi
 
Posts: 60
Joined: Wed Jun 13, 2007 6:42 am


Return to Financials

Who is online

Users browsing this forum: No registered users and 5 guests





loading...


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