SAP ECC; Sales and Distribution; Billing.
Retro-billing is a process of issuing credit or debit memos after retroactive price adjustments
07 May 2013
Jyoti Prakash is SAP Certified Associate and works as Senior Resource for Order Management & After Market. Currently, focused in providing consulting services to their customers for support project on SAP Order Management, After Market, Project System, and Logistics Execution.
Table of Content
- Prerequisite for using on Retro-Billing
- Billing Document for Retroactive pricing adjustment
- Condition record
- Order Reasons
- How Retro-Billing works on SAP
- Invoice & condition record – Existing
- Condition Record – Change
- Executing of Retro-Billing
- Related Content
Out of those various business processes in billing is accommodates & reconciliation of the retroactive prices adjustment for number affecting existing invoices. The retroactive prices adjustment can be due:
- Strong bargaining power of customer over
- New pricing agreement between supplier
- Volatile/change is price of essential commodities for manufacturing
to name a few.
This kind of prices adjustment can be handled by Retro-Billing. For instance, a new pricing agreement that you agreed with your customers may affect billing documents that have already been processed and settled. If that pricing agreement is effective before the pricing date of the billing documents, you can perform retroactive billing to call up a list of these documents and revaluate them with the new price. You can then create additional billing documents to settle any differences.
So, by definition & example of retro-billing, it can have a life cycle of months or sometimes beyond a year. Therefore this makes it a unique process.
Figure 1. Retro-Billing Process
On 01.03.2011, Supplier ships & sells 10 units of Material ABCD to Customer XYZ for INR 58 per unit (valid from 01.03.2011 to 31.12.9999), total amount INR 6653.30.
On 02.03.2011, invoice is sent to Customer for INR 6653.30.
Now on 01.07.2011, due to negotiations price may change to INR 68 w.e.f. 01.07.2011 (valid till 31.12.9999). Thus you will update your condition type in TCode VK11 / VK12 for this Material ABCD & Customer XYZ to INR 68 with validity from 01.03.2011 to 31.12.9999. But as you have already invoiced the customer in past so, to take care of this retroactive price adjustment you have an extra billing.
So, standard SAP platform provides the retro-billing transaction VFRB. This transaction provides basic retro-billing functionality enabling identification of invoice documents affected by retroactive price changes and execute creation of multiple documents.
In Retro-billing, enter the selection criteria like Payer, Sales Organization, Billing date from & to, Pricing type, Currency, Sold-to Party & Material.
By this system will provide you the list of invoices to which this retroactive price changes is applicable and hence you can simulate or even execute retro-billing & system will accordingly generate Credit/Debit memo type based on differential amount.
For positive retroactive price changes, i.e., INR 10 per unit price from former as INR 58 & revised as INR 68. In this case system will generate Debit Memo for the differential amount to be collect receivable from Customer. Whereas, for negative retroactive price changes, i.e., INR 15 per unit price from former as INR 58 & revised as INR 43. For this case system will generate Credit Memo for the differential amount to be pay back the differential amount to Customer.
These documents will get be in document flow of the original invoices.
3. Prerequisite for using on Retro-Billing
A. Billing Document for Retroactive Pricing Adjustment
- Retro Debit Memo
- Retro Credit Memo
- Corresponding relevant Copying Control
- Pricing procedure for capturing price change
B. Condition Record
- The value for base price should determined automatically in the invoice through condition record
- It should be maintain on the bases of Material & Customer combination
- It should be a have valid validity from & to date
C. Order Reasons
You need to maintain proper order reasons specific to retro billing document type for Credit/Debit memo.
4. How Retro-Billing Works on SAP
A. Invoice & Condition Record – Existing
You can use TCode VF05N for list of billing documents or invoices based on
- Billing Document Date (to & from)
- Billing Type,
- Customer & Payer,
To view desired invoices with current base prices use TCode VF03.
In invoice, check item data – condition tab to view pricing.
B. Condition Record – Change
Maintain the change in price difference. Say, positive difference of INR 10 from former price INR 58 and revised price INR 68.
C. Executing of Retro-Billing
Use TCode: VFRB for exercising retro-billing option. Provide following parameter based on your requirement, but keeping mandatory fields in mind:
- Payer (Mandatory)
- Sales organization(Mandatory)
- Billing date from(Mandatory)
- Billing date to (Mandatory)
- Pricing type(Mandatory)
- Sold-to party(Optional)
- Material (Optional)
You have a option of include Invoices with the Same Net Values. This indicator defines whether invoices whose current net value is the same as the post-calculated net value should be included in the retro-billing list.
- If the indicator is set, invoices with the same prices are included.
- If the indicator is not set, invoices with the same prices are not included
For instance, Invoice was created with a price of 100 Units. After the unit price is reduced to 50 Units, the retro-billing list is used to create a coupon for 50 Units. If you discover later that this price reduction was incorrect and you set the price back to 100 Units, a retro-billing list only appears if this indicator is set.
Below you can find details of entries without error
Then following screen will appear for simulation run.
Subsequently you can view the generated Debit memo from retro billing by using TCode VF03.
5. Related Content
- SAP Library: Retro-Billing
- SCN Message ID 9537098: Retro Billing – Normal Sales Process
- SCN Thread ID 874041: Retro Billing
- SCN Thread ID1793527: Retro-Active Billing – Config. Guide
- SCN Discussion Retro-billing Pricing
- SAP Note 1263240 – VFRB: Performance during mass processing
- SAP Note 81382 – Notes on the retro-billing list with examples
Disclaimer and Liability Notice
This document may discuss sample coding or other information that does not include SAP official interfaces and therefore is not supported by SAP. Changes made based on this information are not supported and can be overwritten during an upgrade.
SAP will not be held liable for any damages caused by using or misusing the information, code or methods suggested in this document, and anyone using these methods does so at his/her own risk.
SAP offers no guarantees and assumes no responsibility or liability of any type with respect to the content of this technical article or code sample, including any liability resulting from incompatibility between the content within this document and the materials and services offered by SAP. You agree that you will not hold, or seek to hold, SAP responsible or liable with respect to the content of this document