[QODBC-Desktop] How to link Purchase Orders to Sales Orders
Posted by brad waddell on 12 March 2009 05:21 PM

     Sales Orders to Purchase Orders don't have a LinkedTxn table.

Sales Order Created in QuickBooks

     Created the following Sales Order in QuickBooks:

Purchase Order Created in QuickBooks

     Get QuickBooks to create a purchase order. It made the following:

With the "Sale Order 4:" link in the memo line.

Find Purchase Orders for a Sales Order

     This means I can find the purchase orders for a sales order by doing the following:

     SELECT RefNumber, VendorRefFullname, PurchaseOrderLineDesc,
     PurchaseOrderLineQuantity FROM PurchaseOrderLine
     where Memos like 'Sales Order 4:%.'

Write the PO# Back into the SalesOrder

      However, the best solution would be to write the PO #back into the SalesOrder. This can be done by doing the following:

      UPDATE SalesOrder SET PONumber='42' where TxnID='5BDD-1197759656'

Result in QuickBooks

(157 vote(s))
Not helpful

Comments (1)
20 September 2012 10:48 AM
I rellay needed to find this info, thank God!
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).