Please enable JavaScript.
Coggle requires JavaScript to display documents.
Receipting Module – Reports - Coggle Diagram
Receipting Module – Reports
Report 1 – Receipt Transaction Report
Input Parameters
From Date — Date — Mandatory
To Date — Date — Mandatory
Status — Dropdown — Optional
Branch — Dropdown — Optional
Currency — Dropdown — Optional
Debtor — Dropdown — Optional
Intermediary — Dropdown — Optional
Account Handler — Dropdown — Optional
Sundry Transaction Type — Dropdown — Optional
Receipt Type — Dropdown — Optional
Amount From — Number — Optional
Amount To — Number — Optional
Output Parameters (Field → Data Source)
Date → Receipt Note Management
Receipt No. → Receipt Note Management
Status → Receipt Note Management
Receipt Type → Receipt Note Management
Customer Name → Debit Management
Debit Note No. → Debit Management
Generated User → System Security
Sundry Transaction Type → Miscellaneous Transaction Type Management
Currency → Receipt Note Management
Exchange Rate → Receipt Note Management
Receipt Amount → Receipt Note Management
Converted Receipt Amount → Receipt Note Management
Paid Amount → Receipt Note Management
Converted Paid Amount → Receipt Note Management
Excess Collected → Receipt Note Management
Converted Excess Collected → Receipt Note Management
Cancelled Date → Receipt Note Management
Cancelled User → System Security
Cancelled Reason → Receipt Note Management
Report 2 – Debtor’s Ageing Report Summary
Input Parameters
From Debtor Code — Number — Optional
To Debtor Code — Number — Optional
Debtor Group — Dropdown — Optional
Currency Code — Dropdown — Optional
As at Date — Date — Mandatory
Status — Dropdown — Optional
From Ref. No. — Number — Optional
To Ref. No. — Number — Optional
Ageing Periods — Number — Optional
Output Parameters (Field → Data Source)
Debtor Code → Debt Management
Debtor Name → Debt Management
Total → Debit Management
Ageing Range 1 → Debt Management
Ageing Range 2 → Debt Management
Ageing Range 3 → Debt Management
Ageing Range 4 → Debt Management
Ageing Range 5 → Debt Management
Report 3 – Ageing Analysis Report Detail
Input Parameters
From Debtor Code — Number — Mandatory
To Debtor Code — Number — Mandatory
Debtor Group — Dropdown — Optional
Currency Code — Dropdown — Optional
As at Date — Date — Mandatory
Status — Dropdown — Optional
From Ref. No. — Number — Optional
To Ref. No. — Number — Optional
Ageing Periods — Number — Optional
Output Parameters (Field → Data Source)
Debtor Code → Debt Management
Debtor Name → Debt Management
Voucher No. → Debt Management
Total → Debt Management
Ageing Range 1 → Debt Management
Ageing Range 2 → Debt Management
Ageing Range 3 → Debt Management
Ageing Range 4 → Debt Management
Ageing Range 5 → Debt Management
Report 4 – Cheque Register (Returned & Postdated)
Input Parameters
From Date — Date — Mandatory
To Date — Date — Mandatory
Bank — Dropdown — Optional
Branch — Dropdown — Optional
Amount From — Number — Mandatory
Amount To — Number — Mandatory
Cashbook (Ledger Account) — Dropdown — Optional
Output Parameters (Field → Data Source)
Cheque No. → Cheque Management
Cheque Date → Cheque Management
Bank → Collection Banking / Handover
Branch → Collection Banking / Handover
Status → Cheque Management
Received From → Debt Management
Currency → Cheque Management
Amount → Cheque Management
Utilized Amount → Receipt Note Management
Debit Note No. → UW
Received Date → Receipt Note Management
Received By → System Security
Receipt No. → Receipt Note Management
Deposited Date → Collection Banking / Handover
Amount (Deposited) → Collection Banking / Handover
Deposit Slip No. → Collection Banking / Handover
Bank Account No. → Collection Banking / Handover
Deposited User → System Security
Reason for Return → Cheque Management
Report 5 – Deposit Slip Register
Input Parameters
From Date — Date — Mandatory
To Date — Date — Mandatory
Cashbook — Dropdown — Optional
Bank — Dropdown — Optional
Branch — Dropdown — Optional
Payment Mode — Dropdown — Optional
Amount From — Number — Optional
Amount To — Number — Optional
Deposited User — Dropdown — Optional
Output Parameters (Field → Data Source)
Date → Receipt Note Management
Deposit Slip No. → Collection Banking / Handover
Payment Mode → Receipt Note Management
Currency → Receipt Note Management
Exchange Rate → Receipt Note Management
Amount → Receipt Note Management
Converted Amount → Receipt Note Management
Bank → Collection Banking / Handover
Branch → Collection Banking / Handover
Deposited Date → Collection Banking / Handover
Deposited User → System Security
Status → Collection Banking / Handover
Reconciled Date → Collection Banking / Handover
Reconciled User → System Security
Returned Date → Collection Banking / Handover
Returned User → System Security
Returned Remark → Collection Banking / Handover
Receipt No. → Receipt Note Management
Report 6 – Deposit/Excess Detailed Report
Input Parameters
From Date — Date — Mandatory
To Date — Date — Mandatory
Branch — Dropdown — Optional
Amount From — Number — Optional
Amount To — Number — Optional
Currency — Dropdown — Optional
Received By — Type Search — Optional
Output Parameters (Field → Data Source)
Received Date → Deposit Excess Management
Received By → System Security
Receipt No. → Deposit Excess Management
Amount → Deposit Excess Management
Utilized Amount → Deposit Excess Management
Refunded Amount → Deposit Excess Management
Balance Amount → Deposit Excess Management
Type → Deposit Excess Management
Report 7 – AR Invoices Listing Report
Input Parameters
From Date — Date — Mandatory
To Date — Date — Mandatory
Branch — Dropdown — Optional
Amount From — Number — Optional
Amount To — Number — Optional
Currency — Dropdown — Optional
Customer Name — Type Search — Optional
Output Parameters (Field → Data Source)
Date → AR Invoice (AR)
Invoice No. → AR Invoice (AR)
CN or DN number → AR Invoice (AR)
Total Amount → AR Invoice (AR)
Converted Amount → AR Invoice (AR)
Type → AR Invoice (AR)
Customer Name → Debt Management