PT Sterling Tulus Cemerlang



Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

Using Formula in Statement of Cash Flow Report

As we know, SAP Business One already provide us a standardize template Statement of Cash Flow. And, you can easily create new line item that consist of some formula.  But, this formula only can work with line items, not for other function or selected queries.

For example, we can use standard “Statement of Cash Flow” template from SAP that consist of 3 line item header: Cash Flow from Operating Activities, Cash Flow from Investing Activities, Cash Flow from Financing Activities.

From this menu Main Menu à Financial à Financial Report Templates, you can easily generate a report templates for “Statement of Cash Flow”.

This is how to do it :

  1. Choose Report : Statement of Cash Flow
    SAP_BusinessOne_Tips-STEM-Using Formula In Statement Of Cash Flow Report_01
  2. Choose Template : Defined New
  3. Add New Template – In this example, we give the template name : TEMP01
    SAP_BusinessOne_Tips-STEM-Using Formula In Statement Of Cash Flow Report_02
  4. Click on buton Update
  5. Click on button Generate From Cash Flow Line Items, and then click Update
  6. After that, system automatically generate all cash flow line item into your new template.
    SAP_BusinessOne_Tips-STEM-Using Formula In Statement Of Cash Flow Report_03
  7. You can easily edit/ add new line item with your own personal preferences.
  8. For example, you want to add new line item “Other Payments – Local” and “Other Payments – Overseas” and another new Line items “Total Other Payments (Local & Overseas)” to Summarize this two new line items :
    Click on Add Same-Level Account. Fill in the name of new line items, adjust the position and then click Update.
  9. Tick a Subtotal field, click Formula, choose (+) or (-) and determine your own line item formula definition.
    SAP_BusinessOne_Tips-STEM-Using Formula In Statement Of Cash Flow Report_04
  10. After finish it, just click on button Update  once again and your customized formula for Statement of Cash Flow is saved and can be use.

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: or call +6221-5806336 or wa +6287786555055

, ,