PBI Financial Modelling Masterclass – Part 2 AP/AR
Details
Note: This event is published on BOTH SQL Ireland and Fabric User Groups, but future events will just be published on the Fabric User Group. Make sure to join there to get notifications of evnts.
https://www.meetup.com/microsoft-fabric-dublin
Details
If you have to build scalable models and reports for Accounts Receivable and Payable then this session is for you.
We will take you a standard way to model AP and AR that works for every single ERP system and deal with common issues such as:
- Dynamic Aged Analysis
- Reconciling Invoices and Payments
- Dealing with exceptions like FX differences, rounding and bad debt.
- Calculating Balancing
- Introducing an “As Of” Date to show balances at any point in time
Included with this session is a fully downloadable PBIX that you can use to reproduce and learn concepts from.