Cash Flow Statement in Sage 300 ERP

By | October 27, 2021

In Sage 300 ERP, A cash flow statement is a financial statement that shows how changes in Bank Transactions, Customers, Sales Orders, Vendors, and Purchase Orders affect cash and cash equivalents in general ledger accounts. This statement then helps to divide the analysis down to operating, financing and investing activities.

New Stuff: Provision to Set Arrival Date for PO Purchase Details

In this blog, we are going to discuss how much cash has flowed through each module such as Accounts Payables, Accounts Receivables, Sales Order, Purchase Orders, General Ledger, Banks, etc., in Sage 300 ERP over the period of time by using the below Filter criteria.

  • From and To Date

The report data will be exported as an MS-Excel exported file based on the user-specified Range of date for which cash flowed in Sage 300 ERP.

Please refer below screenshot of the user interfaces for the “Cash Flow Statement”.

Cash Flow Statement – User Interface


Through the UI developed, user will be able to specify ‘From’ and ‘To’ Date. Based on this, the report will generate appropriate data in Excel format at required path which user will enter in the ‘Select File’ field (as can be seen in above screenshot). User will be able to select required path by clicking on the Browse button.

After entering the excel file path as well as range of parameter, user will be able to export the data. Once the data is exported, user can access the generated excel file directly.

Below is the excel-based generated output of the “Cash Flow Statement” report: –

Cash Flow Statement – Excel Output Data


This report includes following fields and can be modified according to your requirement.

  • Title: Which will contain information like, in case of vendors it will be Sundry Creditors, in case of customers it will be Sundry Debtors and so on.
  • Particulars: Particulars will include Vendor Name, Customer Name, Bank Name, GL Account Number, GRN Number, and Order Number, etc.
  • Balance/Payment: This will include as of bank balances in case of Banks and any other Monthly Fix payments such as Salaries, etc.
  • Date Range (From and To Date selected in UI): How much cash is flown for each date will be displayed against vendors, customers, purchase orders, Sales Orders, etc.

In this way user can easily fetch the required detailed Cash Flow data for a particular period of time, which serves the purpose of this utility. We can also customize this report output with additional fields.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, Salesforce.com (listed on Salesforce Appexchange), Dynamics 365 CRM and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using sData and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.