Previous one:

http://scn.sap.com/community/simple-finance/blog/2016/08/17/deep-dive-of-cash-position-details-part1

Cash Position Details in S/4HANA Finance 1605 (aka, Simple Finance)

/wp-content/uploads/2016/08/1_1020717.png

1.       Report main part – Dimensions

/wp-content/uploads/2016/08/2_1020718.png

Comparing with classic FF7A, Cash Position Details provides more flexibilities regarding reporting dimensions, not only covering dimensions that are available in classic cash: Company Code, Planning Level, Planning Group, G/L Account, Bank Account Currency and Summarization Term, but also new dimension: Bank (Bank Country, Bank Group, Bank, House Bank and Bank Rating), Bank Account (Account defined in Bank Account Management, House Bank Account) and Liquidity Item.

2.       Report main part – Key Figures

/wp-content/uploads/2016/08/3_1020722.png

(1) Opening Balance:

Opening balance of the first reporting date is the value date opening balance confirmed by banks, technically speaking, it is the aggregated actual cash flows from One Exposure, could be from Bank Statement, FI Postings on bank G/L accounts, bank balance uploaded via excel, Liquidity Planner actuals or distributed cash management actuals during the period from 1900.01.01 to the day before reporting date.

Opening balance for the following dates are the same as closing balance of the previous date.

(2) Cash Flows:

Cash Flows of the first reporting date is the combination of cash flows whose value date is on the reporting date and before reporting date, so that, overdue cash flows can influence future forecasted balance.

Cash flows of the following dates are only flows whose value dates are on that specific date.

Cash flows show the important attributes: planning level, planning group, liquidity item and direction of cash movements.

Here cash flows are not only forecasted cash flows, most of them are forecasted flows, but if there is actual cash flow whose value date is in future, those flows are also shown as cash flows (for example, with planning level F0).

All cash flows are from One Exposure (FQM_FLOW) and Memo Records (FDES).

(3) Closing Balance:

Closing balance always equals opening balance + cash flows.

(4) Overdue:

Overdue shows all forecasted cash flows (no actuals) whose value dates are before the first reporting date.

(5) Reporting dates for next 7 days

(6) Later:

Later shows all forecasted cash flows whose value dates are after the last reporting date.

Besides Delta with Balance View, Cash Position Details provides Delta View, can be switched by clicking link in bottom-right:

/wp-content/uploads/2016/08/4_1020723.png

In Delta View,

(1) Only cash flows whose value date on specific date are shown for the second and further reporting dates

(2) Flows for all planning levels are shown, application doesn’t differentiate the actuals and forecasts, end user can decide the attribute from planning level itself

/wp-content/uploads/2016/08/5_1020724.png

3.       Report main part – Personalization

(1) Variant of Filters: you can save defined and frequently used selection criteria as your saved variant for Filters.

(2) Variant of Report Layout (View Settings):

/wp-content/uploads/2016/08/2016_08_23_9_19_43_1020725.png

End user can personalize their own layout by defining Column status (show or hide, and sequence), Sort, Filter and Group, and personalization of view settings can be saved as variant as well.

Group settings are quite flexible in standard deliver: Bank, Bank Account Group, Bank Account Currency, Bank Country, Bank Group, Bank Rating, Certainty Level, G/L Account, House Bank, House Bank Account ID, Liquidity Item, Planning Group, Planning Level and Summarization Term.

(3) User Settings

/wp-content/uploads/2016/08/2016_08_23_9_23_36_1020726.png

You can set Scaling, Decimals and Default View in User Settings.

You can find more reference materials in: http://scn.sap.com/community/simple-finance/blog/2016/07/27/how-to-find-reference-materials-for-cash-management-in-s4hana-and-s4hana-finance

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Jimmy Chandra

    Hi Lawrence,

    I have problem at fiori cash management, the system cannot display the Bank account number at the cash position details:

    House Bank, Bank account number and GL-Account are already maintained at BAM.

    Thanks for info,

    Jimmy

    /wp-content/uploads/2016/10/2016_10_04_1047871.png

    (0) 
    1. Lawrence Liang Post author

      Hello, Jimmy:

      Please check the entries in table FQM_FLOW (fields: HOUSE_BANK, HOUSE_BANK_ACCOUNT, BANK_ACCOUNT_ID), Cash Position Details read most of information from FQM_FLOW.

      BR, Lawrence

      (0) 
  2. Nitya Narayanan

    Hi Lawrence – Thanks for the information. I have a question on intra day reporting.

    When we issue a payment from SAP , we have bank clearing account posted with a value date which is same as payment date for eg, 2/28 and updating the cash position report

    Again when we upload the intra day statement, the check payment updates the cash position balance, it does not post a accounting entry but still updates the cash position report with a value date from BAI2 intra day bank statement eg: 3/2

    In this case is it not duplicating the cash position report under different value dates?

     

    (0) 
    1. IGNACIO PABLO KRISTOF

       

      Hi Nitya, for me yes, it  is a duplication. I know a case, in classic cash position, where the company had separate bank accounts for AR and for AP. So what we did is just to remove the AP clearing account from the grouping so Cash Position was only populated from intra day memo records. In S4 we are still implementing, so not 100% sure of what is the response in this system.

       

       

      (0) 

Leave a Reply