Accounts receivable aging
SQL query for MS Dynamics 365 Business Central (Private app)
Calculate total outstanding amount for each customer based on aging buckets.
SELECT Customers.Name, SUM(AgedAccountsReceivables.Amount) AS TotalOutstandingAmount FROM Customers JOIN AgedAccountsReceivables ON Customers.ID = AgedAccountsReceivables.CustomerID GROUP BY Customers.Name
MS Dynamics 365 Business Central (Private app) data model
Items
Item Categories
Customers
Customer Payments
Customer Payment Journals
Customer Financial Details
Contacts
Vendors
Company Information
Locations
Accounts
Sales Invoices
Sales Invoice Lines
Journals
Journal Lines
General Ledger Entries
General Ledger Setup
Item Ledger Entries
Currencies
Sales Orders
Purchase Invoices
Purchase Orders
Inventory Posting Groups
General Product Posting Groups
Aged Accounts Receivables
Aged Accounts Payables
Sales Credit Memos
Sales Credit Memo Lines
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed