Hello OS community,
I am currently developing my Cash Flow Statement and I want to add a condition for a loan account. If it has a positive balance in the Working Capital Requirement variation flow, I want to map it under one CFS table. However, if it has a negative balance, I want to map it under a different CFS table. How can I implement this condition in my Cash Flow Statement?
The answer depends on how you are computing your Cash Flow.
If you are computing the Cash Flow dynamically (DynamicCalc members), then for each of the two cash flow members that could receive the loan account balance, you will need to retrieve the source loan account balance, and depending on the signage, return the value or return nothing.
If you are using stored calculations (be it FormulaPass or BusinessRule), you would need to obtain the source loan account balance, and based on the balance write to one or the other Cash Flow line. If you know how to use data buffers, this can be handled quite efficiently.
With stored calculations, there are few other options too, depending on how creative you want to be and how you might be computing the bulk of the cash flow.
Hello Rhankey,
Thank you for your response. We are actually computting the Cash Flow Dynamically. I added in our dynamic calc business rule as you said lines to retrieve the source loan account balance, and depending on the signage, return the value or return nothing , and it works for the workflow statement. But we are still facing an issue in the cashflow drill details. I mean, we still see the amount in both CFS table. I'm wondering if we can add a condition in the mapping of the matrix.
Do you have any idea how can I do it please?
Thank you in advance for you help.
Kind regards,
Your business rule for Calculation Drill Down can return whatever intersections you would like. Since you are computing the formula dynamically, you will need to perform a similar test in the Calculation Drill Down logic too.
Of course, if you have any rollups in the Cash Flow hierarchy, you might need the dynamic calc parents to make a similar consideration too.
