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 represents 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 represents a temporary Bank Statement).
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Go to the Bank Statements view.
- 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
- Go to the Business Configuration work center.
- Open the Charts of Accounts, Financial Reporting Structures, Account Determination activity.
- Under Account Determination choose Cash.
- Select the Account Determination Profile XYZ.
- Go to the Cash Receipt - In Transit tab.
- Press Add Row and enter following data:
- Account Determination Group for Cash: ABC.
- Payment Method: Leave the field empty.
- Currency: Leave the field empty.
- Cash Receipt - In Transit: ID of the G/L account Cash in Transit.
- 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 , tmp , account determination is missing for cas , SRD-FIN-CLM , Cash and Liquity Managment , How To