static void ExampleJob(Args _args) { VendPackingSlipTrans packingSlipTrans; VendInvoicePackingSlipQuantityMatch VendInvoicePackingSlipQuantityMatch; vendInvoicetrans vendInvoiceTrans; select firstOnly packingSlipTrans where packingSlipTrans.RecId == 5637155083; select firstonly vendInvoiceTrans join VendInvoicePackingSlipQuantityMatch where VendInvoiceTrans.SourceDocumentLine == VendInvoicePackingSlipQuantityMatch.InvoiceSourceDocumentLIne && VendInvoicePackingSlipQuantityMatch.PackingSlipSourceDocumentLine == packingSlipTrans.SourceDocumentLine; info(VendInvoiceTrans.InvoiceId); }
credited to : EYO