Tables involved while opening the voucher transactions from purchase order receipts

 

 1. GeneralJournalAccountEntry

  2. GeneralJournalEntry

  3. SubledgerVoucherGeneralJournalEntry

  4. VendPackingSlipVersion

  5. VendPackingSlipJour

select generalJournalAccountEntry
join SubledgerVoucher,AccountingDate from generalJournalEntry          
where generalJournalEntry.RecId == generalJournalAccountEntry.GeneralJournalEntry
	&& generalJournalEntry.DocumentNumber == _VendPackingSlipJour.packingSlipId
	&& generalJournalEntry.AccountingDate == _VendPackingSlipJour.DeliveryDate
	&& generalJournalEntry.SubledgerVoucherDataAreaId == _VendPackingSlipJour.dataAreaId
exists join subledgerVoucherGeneralJournalEntry
   where subledgerVoucherGeneralJournalEntry.GeneralJournalEntry == generalJournalEntry.RecId
exists join VendPackingSlipVersion 
   where VendPackingSlipVersion.AccountingDate == subledgerVoucherGeneralJournalEntry.AccountingDate
  && VendPackingSlipVersion.LedgerVoucher == subledgerVoucherGeneralJournalEntry.Voucher
    && VendPackingSlipVersion.VendPackingSlipJour == VendPackingSlipJour.Recid;
		

Keep Learning!!