Symptom
A Customer Invoice cannot be posted to accounting due to the error message:
"Account determination is missing for item type Sales Revenue. Specify account determination in chart of accounts and account determination profile <CADG>. Column Path Sales->Revenues (Materials)->Sales Revenue, Item Type Sales Revenue."
However, in the invoice it was maintained an Account Determination Group in the Revenue Assignment tab. A G/L account is assigned to the selected Account Determination Group.
(CADG stands for the Account Determination Profile)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Customer Invoicing work center.
- Go to the Invoicing Documents view.
- Show All Documents.
- Select the Customer Invoice in question, and then choose Edit.
- Press Post.
You see the error mentioned above.
Cause
The Customer Invoice has a G/L Account assignment to a Balance Sheet Account, such as Other Liabilities or Other Assets. In this case, the system still needs a Profit and Loss account defined to post the revenue, which then appears under G/L account (origin) in reporting.
Check if the G/L account is maintained for combination of Account Determination Group for Customers and Account determination Group for Materials.
- In Business Configuration find and open the Charts of Accounts, Financial Reporting Structures, Account Determination fine tune activity.
- Select Account Determination of Sales.
- Go to the Revenues tab and select 1-Materials.
- Here, check G/L account is maintained under Sales Revenue for the combination of Account Determination Group Commercial Sales for Customers and Account determination group for materials.
Note: If the customer invoice item does not have a Product ID assigned, the determination is done for the material view in revenue account determination with an empty Account Determination Group.
Resolution
Maintain the account determination following the path given in the error message:
- In Business Configuration find and open the Charts of Accounts, Financial Reporting Structures, Account Determination fine tune activity.
- Select Account Determination of Sales.
- Go to the Revenues tab and select 1-Materials.
- Here, press Add Row for Account Determination Group Commercial Sales for Customers, keep the account determination group for materials empty, and maintain accounts under Sales Revenue for this line. (If the customer invoice item does not have a Product ID assigned)
- If the product id is assigned, Add Row for Account Determination Group Commercial Sales for Customers, enter the account determination group for materials and maintain accounts under Sales Revenue for this line.
Once the changes are saved in the activity, the invoice should be able to be successfully posted.
In order to post the business transaction/the source document:
- Go to the General Ledger work center.
- Go to the Source Documents subview in the Closing Cockpit view.
- Search for Source Document ABC and select it.
- Click Actions Post Business Transaction.
(ABC stands for the Customer Invoice ID)
Keywords
Account Determination is missing for item type Sales Revenue, Customer Invoice, Other Assets, Other Liabilities , KBA , revenue assignment , sales revenue, position type sales reven , SRD-FIN-ACR , Receivables , How To