Issue in Vendor payment history when posting multiple vendor transactions on the same voucher
Scenario:
When posting multiple vendor transactions on the same voucher the Vendor payment history inquiry may not appear as expected.
Resolution:
To resolve the issue the following change can be made to \Forms\VendorPaymentHistory\Data Sources\VendInvoiceJour\Methods\initQueryforEPandCheckInvoices
From:
...
select firstonly VendTransId from ledgJourTrans
where ledgJourTrans.Voucher ==_lastSettleVoucher
&& ledgJourTrans.VendTransId;
...
To:
...
select firstonly VendTransId from ledgJourTrans
where ledgJourTrans.Voucher ==_lastSettleVoucher
&& ledgJourTrans.AccountNum == vendAccount
&& ledgJourTrans.VendTransId;
...