Get Payment Voucher against Purchase Invoice in d365 fo x++

 SettlementViewBuilder settlementViewBuilder = SettlementViewBuilder::construct();

            settlementViewBuilder.parmIncludePaymentJournals(NoYes::No);

            settlementViewBuilder.parmRestrictSearchToOriginalDocument(NoYes::Yes);


            SettlementView localSettlementView = settlementViewBuilder.createView(vendTrans);

            select * from localSettlementView

            where localSettlementView.TransactionType    ==  LedgerTransType::Payment;

Comments

Post a Comment

Popular posts from this blog

Get Current Worker data in d365 fo x++

  In Dynamics 365 F&O, we have HcmWorkerHelper class which gives much information about worker such as department, primary position, current legal entity and so on. The code to get worker’s current position. This gives current worker record. HcmWorkerRecId hcmWorkerRecId = HcmWorker::userId2Worker(curUserId()); HcmPositionRecId hcmPositionRecId = HcmWorkerHelper::getPrimaryPosition(hcmWorkerRecId); The code to get current worker manager. HcmWorker currentWorker = HcmWorker::find(HcmWorkerLookup::currentWorker()); HcmWorker currentWorkerManager = HcmWorkerHelper::getManagerForWorker(currentWorker.RecId); The code to get current worker department. HcmWorker currentWorker = HcmWorker::find(HcmWorkerLookup::currentWorker()); OMOperatingUnit department = HcmWorkerHelper::getPrimaryDepartment(currentWorker.RecId); The code to get current worker legal entity. HcmWorker currentWorker = HcmWorker::find(HcmWorkerLookup::currentWorker()); CompanyInfo legalEntity = HcmWorkerHelper::getL...
Read more

how to write a Display Method in d365 fo x++

    [SysClientCacheDataMethodAttribute(true)]         public  display EcoResDescription ItemDescription()     {         str                                    itemdescription;         InventSum                      inventsum;         InventTable                    inventTable;         EcoResProductTranslation    ecoResProductTranslation;         EcoResProduct               ecoResProduct;         select * from inventTable where inventTable.ItemId  == this.ItemId;         select * from EcoResProduct where EcoResProduct.RecId  == inventTable.P...
Read more