Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[TRACY GORDON]

I need to get a Payables remittance report that shows all invoice and credits on a payment and be able to export to excel.

——————————
TRACY GORDON
Accounting Manager
West Star Aviation
——————————

[Jo deRuiter]

In order to get this report you will need to rope in your IT department or GP Partner.  Have them go to Victoria Yudins site to this page https://victoriayudin.com/gp-reports/payables-sql-views/ and use either the “Payment Apply Detail” or the “Payment Apply Detail and GL Distributions” use the view she has generously shared with the public to create the view in your GP environment and then you can deploy the information either as an Excel Refreshable Report or as a SmartList, either way it can wind up in Excel.?

——————————

——————————
——————————————-