Sage 100

Customer is requesting the standard Sage 100 v2015 Standard AR - Report - Accounts Receivable Analysis Report with the ability to select invoice by date. This report seems to use a work file. I'm thinking of modifying the Aged Invoice Report which probably can come close. Anyone ever undertaken a modification of the exact report the customer mentioned?

Avoid it. It's based on AR_Analysis table (old ARX file). It's summarized numerical buckets of info that gets amassed when posting invoices, cash receipts and similar. It's for the whole company code. You can't slice it / dice it by customer or by invoice date (range) or exclude by customer, division or customer type. It's just something pretty you show in an executive staff meeting along with other non-descript charts you find in the BI Dashboard to distract from the primary discussion of poor financial performance for a period. Think Sage exec meetings of the Pascal era. Your idea to modify the A/R Aging Report is an xlnt one. Another one is dare @JeffSchwank that it's not possible to construct sheets of summarized pivot table data in Excel then create charts with it.