Jim,
If VendorTable is not shared between virtual companies then something like:
SELECT vtable.Name,
vt.AccountNum,
vt.TransDate,
vt.Voucher,
vt.invoice,
vt.txt,
vt.AmountCur,
vt.SettleAmountCur,
vt.AmountMst,
vt.SettleAmountMst,
vt.CurrencyCode,
vt.dueDate,
vt.ExchAdjustment,
vt.dataareaid
FROM
Our auditors are looking for a report of payments and invoices by vendors. Is
there a way to right a sql against the vendtrans and possibly the vend
settlement tables to provide a list of payments and also invoices, not paid,
per vendor?
Is there a better document or book available than, the
2 matches
Mail list logo
