Entering content frame

Function documentation Settings Locate the document in its SAP Library structure

Use

The automatic assignment programs require a set of rules for determining liquidity items. En 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 Liquidity Planner ® Settings:

® Assignment from Bank Statement ® Set Up Query Sequence

® Assignment from FI ® Set Up Query Sequence

® Assignment from Invoices ® Set Up Query Sequence

·        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.

·         

·        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:
Accounting
® Financial Supply Chain Management ® Cash and Liquidity Management ® Liquidity Planner ® Settings ® Info Accounts (Application)
This assignment is like a final query, in other words, it is used if no explicit query in the sequence was successful.

·         

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.

 

Leaving content frame