Thank you. CA requires you to break down tax collected by county so we are trying to create a report that includes the address as well so we can access that information but the report I have so far is only displaying 5-6 lines of info.

Add fields to the work table for ARDivision and CustomerNo

Then customize a report setting, using the new work table UDF's to link to the AR_Customer for the bill to address... (assuming you don't use Ship To Addresses that need to be displayed).

If you need the Ship To Address from the actual invoice, you might want to try linking from the work table to AR_InvoiceHistoryHeader, with ARDivision, CustomerNo,InvoiceNo and InvoiceType (which is not 100% without HeaderSeqNo available in the work table).

Using the raw data tables in a custom report is often a challenge because of the table linking (with the tax data stored the way it is).  Modifying a Sage report when the back-end data is complex can be much easier.