AP_Invoices joins for Supplier Detail where vendor_id is negative
Summary:
Sql question, I am looking for ap_invoices_all joins where vendor_id is negative, for the following scenarios; - expense (vendor id = -10016), one time suppliers (vendor_id = -999) and receivables (vendor_id = -222)
Content (required):
I am looking for ap_invoices_all joins where vendor_id is negative, for the following scenarios; - expense (vendor id = -10016), one time suppliers (vendor_id = -999) and receivables (vendor_id = -222), where the 'standard join' via vendor id will not give me the Supplier detail, can anyone point me at any documentation / blog etc which details this so I can construct a sql query?
Tagged:
0