Re: SQL Query

furrywombat — Fri, 27 Mar 2015 16:17:05 GMT

Oh man, I can't believe I missed that. We have hundreds of linked fields... didn't think to use them for this particular purpose. Thanks!

Re: SQL Query

LaCrews — Fri, 27 Mar 2015 14:30:17 GMT

Furry

one possible solution is to flatten the table by adding the fields as method "linked fields". this has worked well for us.

SQL Query

furrywombat — Fri, 27 Mar 2015 13:15:48 GMT

Hey Guys,

I was wondering if it is possible for form a query with a join clause. I'm trying to prepare a function that seeks out transaction line entries that do not refer to any primary transaction. For most transaction lines this is easy... we just query where LinkToPrimaryTable (i.e. SalesOrder, Invoice, etc) IS NULL or = ''. But when an item receipt is converted to a bill in QuickBooks, it deletes the item receipt in Method but not the item receipt lines. Currently, we're flagging these by downloading a record id list from the ItemReceipt table and looping through the ItemReceiptLine entries comparing ItemReceiptRecordID against an ItemReceipt record id array. But if there was a way to get this all done with a single query, I think it would be best.

Possible?

Thanks in advance.

Method:API Q&A

Re: SQL Query

Re: SQL Query

SQL Query