3674671 - Incorrect Liquidity Item Derivation in Cash Flow Analyzer – S/4HANA Cloud Public Edition

• Liquidity items are not derived correctly in Cash Flow Analyzer report in SAP S/4HANA Cloud Public Edition.
• For vendor payments (document type ZP), the system assigns the liquidity item for vendor invoices (VENDOR_INV) instead of VENDPAYMENT.
• For customer invoices (document type DR), the defined liquidity item (CUSTOMER_INV) is not assigned; instead, the default item (LQPOS_IN) is shown.

SAP S/4HANA Cloud Public Edition

1. Maintain the query sequence in SAP S/4HANA Cloud Public Edition.
2. Create journal entries which meets the condition of the maintained queries.
3. Go to Cash Flow Analyzer and observe that the liquidity item is derived incorrectly.

• One of the query which maintained in the query sequence without any condition maintained.
• Incorrectly configured queries are ranked higher (appear before correctly configured queries) in the query sequence. 
• The system matches items to derive liquidity according to the order of the query sequence. If there is an incorrectly configured query in the sequence, the system will report an error regardless of the correct configuration of subsequent queries, leading to incorrect liquidity item derivation.

1. Use app Schedule Job for Rebuild Tool for Liquidity Item to identify the issue:

• Run job Rebuild Liquidity Items in Accounting Documents.
• Maintain the Line Item parameters.
• Select off "Rebuild Flows for Chged Items".
• Run the job and an error throws out "Query XXXX X: condition doesn't exist"

2. Maintain the condition for the query with issue in Define Queries for Liquidity Item Derivation.

Liquidity item derivation, Cash Flow Analyzer, CFA, incorrect liquidity item, vendor payment, customer invoice, S/4HANA Cloud, VENDPAYMENT, VENDOR_INV, CUSTOMER_INV, query sequence, INCO_PAY, rebuild tool, liquidity item condition, FLQQA5, 105878, 105900, GB01. , KBA , FIN-FSCM-CLM-2CL , Cash Management (Public Cloud) , Problem