SAP Knowledge Base Article - Public

2918461 - Transaction Source Undetermined in Cash Position by Transaction Source Report

Symptom

For some lines the transaction source is Undetermined in the Cash Position by Transaction Source (FINPAYU03_Q0002) report.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Go to the List subview in the Reports view.
  3. Search and select the Cash Position by Transaction Source (FINPAYU03_Q0002) report.
  4. Run the report for the default parameters.
  5. Bring in the Row fields Transaction Source, Source Document Number and Source Document Type.

For some bank statements, the Transaction Source is displayed as Undetermined.

Cause

The mentioned Document IDs with the corresponding bank statements have the payment allocations still as In Preparation (not posted).

The payment allocations of the mentioned Document IDs have to be posted for the transaction source to be derived.

You can check this as follows:

  1. Go to the Liquidity Management work center.
  2. Go to the Bank Statements view.
  3. Search and select Document ID ABC (ABC is the document ID) for Bank Account ID DEF (DEF is the bank account ID.).

The Bank Statement ID is HIJ (HIJ is the bank statement ID of the document ID ABC).

The status is Posted.

The Post Processing status is Required.

  1. Click Required to open the bank statement HIJ.
  2. Click View All.
  3. Navigate to the Transactions tab.
  4. Select the Line Item, click the Post Processing status Required.

This opens the payment allocation KLM (KLM is the payment allocation ID).

The status is In Preparation.

The payment allocation of the bank statement HIJ is not yet allocated.

As there is no allocation posted, no transaction source can be derived.

Resolution

You need to post the payment allocations.

  1. Go to the Liquidity Management work center.
  2. Go to the Bank Statements view.
  3. Search and select Bank Statement ID HIJ for Bank Account ID DEF .

The Post Processing status is Required.

  1. Click Required to open the bank statement HIJ.
  2. Click View All.
  3. Navigate to the Transactions tab.
  4. Select the Line Item, click the Post Processing status Required.
  5. This opens the payment allocation KLM.
  6. Complete the allocation.
  7. Click Post.

If the document is not relevant for posting reverse/ void or delete the same.

Keywords

Cash Position by Transaction Source; FINPAYU03_Q0002; transaction source , KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions