Показать сообщение отдельно
Старый 15.05.2019, 22:11   #1  
Blog bot is offline
Blog bot
Участник
 
22,108 / 768 (70) +++++++
Регистрация: 28.10.2006
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, напишите личное сообщение администратору.