Collect the records
Read open invoices, posted payments and the account-owner directory. Select an analysis date and identify the authoritative source of each field used in reconciliation.
Illustrative use case
See which customers still need to pay
Match invoices to payments, find overdue amounts and identify the account owners. Data Bridge prepares a list for follow-up and sends it to a form, spreadsheet or team notification.
ERPSQLUBC AnalyticsEmail
HOW THE WORKFLOW RUNS
ERPSQLUBC AnalyticsEmail
01Collect the records
02Match settlements
03Apply priority rules
04Refresh the worklist
THE CHALLENGE
What slows the work down
Invoice registers and incoming payments are updated in different places. Managers receive a general spreadsheet and must work out which documents have already been paid and who owns the next action. The list quickly becomes outdated, leaving finance and sales working from different versions.
Credit controllers, finance managers and sales leaders.A PRACTICAL EXAMPLE
Illustrative scenario: a finance analyst prepares a morning list of confirmed overdue invoices by account manager. A workflow reads available ERP data, matches payments, calculates ageing and updates a working form in UBC Analytics.
HOW THE WORKFLOW RUNS
From the first step to the right action.
Match settlements
Link payments to invoices using defined keys. Account for partial settlement, adjustments and document statuses that affect the remaining amount outstanding.
Apply priority rules
Calculate days overdue and apply the agreed selection criteria. Add the responsible manager, department and context fields needed to make the worklist useful.
Refresh the worklist
Write the result to a form or table and notify the internal team when required. Review the run status and the date represented by the list.
VALUE FOR THE TEAM
Make the work repeatable.
- Managers receive a focused set of items to work on instead of several sources they must reconcile themselves.
- Shared ageing and payment-matching rules help finance and sales interpret outstanding balances consistently.
- The visible workflow can be maintained when the organisation changes its receivables review criteria.
Keep control of the result.
- Check payment posting status and partial-payment rules before calculating the outstanding balance.
- Restrict access to customer information and distribute the worklist according to each manager’s responsibilities.
- Do not enable automatic debtor messages without a separately agreed process; this scenario prepares internal follow-up.
THE WORKFLOW OUTCOME
Finance and sales gain a consistent overdue-item list with ownership and context, providing a practical basis for organising subsequent actions.
Capabilities behind this workflowFROM IDEA TO WORKING FLOW
Bring your challenge. See a way forward.
Sources, rules and outcomes — let’s build the conversation around your workflow.