Please enable JavaScript.

Coggle requires JavaScript to display documents.

Payment Module – reports - Coggle Diagram

- - - - From Date (mandatory)
        
        Data Source: Report parameter
      - To Date (mandatory)
        
        Data Source: Report parameter
      - (Optional filters as configured: Creditor, Currency)
        
        Data Source: Creditor m./ Currency management (if enabled)
    - - Creditor Code
        
        Data Source: Creditor m – code
      - Creditor Name
        
        Data Source: Creditor.m – name
      - Opening Balance (first row per creditor)
        
        Data Source: Net balance of all AP activity BEFORE From Date (AP invoices/credit notes, payment vouchers/allocations, opening balances)
      - Current CR (within From–To)
        
        Data Source: AP invoice credit-impact transactions in date range
      - Current DR (within From–To)
        
        Data Source: Payment voucher debit-impact transactions in date range
      - Running Balance (row-by-row)
        
        Data Source: Calculated per row: Opening – DR + CR (seeded by Opening Balance)
      - Closing Balance (last row per creditor)
        
        Data Source: Opening Balance ± all transactions within From–To
      - Reference No
        
        Data Source: Transaction header reference
      - Type (AP Invoice / Payment Voucher)
        
        Data Source: Transaction source tables
      - Date
        
        Data Source: Posting/transaction date
      - Narration
        
        Data Source: Transaction description/memo
  - - - Report Date (as-of)
        
        Data Source: Report parameter
      - Currency (mandatory)
        
        Data Source: Currency management (active currency list)
    - - Creditor Code
        
        Data Source: Creditor m.– code
      - Creditor Name
        
        Data Source: Creditor m.– name
      - 0–30 days
        
        Data Source: AP open items allocated by days past due (as of Report Date)
      - 31–60 days
        
        Data Source: AP open items aging
      - 61–90 days
        
        Data Source: AP open items aging
      - 91–120 days
        
        Data Source: AP open items aging
      - 121–360 days
        
        Data Source: AP open items aging
      - Over 360 days
        
        Data Source: AP open items aging
      - Vendor Invoice Number
        
        Data Source: AP Invoices – vendor invoice number (shown per summary design)
  - - - Report Date (as-of)
        
        Data Source: Report parameter
      - Currency (mandatory)
        
        Data Source: Currency management (active currency list)
    - - Creditor Code
        
        Data Source: Creditor m. – code
      - Creditor Name
        
        Data Source: Creditor m. – name
      - Reference Date
        
        Data Source: Transaction reference/posting date
      - Reference No
        
        Data Source: System transaction identifier
      - Document Number
        
        Data Source: Internal/AP document number
      - Vendor Invoice Number
        
        Data Source: AP Invoices – vendor invoice number
      - Description
        
        Data Source: Transaction description/memo
      - Currency
        
        Data Source: Transaction currency code (from transaction header)
      - Amount (±)
        
        Data Source: Outstanding amount in transaction currency (signed)
      - Converted Amount (±) (if required)
        
        Data Source: Base currency equivalent per report conversion logic
      - Aging Bucket (0–30, 31–60, 61–90, 91–120, 121–360, Over 360)
        
        Data Source: Derived by comparing reference/due date vs Report Date
  - - - Invoice No (mandatory)
        
        Data Source: AP Invoices – invoice number
      - Date Range (From–To) (mandatory)
        
        Data Source: AP Invoices – invoice/posting dates
      - CR No / DR No (as configured)
        
        Data Source: AP Invoices – credit/debit reference fields
      - Vendor Name (as configured)
        
        Data Source: Vendor (Creditor) m. – name
      - Amount Range (as configured)
        
        Data Source: AP Invoices – total/line amount
      - Currency (as configured)
        
        Data Source: AP Invoices – transaction currency
      - Vendor Invoice Number (as configured)
        
        Data Source: AP Invoices – vendor invoice number
    - - Date
        
        Data Source: AP Invoices – invoice/posting date
      - Invoice No
        
        Data Source: AP Invoices – internal invoice number
      - CR No / DR No
        
        Data Source: AP Invoices – credit/debit reference
      - Type
        
        Data Source: AP Invoices – document type
      - Vendor Name
        
        Data Source: Vendor master – name
      - Vendor Code
        
        Data Source: Vendor master – code
      - Memo
        
        Data Source: AP Invoices – header memo/description
      - Currency
        
        Data Source: AP Invoices – transaction currency
      - Total Amount
        
        Data Source: AP Invoices – transaction total
      - Converted Amount
        
        Data Source: AP Invoices – base currency amount (per report policy)
      - Status
        
        Data Source: AP Invoices – approval/posting/payment status
      - Vendor Invoice Number
        
        Data Source: AP Invoices – vendor’s document number
  - - - Date Range (From–To) (mandatory)
        
        Data Source: Payment voucher posting dates
      - Tax type Id (as configured)
        
        Data Source: payment voucher/tax management
      - Branch Id (as configured)
        
        Data Source: Bank accounts
      - Payment voucher status (as configured)
        
        Data Source: Payment voucher management
      - From-to voucher No (as configured)
        
        Data Source: payment voucher posting dates
      - Payment catergory (as configured)
        
        Data Source: payment types
    - - Date
        
        Data Source:
      - Payment voucher No
        
        Data Source:
      - Invoice No
        
        Data Source:
      - Narration
        
        Data Source:
      - Voucher value without tax
        
        Data Source:
      - Voucher value with tax
        
        Data Source:
      - Status
        
        Data Source:
      - Cancel reason
        
        Data Source:
      - Tax type
        
        Data Source:
      - Payment account
        
        Data Source:
      - Payment account name
        
        Data Source:
      - Prepared by
        
        Data Source:
      - prepared date
        
        Data Source:
      - Authorized by
        
        Data Source:
      - Authorized date
        
        Data Source: