Build a collection queue from Business Central’s aged receivables report
Key facts
Use a consistent cutoff, aging basis and currency basis when comparing successive reports.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Set a repeatable report basis
Run Aged Accounts Receivable Excel, report 4402. Set Aged as of and Period length. Choose By period (LCY) for local currency or By Period (FCY) to review foreign currencies. If your company still uses legacy report 120, choose Due Date in Aging by and record whether Print Amounts in LCY is on.
Check sample balances
Set the cutoff to month-end for a month-end worklist. Use CustomerAgingData or the customer ledger entries to check individual documents. Check one large balance and one overdue balance with a recent receipt or credit. Compare the source and export using the same cutoff and currency basis. Investigate differences before treating a bucket as a collection target.
Assign the next action
Create columns for customer, invoice, open amount, due date, owner and next action. Mark blocked items such as unapplied cash, a missing credit or an open dispute. For example, put a $6,000 overdue invoice with a pending $2,000 credit into a credit review queue before asking the customer to confirm the collectible amount.


.webp)