Sage 50 SQL Payment matching to an Invoice or Invoice Item
Posted on 2014-09-12
I want to extract client payments and link these to lines in the invoice_item table to show date paid and amount paid. What fields tables can I use to link these
I have audit_header, audit_usage, audit_split, invoice , invoice_item extracted from sage50 into a sql database - any ideas !