{"product_id":"debtors-age-analysis-for-syspro","title":"Debtors Age Analysis for SYSPRO","description":"\u003cp style=\"font-size: 16px; color: #4a5568; line-height: 1.7; margin: 0 0 16px;\"\u003eDebtors Age Analysis for SYSPRO is a Microsoft Power BI app for accounts receivable (AR) aging, aged debtors reporting and credit control on SYSPRO ERP, with charts that follow the International Business Communication Standards (IBCS). It calculates outstanding balances, overdue invoices and collections from SYSPRO invoice and payment history for any selected month-end.\u003c\/p\u003e\n\u003cp style=\"font-size: 16px; color: #4a5568; line-height: 1.7; margin: 0 0 16px;\"\u003eOne As Of Date slicer sets the reporting date for the whole report. When a past month-end is selected, every report page shows the debtors position as it stood on that date: the outstanding balance, the age of each invoice, the overdue amount and the amounts collected.\u003c\/p\u003e\n\u003cp style=\"font-size: 16px; color: #4a5568; line-height: 1.7; margin: 0 0 8px;\"\u003e\u003cstrong\u003eKPIs\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul style=\"font-size: 16px; color: #4a5568; line-height: 1.7; margin: 0 0 16px;\"\u003e\n\u003cli\u003eTotal outstanding, Not yet due and Overdue balances, with the change against the prior month-end\u003c\/li\u003e\n\u003cli\u003eOverdue ageing: overdue amounts by days past the due date\u003c\/li\u003e\n\u003cli\u003eInvoice ageing: outstanding amounts by invoice month\u003c\/li\u003e\n\u003cli\u003e% Overdue and Due in next 30 days\u003c\/li\u003e\n\u003cli\u003eDays sales outstanding (DSO), Collection effectiveness, Avg days delinquent and Avg days to pay\u003c\/li\u003e\n\u003cli\u003ePlanned collections against amounts collected, and balances rolled to older age buckets\u003c\/li\u003e\n\u003cli\u003eCredit used, Credit available, Amount over limit and Days until limit reached\u003c\/li\u003e\n\u003cli\u003eDrill-through from a customer to the open invoices and the payments allocated to them\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp style=\"font-size: 16px; color: #4a5568; line-height: 1.7; margin: 0 0 16px;\"\u003eThe majority of SYSPRO sites have hosted SQL servers and require a Microsoft on-premises data gateway. Installation guide: \u003ca href=\"https:\/\/www.foresightsa.net\/blogs\/guides\/install-power-bi-on-premises-gateway-syspro\"\u003eInstall the Power BI on-premises gateway for SYSPRO\u003c\/a\u003e (video: \u003ca href=\"https:\/\/www.youtube.com\/watch?v=iEvz1r4nHC0\" target=\"_blank\" rel=\"noopener\"\u003ewatch on YouTube\u003c\/a\u003e).\u003c\/p\u003e\n\u003cp style=\"font-size: 14px; color: #718096; margin: 0;\"\u003eAvailable free on Microsoft AppSource with sample data; a licence key from ForesightSA connects it to a live SYSPRO database.\u003c\/p\u003e\n","brand":"ForesightSA","offers":[{"title":"Default Title","offer_id":48022035988657,"sku":null,"price":0.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1999\/0849\/files\/debtors-age-analysis-syspro-01-overview-20261014.png?v=1791990824","url":"https:\/\/www.foresightsa.net\/products\/debtors-age-analysis-for-syspro","provider":"Foresight SA","version":"1.0","type":"link"}