Setting

The automatic assignment programs require a set of rules for determining liquidity items. An essential part of the set of rules are queries. Conditions are defined for queries which are used to determine a certain liquidity item. However the queries cannot be used directly in the assignment programs, but merely as part of a query sequence. This sequence is made up of a structured number of queries. This “structure” determines the sequence in which the program processes the queries. The first hit wins. In other words if the conditions of a query apply to a certain sequence, the system assigns the liquidity position of this query to the payment. Any queries that follow in the sequence are not taken into consideration.

Conditions in the query refer to values in certain table fields in the database. There are therefore three types of query with different source symbols:

Bank statement query (category B)
Evaluation of vendor and customer line items in payment documents query (category C)
Evaluation of expense and revenue line items in invoices query (category D)

The three categories cannot be mixed in a sequence; a sequence either has category B, C or D.

Integration

The assignment programs use these sequences:

Assignment with information from bank statements: A sequence with category B must be entered in Customizing (transaction FLQC6) for each bank account.
Assignment with information from customer and vendor line items in payment documents: Enter a sequence with category C in the selection screen.
Assignment in two steps with information from invoices: For the first step you enter a sequence with category C in the selection screen, for the second step enter a sequence with category D.

Prerequisites

The empty query sequences are defined under Assignment in the Customizing menu (transaction FLQCUST).

Activities

Define a Query

Enter a technical key, a description and the liquidity item of the query in the initial screen to define a query. If the query is only intended for a certain paying company code, enter the company code.
Enter conditions in the form of selection options in the following screen. Choose Conditions. Save your query when you return to the initial screen.

Define Query Sequence

From the SAP Easy Access menu under Accounting select Start of the navigation path Liquidity Planner Next navigation step Settings End of the navigation path :

Start of the navigation path Assignment from Bank Statement Next navigation step Set Up Query Sequence End of the navigation path

Start of the navigation path Assignment from FI Next navigation step Set Up Query Sequence End of the navigation path

Start of the navigation path Assignment from Invoices Next navigation step Set Up Query Sequence End of the navigation path

In the transaction for defining the query sequence you first see the empty sequences defined in Customizing. Select an entry and enter the queries for this sequence in the detail screen. Give the sequence a sequential number.

Recommendation

To enable you to enter further queries later with minimum effort, we recommend that you assign numbers in steps of 50s.

End of the recommendation.

Info Accounts (Application)

For the assignment programs that use information from accounting, information can often be derived directly from the G/L account, for example from the cost element. You can use the following transaction to assign liquidity positions directly to G/L accounts to avoid having to define a separate query for each G/L account. Select from the SAP Easy Access menu: Start of the navigation path Accounting Next navigation step Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Settings Info Accounts (Application) End of the navigation path

This assignment is like a final query, in other words, it is used if no explicit query in the sequence was successful.

Note Note

The definition of queries, their grouping into sequences and the direct assignment of liquidity items to G/L accounts do not have a transport link; these are ongoing settings that are carried out directly in the productive system. If you want to keep a number of systems synchronous, in the SAP Easy Access menu under:
Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Settings Upload/Download you will find various programs to help you save these settings from a master system to your local computer for transferring to the other systems.
New queries cannot be created for blocked customer or vendors when the ILM function for Liquidity Planner is activated. Additionally, existing queries with conditions (such as selection options) that involved a blocked customer or vendor will not be displayed in query maintenance transactions and are not considered for evaluation during assignment.

End of the note.