2587056 - Bank Statement Posting - Account Determination is Missing for Cash

SAP Knowledge Base Article - Public

2587056 - Bank Statement Posting - Account Determination is Missing for Cash

Symptom

You are not able to post a Bank Statement due to error message:

'Account determination is missing for cash. Define the account for chart of accounts XYZ , tab Cash Receipt - In Transit' field 'Cash Receipt - In Transit' field 'Cash Receipt - In Transit. Enter a general ledger account for the account determination group ABC and currency Euro.'

(XYZ represents the Account Determination Profile and ABC represente the Account Determination Group for Cash)

The status of the bank statement is In Preparation.
Instead of the usual numeric Document ID AAA (AAA represents the Bank Statement) , the Document ID is TMP-BBB (TMP-BBB representes a temporary Bank Statement).

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Go to the Bank Statements view.
  3. Open the respective Bank Statement and press Action - Post.

You receive the error message:

'Account determination is missing for cash. Define the account for chart of accounts XYZ , tab Cash Receipt - In Transit' field 'Cash Receipt - In Transit' field 'Cash Receipt - In Transit. Enter a general ledger account for the account determination group ABC and currency Euro.'

Cause

The Bank Statement contains one or more items with a payment method for which there is a Cash account determination required.

Resolution

  1. Go to the Business Configuration work center.
  2. Open the Charts of Accounts, Financial Reporting Structures, Account Determination activity.
  3. Under Account Determination choose Cash.
  4. Select the Account Determination Profile XYZ.
  5. Go to the Cash Receipt - In Transit tab.
  6. Press Add Row and enter following data:
  7. Account Determination Group for Cash: ABC.
  8. Payment Method: Leave the field empty.
  9. Currency: Leave the field empty.
  10. Cash Receipt - In Transit: ID of the  G/L account Cash in Transit.
  11. Confirm with Save.

You are now able to post the bank statement.
The status of the bank statement will change to Posted and the document ID will change from TMP-BBB to a numeric document ID.

Keywords

tmp, bank statement, Cash, in transit , KBA , account determination is missing for cas , tmp , SRD-FIN-CLM , Cash and Liquity Managment , Problem

Product

SAP Business ByDesign 1711