Symptom
The revenue recognition run realises revenue on account XYZ (XYZ represents a G/L account ID).
But you expect the revenue to be posted to account ABC instead (ABC represents a G/L account ID) according to the account determination group assigned to the customer of the associated sales order and customer sales project.
Environment
SAP Business ByDesign
Reproducing the Issue
- In the Cost and Revenue work center go to the Sales Document Items view.
- Open the Advanced search.
- In the Project ID field enter project ID DEF (DEF represents the project ID).
- All sales order items associated with the project appear.
- Press Reports and choose Sales Document - Line Items for Project.
- You notice that the revenue recognition run realised revenue on account XYZ.
Cause
There is a/are customer invoice(s) created with a different revenue assignment: In the project invoice request, in step 5 - Refine Invoice Items, you maintained an account determination group associated with G/L account XYZ. This setting takes priority over the account determination assigned to the sales order's customer:
- In the Sales Document - Line items report find the customer invoice(s) created for the project. You notice G/L account (origin) XYZ.
- Open the invoice, for example through the Journal Entry ID attribute.
- In the Items tab check the Revenue Assignment sub-tab.
- You notice account determination group X-XXXX (X-XXXX represents an account determination group ID).
Now, to verify the assigned G/L account
- access the Charts of Accounts, Financial Reporting Structures, Account Determination activity in Fine Tuning.
- Go to Account Determination and select Sales.
- Go to the Other Income tab (Due to the manual setting in the invoice the revenue is considered other income).
- Find account determination group X-XXXX in the Account Determination Group: Other Income column.
- In the Other Income column you find G/L account XYZ assigned.
Resolution
The system works as designed: If you select an account determination group in the G/L account field of a project invoice request then this setting overwrites the account determination of the sales orders/projects customer.
See Also
Keywords
revenue, wrong G/L account, revenue recognition run , KBA , SRD-FIN-COR , Cost & Revenue , Problem