Liquidity planning in the sense of Liquidity Planner is the medium term planning (usually covering one year) of incoming and outgoing payments (in other words actual cash flows) in the original currency.
In the operative R/3 system, the liquidity calculation gets actual data for the amount, the use and the origin of payments.
Example:
In Procure to Pay Process, the Vendor sends an Invoice (1a), you pay it (2a) and the process is finished with the Bank Statment (3a).
IMG: Financial Supply Chain Management -> Cash and Liquidity Management -> Liquidity Planner
Tx: FLQC1
A liquidity item stands for the actual origin or use of a payment (for example, incoming payment from sales or payment for salary).
It represents a:
Tx: FLQC2
In this step you define FSCM-LP parameters for the Client. It is not possible to configure by Company Code.
Tx: FLQC4
Liquidity Planner Real Accounts are GL Accounts taken from T012K table (Tx FI12)
In case you need to add/exclude Real Accounts form the Liquidity Planner Analysis, you have to add them here
Tx: FLQC3
Activate the funcionality of Liquidity Planner in the Company Code.
You will need Cash Management and Forecast Number Range for the company code (tx OT20)
tx: FLQC13
Configure how Liquitiy Planner will reconstruct FI document chain (from Bank Statement to Invoice)
5.1 Settings for FI mechanism EhP7 with Business Function FIN_GL_DIR_CASHFLOW
tx: FLQC13F
In ECC 6 EhP7 a new BF is available to display taxes (Separate Tax) and brings the possibility to incorpore new fields in LP Analiisys -
Additional Fields in Liquidity Planner .
6. Create Accounts with assignment information
tx: FLQINFACC
Configure Liquidity Positions by assignning the corresponding GL Accounts. All GL Accounts (except Bank Accounts) are listed here; vendor,customer, tax, expenses, incomes, clearing, etc
7. Create Liquidty Information
tx: FLQAD - pre EhP7
tx: FLQAF - EhP7 with BF FIN_GL_DIRCASHFLOW active
The last step is to create Liquity Information
"Query Sequence" is a step analysis for the line item where you set up conditions which wil redirect the natural flow of the Liquidity Item to a new Liquidity Item choosed by you.
The "1st Derivation Step" generally considers the payment document (Vendor/Customer objects).
The "2nd Derivation Step" generally considers the invoice (G/L Account).
You have to define a query sequence (tx FLQQC5 or FLQQD5) which contains all queries for the corresponding step (tx FLQQC1 or FLQQD1).
The "Buffer Item" is the intermediate position for the payment and the invoice, in general Customer/Vendor reconciliation account
The "Exit Module" contains user exits for each step where you can add liquity item information ( Additional Fields in Liquidity Planner ).
You can use additional selection parameters to analyze the Liquidity Item.
You can run in Test or with "Detail List" to analyze the liquidty item flow. In EhP7 you have a new radio button "Analysis List" to
8. Display Liquidity Item Report
Tx: FLQREP - Payments per Liquidity Item
FLQLS - Liquidity Calculations - Totals list
FLQLI - Liquidity Calculation: Line item List
These reports shows totals ( FLQREP, FLQLS ) or individual line items ( FLQLI )
9. Correct manual positions
tx: FLQAM
Reassign manually the Liquidity Items detected by FLQAD/F to a new Liquidity Item.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 |