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