Skip to Main Content
Sage BusinessWorks Ideas Portal
Status We're Taking A Look At This
Created by Nicole C
Created on Aug 8, 2025

Excel XLSX Exports for All AP Reports in BW (Good Ones) With the Ability for Us to Customize the format and data

Excel XLSX Exports for All AP Reports (Good Ones) with the Ability for Us to Customize the format and data. I need to be able to run pivot tables and vlookups, and other functions on the data from the AP reports. The formats available to me now are very useless if I try to copy them into Excel. The data in the columns and rows doesn't line up with the headings. Some data share the same cells when they should be in their own cells. There are random merged cells and rows. There are lines and objects throughout. There are empty rows and repeated report title information throughout the report. There are total rows throughout that I wouldn't need if my data were Excel-compatible. We need clean Excel-compatible data from the Accounts Payable module. Honestly, it's 2025. I can't believe I'm requesting this.

  • Attach files