Liquidity item manually assignment (Liquidity Planner process)

[Former Member]

Dear colleagues,

Can you please give me an advice in Liquidity Planner process.

I am trying to assign the liquidity item manually to payment document in FLQAM transaction. But I have the error: u201CNo line item exists for FI document <CompCode> <№doc> <year> 000. Message no. FLQ015u201D.

So can I assign the liquidity item for payment document manually if I donu2019t use automatic assignment from Bank statement, FI document and invoice?

The customizing which Iu2018ve done for liquidity planner:

FLQC1 - Liquidity Items creation;

FLQC2 - define default liquidity item values for incoming and outgoing payments documents (incoming payments, outgoing payments, incoming transfers, outgoing transfers);

FLQC3 - Company code activating for Liquidity Planner;

FLQC13 - Liquidity Calculation: Use Partial Information Maintain Info Accounts in Application; Get Information from Orders; Open G/L Account Lines are End Point; Completed per Company Code.

FLQC4 u2013 actual accounts except house bank accounts;

Thank you in advance.

Best Regards.

[rodolfo_bermudezneubauer3]

Hi FSCM-LP fans,

I realize this post is quite old, but thought I'd share some insights on the calculation logic behind the Liquidity Planner from my

experience. Regarding the previous posts, if LP customizing is completed (as it seems is the case above) and you're not seeing updates in the totals tables double-check the following: A. Company Code is active in Tx FLQC3 and B. Transitory Bank Account is included in Tx FLQC4 This customizing will effect all future FI postings that involve "cash accounts" (i.e. Bank Accounts + GL accounts in FLQC4) in relevant Company Codes (entered in FLQC3) and an online transfer from the General Ledger to the LP tables (FLQITEMFI) will take place per each new FI posting.

This is referred to as the "First Step" in the Liquidity Calculation. Optionally, you may choose to transfer the Bank Statements as a previous and initial step (filling table FLQITEMBS). The "Second Step" is required for Period-end closing and is carried out through Tx FLQAD (or FLQAL). Here the line items generated in the "First Step" are further processed with the LP logic using the clearing items and off-setting entries through what is called the "document chain". The "document chain" will begin with an incoming/outgoing flow from a "Cash Account" (Bank and GL Accts in FLQC4) and will end when navigation through off-setting entries and clearing documents leads to a final "Liquidity Item". Functionally, the logic behind the liquidity calculation can be explained as follows: start by identifying all incoming and outgoing "Payment" flows in cash accounts (Step 1) and then attempt to follow a document chain (cleared "Invoices" and line-items) until final Liquidity Item(s) can be assigned to the "Payment".

The main mechanism for assignment of end-points to the document chains is by direct assignment of G/L Accounts to Liquidity Items in Tx FLQINFACC. Here you should assign Liquidity Items to all P+L accounts and a few B/S accounts (i.e. Fixed Assets, Inventory, Taxes, etc). Additional assignment logic can be accomplished through queries/sequences and furthermore though custom ABAP function modules at various points of the liquidity calculation (whenever the query logic is not enough).Very Nice! Simple, yet powerful! **

So, back to the example, in order to succeed with the second step, you sould have the "Expense" account entered in Tx FLQINFACC ***. This determines the end-point of the document chain and thus a final "Liquidity Item". The calculation logic builds the document chain by navigating through the cleared off-setting line items until a final "Liquidity Item" is determined. In this case, the final "Liquidity item" is determined by direct assigment of the "Expense" account **** Any item that is not automatically assigned to a valid "Liquidity Item" in this second step (i.e. incomplete document chain) will then require a manual posting in the LP as a third and final step. If all goes well, these will be the unavoidable exceptions that by nature cannot be dealt with any of the assignment mechanism.

As part of the going-live preparations (assuming you are not using direct transfer from Bank Statements into LP), you will need to execute two further steps in order to transfer previous FI documents and historical data into the LP tables: C. Execute report RFLQ_BALANCE_CF for initial balance carry-forward of cash and equivalents (see SAP Notes). D. Transfer previous FI postings to the LP planner using Tx FLQC10

After this you should be "live" and will be able to carry out the "Second Step" as well as manual postings using FLQAM and FLQT1. If you still don't see table updates after FLQC10, you are likely missing some customizing steps for BTE (Business Transaction Events). Have a look at the following notes regarding LP set-up and technical documentation:

412605 Implementation of the Liquidity Calculation

591208 Liquidity Planner Technical Documentation

791744 N-M Logic for the Liquidity Calculation

614240 Rules for the Second Step in FLQAD

642555 Assignment of reversal documents (IMPORTANT!!!)

Good luck to all!

Regards,

Rodolfo Bermúdez Neubauer

[rodolfo_bermudezneubauer3]

... continues

• This is why it's called the "Direct" Cash Flow, because every flow is "directly" assigned to it's source at a document level. As opposed to the "Indirect" method, where cash flow variations are explained through an elaborated reconciliation of P/L and B/S statements at an account level.

• See Function Group ZFLQSAMPLE for examples delivered by SAP. Also look for reports starting with RFLQ

• IMPORTANT: before executing the second step have a look at SAP Note 642555: Assignment of reversal documents

• However, beware that "real-life" posting scenarios will surely require more challenging and complex assignment logic than this simple two document example. The assignment logic can become quite complex (!!!) when you have many offsetting entries and clearing documents that require splitting individual payment flows into several Liquidity Items (eventually leading to N:M relationships and line-item hell!). As part of the LP implementation you should be open to and allow for a few minor changes in accounting and clearing procedures in order to simplify document chains.

Cheers

[Former Member]

Hi,

Check table FLQITEMFI and FLQITEMBS; any entries in there can be manually assigned via FLQAM. If you make a payment for an individual amount, say thru FB01 (Dr Vendor, Cr Cash), that entry ends up in FLQITEMFI and can be manually assigned a liquidity item thru FLQAM; since they are not processed by automatic assignment.

Manish

[Former Member]

Thank you, Manish, for your reply!

As I understand, in FLQITEMBS table there is the information about posting in first area (BankAcc0 u2013 BankAcc3).

But do we need to assign Liquidity item to these postings? How can we assign liquidity item to Second area posting (made in FEBAN)? Or we donu2019t?

When does the information put into the FLQITEMBS and which information?

And when does the information put into the FLQITEMFI and which information?

Thank you!

[Former Member]

Hi,

If liquidity calcualtion is active, line items for bank statement documents go to FLQITEMBS and line items for other FI documents go to FLQITEMFI. A line item is created for every FI document line item on GL accounts in table T012K or those defined in FLQC4 and also for customer and vendor line items.

FLQAB, FLQAC and FLQAD are used to automatically assign liquidity item to these line items. Manual assignment of liquidity items to a single payment can be done using FLQAM. This may be required when you don't want to change the automatic assignment mechanism rules and want to do a one-off manual assignment.

Manish

[renfeproyectoau]

Hello,

Related to this previous question, I do not get any data in tables in FLQITEMBS or in FLQITEMFI. The bank account has beeen introduced in the FLQC4.

All other customizing has been introduced:

FLQC1 - Liquidity Items creation;

FLQC2 - define default liquidity item values for incoming and outgoing payments documents (incoming payments, outgoing payments, incoming transfers, outgoing transfers);

FLQC3 - Company code activating for Liquidity Planner;

FLQC13 - Liquidity Calculation: Use Partial Information Maintain Info Accounts in Application; Get Information from Orders; Open G/L Account Lines are End Point; Completed per Company Code.

FLQC4 u2013 actual accounts except house bank accounts;

It is a sample example:

Creditor (cleared) ===> Transitory bank account

Expense ==== Creditor (cleared)

Any idea?

Kind regards,

Dani

[Former Member]

Hello Dani,

I have some question to try to help you about this topic:

1) Transitory bank account have been included in FLQC4 as a actual account??

2) Have you already runned transaction FLQAD ou FLQAC without test run? If the payment do not have in table FLQITEMFI, you can not run FLQAM to manually classification (Error FLQ015)

3) The last one...have you already runned program RFLQ_INIT to set up th LP online with the G/L postings??

I hope I can help you...

Regards,

Mario Barros