I am trying to run a custom crystal report that pulls customer invoices based on Invoice Date and Sale Type of "GSA".
For the life of me I can't seem to find the table that holds this information.
Thanks in advance.
Invoice History is located in AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail
Thank you.
Sale type sounds like a UDF. Your screenshot is most likely from the AR_OpenInvoice table.
If your UDF is mapped to the history tables, the most likely source will be AR_InvoiceHistoryHeader table.
*Community Hub is the new name for Sage City