Apologies, I am not familiar with the data but I think it will be by order.
I need to link the following query to vendtrans to get the invoice for each order. I cannot find the field voucherdataareaid
SELECT GJE.JOURNALNUMBER,GJE.SUBLEDGERVOUCHER FROM GENERALJOURNALACCOUNTENTRY GJAE
INNER JOIN GENERALJOURNALENTRY GJE ON
GJAE.GENERALJOURNALENTRY = GJE.RECID
Thanks