You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!