Symptom
- In a Payment Allocation you allocate an amount to a Customer Sales Project task.
- You expect this expense to appear as Deferred Cost of Goods sold.
- Instead, the amount got straight away realized on the Expense account according to the maintained Account Determination Group.
Environment
SAP Business ByDesign
Reproducing the Issue
- In the Payment Management work center go to the Payment Allocation view.
- Find payment Allocation XYZ and open it. (XYZ represents the Payment Allocation ID)
- Press View All.
- Navigate to the Allocation to G/L Account tab.
- You verify that the Expense got allocated to Cost and Expense Account ABC (via the respective Account Determination Group) and to Project Task DEF-X and Sales Order Item GHI-Y.*
As an Accrual Method is assigned to Sales Order item GHI-Y you expect that this expense will be posted as Deferred Costs of Goods sold displaying account ABC as G/L Account (Origin).
Instead, the Expense was posted straight away to the Account ABC.
*ABC represents the G/L Account ID; DEF-X represents the Project Task ID; GHI-Y represents the Sales Order Item ID.
Cause
The Allocation of the Expense appears with Account Assignment Sales. Therefore the Sales Order Item GHI-Y is considered as Leading Sales Object whereas the Project Task assignment is considered as preceding Sales Object.
This occurs when the payment amount is first assigned to the Sales Order Item rather than first to the Project task.
To verify the Account Assignment:
- open the Journal Entry of Payment Allocation XYZ.
- Navigate to the Posting Line to the Expense Account ABC.
- Under the Line Items table go to the Items: Sales section.
- Here, the Sales Document Item information appears first, as this is the leading Sales Object.
- The Project task information appears underneath.
Resolution
- Reverse Payment Allocation XYZ. This will trigger the generation of a new payment allocation, say Allocation KLM, in status In Preparation.
- Open the Payment Allocation and press View All.
- Go to the Allocation to G/L Account tab.
- Enter Account Determination group for Account ABC and the amount.
- Then FIRST select the Project task DEF-X.
- Only AFTER maintain the Sales Order ID GHI and Sales Order Item ID Y.
- Post the Payment Allocation.
As a result the expense will appear as Deferred Cost of Goods sold displaying the Expense Account as G/L Account (Origin).
To verify:
- open the Journal Entry of Payment Allocation KLM.
- Navigate to the Posting Line to the Deferred Cost of Goods sold Account.
- Under the Line Items table go to the Items: Sales section.
- This time, the Project task appears first, as this is now the leading Sales Object.
- The Sales Order Item Information appears underneath.
The expense will be only realized with the Revenue Recognition run provided the Accrual Method conditions are met.
Keywords
Payment Allocation, Deferred Cost of Goods sold , KBA , SRD-FIN-GL , General Ledger , Problem