Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Hi, we have imported the vendor payment journals through data import/export frame work and posted with marked invoices for Invoice settlement. But the settlement was not happend still showing the original invoice in open settlement transactions and the payment transaction also not appeared to do manual settlement. Can anybody give me the solution.
To clarify the issue: You imported lines into a vendor payment journal and posted this journal.
Is that right or did you do something else?
Why did you import those payment lines? Was this for data migration purposes or do you usually import all payments this way?
In addition, can you tell the exact steps you performed to import the journal, link the transactions and post the journal? Did you use the General journal entity? So far I had used this entity, it has no option to provide settlement details before posting.
Yes. I have imported lines into a vendor payment journal and posted this journal.
This is regarding data migration purpose.
I have used opening balances entity to import and have linked the marked invoice for settlement purpose.
It is fine even it has no option to settlement before posting. But my query is I have already posted the journal still neither settlement happened nor payment record shown under open settlement transactions of vendor to do manual settlement.
Can you tell in detail how you tried to mark the settlements?
Hi André Arnaud de Calavon,
There is one field "MarkedInvoice", I have given the existing invoice number in "Markedinvoice" filed. Attached the screenshot FYR
Did you enable the options on the target entity called 'Run business validations' and 'Run business logic in insert and update methods'? Also enabled it on the processing group? If not, it might indeed have skipped the logic to do the actual marking for settlement.
If you have already posted the journal, you have to manually settle the transactions afterwards from the customer form (Settle open transactions).
Yes. It is already enabled. I am not able to do manual settlement also because the payment record is not appeared in "Settle Open Transactions".
Is the transaction marked with the 'Approved' field? If it is not approved, it is also not available for settlement.
Thank you André Arnaud de Calavon.
Yes. It was observed that "Approved" is not marked in VendTrans Table. So, we have taken technical support to mark it as Approved. then transactions are appeared in "Settle Open Transactions".
Business Applications communities