SAP Knowledge Base Article - Public

1938198 - Customer Invoice Cannot be Posted - Account Determination is missing for item type Sales Revenue

Symptom

You cannot post a customer invoice 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 you maintained an Account Determination Group in the Revenue Assignment tab. You verified that a G/L account is assigned to the selected account determination group.

Environment

 SAP Business ByDesign

Reproducing the Issue

  1. Go to the Customer Invoicing work center.
  2. Go to the Invoicing Documents view. 
  3. Show All Documents.
  4. Select the customer invoice in question, and then choose Edit.
  5. 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.

You need to check if the G/L account is maintained for combination of Account Determination Group for Customers and Account determination Group for Materials.

  1. In Business Configuration find and open the Charts of Accounts, Financial Reporting Structures, Account Determination fine tune activity. 
  2. Select Account Determination of Sales.
  3. Go to the Revenues tab and select 1-Materials.
  4. 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:

  1. In Business Configuration find and open the Charts of Accounts, Financial Reporting Structures, Account Determination fine tune activity. 
  2. Select Account Determination of Sales.
  3. Go to the Revenues tab and select 1-Materials.
  4. 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)
  5. 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 you save the changes in the activity, you should be able to successfully post the invoice.

In order to post the business transaction/ the source document:

  1. Go to the General Ledger work center.
  2. Go to the Source Documents subview in the Closing Cockpit view.
  3. Search for Source Document ABC and select it.
  4. Click Actions Post Business Transaction.

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

Product

SAP Business ByDesign all versions