What is the best way to get a check register that shows what payments were applied to what invoices and the accounts and dimensions those invoices were posted to? I have tried the G/L Register and Vendor Ledger Details and have also used the API's to join data, but not a really easy task and still not getting exactly what I am looking for. Any help is greatly appreciated just wondering what everyone else uses?
Thanks,
Tanya
You would need a custom report building for this. If the data can be modelled in raw form Power BI is a possible avenue. Find the pages that expose what you need and have them published as web services so you can pick them up in Power BI.
If this doesn’t breed the desired results then an AL report is the other option
Sohail Ahmed
2,899
Super User 2025 Season 2
Sumit Singh
2,444
Jeffrey Bulanadi
2,304