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

How to recalculate the net value of an invoice

Logistics : SD and its sub-modules (Inquires, Quotes, Order Entry, SIS, Sales Contacts, Dist. & Billing)

Moderators: Snowy, thx4allthefish, mike_ac, Lost Identity

How to recalculate the net value of an invoice

Postby pascalvanmello » Mon Feb 03, 2014 12:50 am

Good afternoon,
I have the following requirement. A material has different prices dependent on quantity. I have set those up in t/code VK12 in a custom pricing condition similar to PR00.
A customer can purchase different quantities which will appear on different sales orders with a unit price dependent on the quantity purchased.
At month-end when the customer is invoiced, we need to adjust the net amount of the invoice based on the total quantity purchased.
For example:

To 10 units, $10 per unit
To 100 units, $9 per unit for all units
Over 100, $8 per unit for all units.

Order 1 for 10 units so 10 x $10 = $100
Order 2 for 100 units so 100 x $9 = $900

Invoice for 110 units so 110 x $8 = $880

The adjustment should only occur for that material. Other materials should not impact the net amount.
Please advise how this can achieved. Thank you.
Best regards,
Pascal.
PS: sorry if this is trivial but I am not an SD person.
pascalvanmello
 
Posts: 3
Joined: Mon Feb 03, 2014 12:21 am

Re: How to recalculate the net value of an invoice

Postby pascalvanmello » Tue Feb 04, 2014 12:17 am

Good afternoon,
I investigated further and its seems that rebates could do the trick. But we are not keen to send out credit memos especially if they pertain to the same period.
Best regards,
Pascal.
pascalvanmello
 
Posts: 3
Joined: Mon Feb 03, 2014 12:21 am

Re: How to recalculate the net value of an invoice

Postby pascalvanmello » Tue Feb 04, 2014 8:45 pm

Good morning,
I think I found it. Just changing the copy control from the sales order item type to the invoice, to recalculate the price, worked. So it was indeed trivial.
Best regards,
Pascal.
pascalvanmello
 
Posts: 3
Joined: Mon Feb 03, 2014 12:21 am


Return to Logistics SD

Who is online

Users browsing this forum: No registered users and 11 guests





loading...


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