Subject: Branch-wise Cash Inflow and Outflow Report in Acumatica

Hi ​@RuwanK 

Proposal for Implementing a Branch-wise Cash Inflow and Outflow Report in Acumatica:
1. Review Standard Reports
Review Cash Account Summary (CA633000) and Cash Account Details (CA633500) to determine whether the standard reports meet the requirements for Branch, reporting period, and total cash inflows/outflows.

2. Define Data Classification
Agree with Management and Accounting on the classification criteria for Local Sales, Import Sales, Bank Facilities, Local PO Payments, Import PO Payments, and other expenses.
Note: Create separate Cash Accounts for business categories only if this reflects the company's actual cash account structure. If multiple categories use the same bank account, classify transactions using appropriate business criteria instead.

3. Build a Generic Inquiry (GI)
Build a GI to validate transaction data, classifications, Branches, and transaction dates, and ensure that cash inflows/outflows are not counted more than once.

4. Design the Report
Use Report Designer or Report Definitions to create a report with Branch columns, a Total column, selectable reporting periods, and total cash inflows/outflows. Prioritize standard functionality before considering customization.

5. Reconcile and Validate
Reconcile the report against Cash Management and the General Ledger (GL), verify sample transactions, and obtain Accounting's confirmation before deploying the report.

Guiding Principle: Prioritize standard Acumatica functionality, standardize data classification, and develop additional functionality only when necessary.

Regards,

NNT

Thanks