Ah - I didn't explain the DB: If invoice_idSupplier is "unknown" (i.e. 152) then show invoice_nameSupplier else show supplier_nameShort. (Sorry - a bit crude - I had a problem with old invoices - there was no link and many of them did not match a supplier name)
Sort on invoice_idInvoice desc. (Paul always wants the latest at the top).
Fields (headings) & Order: ID Invoice No.; Invoice Type; Supplier ; Invoice Date; Total ; Supplier Ref.; Date Created .
Will send an EMail with the current layouts for invoice lines so you have something to start with.
Label on left hand column button => "Invoices".
Ah - I didn't explain the DB: If invoice_idSupplier is "unknown" (i.e. 152) then show invoice_nameSupplier else show supplier_nameShort. (Sorry - a bit crude - I had a problem with old invoices - there was no link and many of them did not match a supplier name)
Sort on invoice_idInvoice desc. (Paul always wants the latest at the top).
Fields (headings) & Order: ID Invoice No.; Invoice Type; Supplier ; Invoice Date; Total ; Supplier Ref.; Date Created .
Will send an EMail with the current layouts for invoice lines so you have something to start with.