Issue in Vendor payment history when posting multiple vendor transactions on the same voucher

  • Article

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;
    ...