I want to Download in Excel (from Sage 100) an Accounts Receivable Open Invoice Report. The problem is that the reports that I found in the AR module shares excel columns, for example, the AR aging will share the customer name with the invoice number. I want a Sage downloadable report to Excel that gives me a column for customer name, another column for Costumer #, another column for Invoice #, Another column for invoice date, and so on for Invoice amount, and invoice open amount (sometimes customers will underpay an invoice leaving an open balance for it) The most info concerning this scenario the better. Example of the Excel report will be column A Customer name: row A2 Discovery100 Column B Customer# row b2: 985 column C Inv# row c2: 478 and so on with inv date 10/12/2018, original invoice amount: 100, payment amount 20, payment date: 12/30/2018, payment type Check# 125, and balance left 80.00. I need all the customers with all the open invoices even if they had a 0.10 balance.
293
370
