alirazazaidi: List of Vendor Invoices against Payment General Entry
Источник: https://www.tech.alirazazaidi.com/li...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
Haaapy Daxinggg
Источник: https://www.tech.alirazazaidi.com/li...general-entry/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
|