SAP Knowledge Base Article - Public

1488750 - The Sales Revenue Account Is Not Determined As Expected When Posting a Customer Invoice to Accounting

Symptom

You post a customer invoice with a service item to accounting. When you check the detailed line item of the accounting document, you find that the sales revenue account determined by the system is not the one that is supposed to be.

Environment

SAP Business ByDesign

Reproducing the Issue

First of all, you follow the steps below to check the account determination group for the customer:

  1. Go to the Business Partner Data work center, and choose the Accounts view.
  2. Select the customer used in your customer invoice and open it up.
  3. Navigate to the Financial Data tab, and you can see the defined Account Determination Group for your company.

After that, you follow the steps below to check the account determination group for the service:

  1. Go to the Product Portfolio work center, and choose the Products view.
  2. Select the By Services subview.
  3. Select the service in your customer invoice, and open it up.
  4. Navigate to the Valuation tab, and you can see the assigned Account Determination Group for your company.

Finally, you check the account(s) determined by the account determination group for the customer and the account determination group for the service:

  1. Go to the Business Configuration work center and choose the Activity List view.
  2. Select the All Activities subview.
  3. Navigate to the Fine-Tune step.
  4. Open the Charts of Accounts, Financial Reporting Structures, Account Determination activity.
  5. Under the Account Determination section, choose Sales.
  6. Navigate to the Sales section below, and choose the Revenues tab.
  7. From the drop-down list, choose Service.

You can see the Account Determination Group for Customers determines an account, which is XYZ. While the Account Determination Group for Services determines an account, which is ABC. You feel the account ABC should be used while posting the customer invoice to accounting. (ABC and XYZ stands for the account ID)

You then go to check the sales revenue account that is actually used during the posting of the customer invoice:

  1. Go to the General Ledger work center and choose the Journal Entries view.
  2. Select the Journal Entries subview.
  3. Navigate to the Document Flow tab.
  4. Show All Postings.
  5. Search the journal entry by the ID of the customer invoice in question.
  6. Choose View.

     You can see the sales revenue account used is XYZ, which is not ABC as you expect.

Cause

During the determination of accounts for the posting of revenues, the system has the following prioritization:

The sales revenue determined by both the Account Determination Group for Customers and the Account Determination Group for Services has the highest priority. If there is not such an account maintained, the system goes to check the sales revenue account determined by Account Determination Group for Customers. If still nothing is found, the system moves on to check the account determined by Account Determination Group for Services. Finally, if no sales revenue account is maintained, the system assigns a default account during the posting.

As you do not maintain the account determined by both the Account Determination Group for Customers and the Account Determination Group for Services, so the system uses XYZ that is determined by Account Determination Group for Customers.

Resolution

In order to have the sales revenue posted to account XYZ, you can follow the steps below to maintain XYZ as the account determined by both the Account Determination Group for Customers and the Account Determination Group for Services:

  1. Go to the Business Configuration work center and choose the Activity List view.
  2. Select the All Activities subview.
  3. Navigate to the Fine-Tune step.
  4. Open the Charts of Accounts, Financial Reporting Structures, Account Determination activity.
  5. Under the Account Determination section, choose Sales.
  6. Navigate to the Sales section below, and choose the Revenues tab.
  7. From the drop-down list, choose Service.
  8. Choose Add to maintain a new record.
  9. Enter the account determination group for your customer and service.
  10. In the Sales Revenue field, enter XYZ.

Next time, when you post a similar customer invoice to accounting, the sales revenue account XYZ will be used.

Keywords

Account Determination, Customer Invoice, Sales Revenue , KBA , sales revenue , SRD-FIN-ACR , Receivables , How To

Product

SAP Business ByDesign all versions