Symptom
You have maintained a Surcharge for a customer invoice item.
For the Distribution Channel used Net is the Default Pricing Procedure. Therefore you expect that surcharges on invoice items are to be posted to a separate G/L account.
In the customer invoice journal entry you, however, notice two separate line items for the same Sales Revenue G/L Account, one for the invoice amount and one for the surcharge amount. You now wonder how to identify such surcharge postings in Accounting.
Environment
SAP Business ByDesign
Reproducing the Issue
- In the Customer Invoicing workcenter navigate to the Invoice Documents view.
- Find Customer Invoice XYZ and open it via Edit. Then press View All.
- In the Pricing tab expand line item XYZ-XX.
- You maintained List Price of, e.g. 100,00 LC.
- You have added a Price component Surcharge (%) with an amount of 10, leading to a Price Component Value of 10,00 LC.
- Navigate to the Document flow of the Customer Invoice XYZ.
- To access the posting press on the Journal Entry icon.
- In the Journal Entry you notice a posting to the respective Sales Revenue G/L account ABC over 100,00 LC and a second posting to the same Sales Revenue G/L account ABC over 10,00 LC. You expected this surcharge to be posted to a different G/L account.
Cause
In SAP ByDesign there is currently no possibility to allocate surcharges to separate G/L accounts.
Resolution
A feasible workaround here is to identify surcharges with the Profit Detail by Contribution Margin Scheme report:
- In the Cost and Revenue workcenter navigate to the Reports - List view and select the Profit Detail by Contribution Margin Scheme report.
- In the Profit Type field select 2-Invoice Profit.
- Maintain all the mandatory information,i.e. Company and Contribution Margin Scheme.
- Press Go.
- From the Not Currently Shown section add Invoice as well as Price Component.
- You can now identify your invoice XYZ with the List Price Price Component displaying the value of 100,00 LC and the Surcharge Price Component displaying the value of 10,00 LC (10 %).
Keywords
surcharges, accounts , KBA , SRD-FIN-ACP , Payables , How To