VendInvoiceJour -> Financial Voucher table relations

SELECT A.* FROM GeneralJournalEntry A
INNER JOIN GENERALJOURNALACCOUNTENTRY B ON B.GENERALJOURNALENTRY=A.RECID
INNER JOIN SubledgerVoucherGeneralJournalEntry C ON A.RECID=C.GENERALJOURNALENTRY
WHERE
C.VOUCHER IN(
SELECT LEDGERVOUCHER FROM VendInvoiceJour WHERE PURCHID='PO-14010189'
UNION
SELECT COSTLEDGERVOUCHER FROM VendInvoiceJour WHERE PURCHID='PO-14010189')
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s