Step-by-step guides and video walkthroughs for ForesightSA template apps, the on-premises data gateway and Power BI reporting on SYSPRO data.
A full walkthrough of Debtors Age Analysis for SYSPRO, the Microsoft Power BI template app that ages SYSPRO debtors by statement date, measures overdue ageing from the due date and shows the debtors position at any past month-end.
Read the guideInstall the Microsoft Power BI on-premises data gateway in standard mode, step by step, so the Power BI service can refresh reports from your SYSPRO® SQL Server. Four-minute video included.
Read the guideBuild a custom Profit and Loss layout in Microsoft Power BI for SYSPRO, driven by one Microsoft Excel worksheet, the User Defined Mapping (UDM). Free PBIX and UDM download with demo data.
Read the guideA full walkthrough of the Profit and Loss Analytics Power BI template app for SYSPRO ERP — every report page, the Fiscal Year/Month slicer logic (MTD, YTD, and looking back in time), tax, and account mapping.
Read the guideConnect ForesightSA's Profit and Loss Analytics template app to your on-premises or hosted SYSPRO SQL Server using the Microsoft on-premises data gateway. Full video walkthrough and step-by-step guide.
Read the guideQuestions about a guide, a template app or a reporting project? The ForesightSA team can help.
