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
Post a Comment