Symptom
You complete all items of a Sales Order. When checking the POB IDs of the associated Revenue Acccounting Contract (RAC) you notice that the Allocated Invoiced Amounts of the POB items are different to the associated Sales Order items' Invoiced Revenue amounts.
Environment
SAP Business ByDesign
Reproducing the Issue
- In the Cost and Revenue work center go to the Sales Document items view.
- Use the Sales Order Items view.
- Select the items of Sales Order ABC by searching for ABC* in the search field (ABC represents the Sales Order ID).
- The items ABC-AA, BB, CC, DD appear. (AA, BB, CC, DD represent different Sales Order item IDs).
- First, navigate to the Dates tab and verify that for all items a Final Delivery or Invoice Date is displayed.
- Then, access the RAC XYZ from the Revenue Accounting Contract collumn (XYZ represents the RAC ID).
- After a Sales Document Item is completed the Allocated Invoice amount is automatically calculated for the associated POB ID (You might have to add the Allocated Invoiced Amount collumn to the screen via Personalization Mode).
You notice that the Allocated Invoiced Amount of the POB IDs is different to the Invoiced Revenue amounts of the Sales Order items.
You also notice that the total Invoiced Revenue amount equals the total Allocated Invoiced Amount. Example is as follows.
- In the Sales Document Items view select item ABC-AA.
- Navigate to the Accounting Data tab.
- Here, the Invoiced Revenue appears: -750,00 LC (LC=Local Currency).
- Access the RAC.
- The associated POB ID XYZ-AA displays an Allocated Invoiced Amount of 640,00 LC.
- Check the other Sales Order Items and associated POBs. You notice the sales order items' Invoiced Revenue amounts are different to the Allocated Invoiced Amounts.
Cause
In the same proportional manner, as a Sales Document Item's Allocated amount is calculated based on the Standalone Selling Price (SSP), also the Allocated Invoiced Amount of the POB IDs is calculated on a proportional basis.
Resolution
The formula to calculate a POB ID's Allocated Invoiced amount is:
(SSP of POB ÷ Total SSP of all Sales order Items/POB IDs of the RAC) x Total Invoiced Revenue amount.
Example:
- Total SSP: 3000,00 LC
- Total Invoiced Revenue: 3200,00 LC
Sales Order Item | POB ID | POB SSP | Invoiced Revenue | Formula | Allocated Invoiced Amount |
ABC-AA | XYZ-AA | 600,00 LC | 750,00 LC | (600/3000) x 3200= | 640,00 LC |
ABC-BB | XYZ-BB | 1200,00 LC | 1100,00 LC | (1200/3000) x 3200 = | 1280,00 LC |
ABC-CC | XYZ-CC | 700,00 LC | 600,00 LC | (700/3000) x 3200 = | 746,67 LC |
ABC-DD | XYZ-DD | 500,00 LC | 750,00 LC | (500/3000) x 3200 = | 533,33 LC |
Total: | 3000,00 LC | 3200,00 LC | 3200,00 LC |
See Also
Keywords
Allocated Invoiced Amount, Invoiced Revenue, POB, RAC , KBA , SRD-FIN-COR , Cost & Revenue , How To