Method Community

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.

FW

Furry

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

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!