Liquidity Planner Configuration
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).
Configuration
IMG: Financial Supply Chain Management -> Cash and Liquidity Management -> Liquidity Planner
1. Create Liquity Item
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:
- Expense or Revenue
- Vendor / Customer (only GL Accounts)
- Taxes (If you want to open taxes in a document)
- Other GL Accounts (ie: GR/IR Account, clearing accounts, others
2. Set Global Data for Company Code
Tx: FLQC2
In this step you define FSCM-LP parameters for the Client. It is not possible to configure by Company Code.
- Liquidity Items to use when no position could be assigned. (N.Assign.In.Pmt , N.Assign.Out.Pmt)
- Liquidity Items for default Incoming and Outgoing Cash.
When the Liquidity Item has been identified as Incoming or Outgoing but can’t reach the next level. It’s on the Bank Statement Level. - Posting Date. Use Posting Date instead of Value Date for the calculation
- 3rd Currency Another Currency for Analysis
3. Add additional Real Accounts (Bank Accounts)
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
4. Activate Company Code
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)
5. Settings for FI Mechanisms
tx: FLQC13
Configure how Liquitiy Planner will reconstruct FI document chain (from Bank Statement to Invoice)
- Part Reassign: Consider partial payments or “part of the payment line item is reassigned in cases where the payment amount is not fully covered”
- N:M Treatment: If various actual positions (N – Bank) are related to variuos vendor/customer positions ( M ), the system can reconstruct the information with artificial possitions
- Inc.Transfer: Bank Incoming for N:M Treatment
- Out.Transfer: Bank Outcoming for N:M Treatment
- Info Accts in Appl: Information for Accounts is maintained in each systema (tx FLQINFACC)
- Down Pmt no-End: In Downpayments, the system still tries to go to he expense/income generated by the payment.
- Eval. Intermed.Stat: In GL Accounts with “Line item Management” (tx FS00), if you set the further indicator for the GL Account in tx FLQINFACC , the system continues searching for the clearing account (i.e: GR/IR Accounts)
- Reduction of Document Cluster in FI: You can add exits, for example display invoice tax or withdholding tax (Pre EHP7) . sap note 994316, 1091325, 1092506
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.
Hi
Thanks for sharing such wonderful document..
Regards
Mahmoud EL Nady
Hi, pretty nice and simple explanation. I'm just bit missing how to maintain/create conditions and how to work with items with special indicator. But whatever, well done.
Jan
Thanks for your comments. Good to hear it helped.=)
Conditions are maintained with FLQQC1 (Vendor/Customer) and FLQQD1 (Expenses/Incomes).
There are different types of conditions, based on Master Data (G/L Account, Vendor) or document (Header , Line Item).
Supposed you have a Liquidity Item for "Maintenance Services" but your company has a special project to expand a section of a factory. You post expenses to the same account but this is posted to a WBS Element. You would like to separate WBS element from normal operations. You should use a query.
Try with t FLQQC7 or FLQQD7 and try if the query works.
I worked with Sp.G/L Indicators through the G/L Account,
Kind Regards
Back to spec. gl indicator... You mean, you assign GLs for e.g. down payments direct without indicator?
My problem exactly now is, that my qry just want not to work if I specify spec. gl indicator with GL but also with account type D/K/S. I've tried also different sequences of qrys.. It just not work.
The only way I'm able to assign such items to liqui item is using dirct mapping using FLQINFACC.
I'm just curious why it does not work by me with qry. 🙂
In FLQC13 I marked partial reassignment, N:M, Info Accnt apply and order inf.
Even I tried all possible combination, this combination works for me. But anyway, no assignment of DPs or other spec.ind. will follow if I will not specify them direct in FLQINFACC
Do you have some experiences with that?
Do you prefer to map reconciliation GLAs in FLQINFACC or rather use qry?
I guess for recon. and so for spec. ind. GLAs will be always FLQINFACC better one, do you agree?
Thank you a lot
Jan
Hi Jan,
You need the SpGL account in FLQINFACC to be recongnized by Liq. Planner and then you could use a query.
I haven't used a query as you suggested, with SpGl, it should work but no promises 🙂
Kind regards
Hi Gustavo,
thanks for confirmation 🙂
Yes, with spec.GL.indicator it does not work properly. 😉
Thank you again
Jan
Dear Gustavo,
awesome blog ! thanks for sharing it.
I have a question, Currently we are in 1503 SP5 version and need cash and liquidity management function however we are not opted for BPC system licence. Could you please tell me whether this version will work for cash & liquidity without BPC licence, I read somewhere its not possible to have cash & liquidity without BPC. Could you please share you thoughts.
Hi Jain,
In 1503 it is not possible (sapnotes 2044295 & 2149337), It think this was added in 1511 (2270400).
Kind Regards
Thank you very much appreciate your time.
Dear Gustavo,
Thanks for sharing this nice piece of work.
I'm currently working on S/4 HANA on premise version 1709.
Would like to find out if you are aware that the function of manual reassign liquidity item (tx: FLQAM) in ECC6 is no longer available in S/4 Hana on premise (1709) version?
Do you know how to re-assign the liquidity item in S/4 Hana CM on premise version 1709 ?
Many thanks in advance!
Kind regards,
Ling
Hi Ling,
FLQAM is not available any more in S/4 HANA :(.
I've read you can reassign it with "Cash flow - Detailed Analysis" Fiori app.
https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F1737')/S9OP
Kind Regards
https://help.sap.com/viewer/ac319d8fa4ea4624b40a58d23e3c4627/1709%20000/en-US/c76d8054f87c033de10000000a441470.html
Hi Gustavo,
Many thanks for your quick response and I have tried on the APP mentioned and it works:)
Really appreciate it. Thanks !
Dear Gustavo,
Could you please let me how to use "buffer item" in the S/4 Cash management? It seems the logic has been changed already. Currently I am using S/4 HANA 1709.
I would like to use "buffer item" to define liquidity item via FI document chains (from FI payment to invoice in MM).
Best regards,
Yipeng
Hi Yipeng,
Check sap note 2580031, 2608617.
https://blogs.sap.com/2017/03/27/flow-builder-to-integrate-fi-and-mm-in-new-cash-management-overview/
https://blogs.sap.com/2018/09/03/flow-builder-understand-the-difference-in-trigger-mechanism-manually-created-job-event-based-job-and-technical-job/
Kind Regards
Dear Gustavo,
Thank you for providing these great blogs.
Now I understand that based on flow types, the Flow Builder traces the document chain back to its source (FI invoice). But I still have problem that I have the FI document posted from MM Good receipt. Cr: GR/IR, Dr: Expense G/L account. because Flow builder doesn’t drill down to MM from FI to get the liquidity item. At this point, the final quilidity item will stop at GR/IR, not the liquidity item for Expense G/L account. Now I have 2 questions.
Thanks for your advise.
Best regards,
Yipeng
There is no buffer item as used before. It has been replaced by Flow Types which have a defined funciton, however you could try on FLQINFACC to add the further checkbox.
Check table FQM_FLOW on data.
Here are some recomendations on what I would do. h
1) 2512327 - One Exposure: Assign Flow Types To G/L Accounts
To update flow Types inn BSEG -> tx FQM_UPD_LITEM
FQM_UPD_FLOW_TYPE all documents
2) Activte MM in FQM -> FQM_ACTIVATE
3) Check tx FLQINFACC with further
4) Rebuild FQM
5) Analize logs -> tx FQM_APPLICATION_LOG
6) read some notes :-s
2369432 - Flow Builder: Generate and Assign Loading Class
2518457 - One Exposure: Rebuild flow type, Part II
2559374 - Flow Builder: Logic Refine for Delta Run
2560395 - Flow Builder: Setup Background Job listen to Event
2580031 - FAQ : Liquidity item assignment into one Exposure( FQM_FLOW )
2684381 - FI Flow Builder: Built-In Packaging Support for Delta Run
2729344 - Flow Builder MM: Avoid processing MM procedures when MM is not active
Hope it helps
Kind Regards
Dear Gustavo,
Thank you for the advice.
I did some attempt, and still failure to derivate the "liquidity item" for MM document (Purchase order). I think that is why I could not show the final liquidity item in the "cash flow analyzer" fiori report.
What I have done for the configuration.
WHen I create a Purchase order for expense account, the data was loaded in the FQM_FLOW, but no liquidity item was assigned in the data.
Do you have any suggestions?
Best regards,
Yipeng
Sorry, I don't have a scenario to test it. Open an OSS message.
Dear Gustavo,
Thank you for the following up.
Please let me update.
Thank you for your support. Your blogs are valuable!!! I appreciated.
Best regards,
Yipeng
Dear Yipeng
I will appreciate your support, I did the same step as you mention previously
I executed FQM_UPD_LITEM and the FCLM_FLOW_BUILDER but no derive liquidity item for expense accout, just stop en GR/IR. I have a doubt about the type of liquidity item for GR_IR , must be IO o just O (Output) ?
Best Regards
Felix Tello
Dear Gustavo,
Thank you for providing these great documents. I have a question about currency swap; if I activate this button (FLQC2 ) ı can see all the transaction in FLIQITEMFI table for 3 currencies ? I mean company code currency, group currency and hard currency.
Regards,
Merve
Hi,
I have not used it. More than 3 currencies its a change in the transaction currency.
The example given is: The company is US based and you have an Invoice in GBP. You pay the invoice in USD but would like to see the report in the Original Currency (GBP) instead of Bank Currency (USD).
Hope it helps.
Kind Regards
Hi,
Okay thank you so much for your quick response ! 🙂
Best Regards
Dear Gustavo,
We're currently working on ECC6. I would like to know if there is a report that allows you to display calculated liquidity items. For example, the sum of two positions. Maybe from report painter?
Muchas gracias
Un saludo