Sales Orders to Purchase Orders don't have a LinkedTxn table. But when I created the following Sales Order in QuickBooks:
and got QuickBooks to create a purchase order for me, it created this for me:
with the "Sale Order 4:" link in the memo line! This means I can find the purchase orders for a sales order by doing:
SELECT RefNumber, VendorRefFullname, PurchaseOrderLineDesc, PurchaseOrderLineQuantity FROM PurchaseOrderLine where Memo like 'Sales Order 4:%'
However, the best solution would be to write the PO # back into the SaleOrder. This can be done by doing:-
UPDATE SalesOrder SET PONumber='42' where TxnID='5BDD-1197759656'
|