List of Vendor Invoices against Payment General Entry

 Between posted Vendor Payment Journal and Settled Invoice only relation is Voucher number in ledger Journal Trans and VendSettlement Table.

So My friends my code snippet is here,

        VendTrans               vendTrans;

        VendSettlement          VendSettlement;

  while select * from VendSettlement

                join  * from vendTrans

                where VendTrans.DataAreaId == VendSettlement.TransCompany

                && VendTrans.RecId  == VendSettlement.TransRecId

                && VendTrans.AccountNum == VendSettlement.AccountNum

                && VendSettlement.OFFSETTRANSVOUCHER == _ledgerJournalTrans.Voucher

Comments

Popular Posts