SAP Knowledge Base Article - Public

1938198 - Customer Invoice Cannot be Posted - Account Determination Is Missing For Item Type Sales Revenue

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

  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.

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 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:

  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.

(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

Product

SAP Business ByDesign all versions