3641159 - Bank Statement Line Item Report Not Displaying "Open Item ID" for Posted Bank Statements

The "Open Item ID" field in the "Bank Statement Items Details" report displays "#" instead of a value for a posted Bank Statement. 

SAP Business ByDesign

1. Navigate to the Business Analytics work center.
2. Open the Design Reports subview.
3. Search for the report "Bank Statement Items Details" and open it.
4. Enter the following parameters:

• Company
• Statement ID
• Bank Account
• Year (Statement Date)

Observe that the "Open Item ID" field in the report displays "#" instead of a value.

The "Open Item ID" field in the "Bank Statement Items Details" report only displays the Invoice ID corresponding to the Document ID for each line item of the bank statement. If no invoice is associated with the related document and only a payment exists, the field will display "#".

The behavior is as per system design.

To obtain more details, add the "Document ID" field to the Row Fields in the report.

bank statement, open item id, bank statement line item report, bank statement items details, posted bank statement, invoice id, document id, cash and liquidity management, "#" in open item id field, missing open item id, report parameter, sap report troubleshooting , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem