[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 created the below:
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:
SELECT RefNumber, VendorRefFullname, PurchaseOrderLineDesc,
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:
UPDATE SalesOrder SET PONumber='42' where TxnID='5BDD-1197759656'
Result in QuickBooks