Now Available in Community - New TechTalk Videos for 2020
2020 release wave 1 Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I try to create a report on Power BI to show a list of vendors with their invoice status (Paid and Unpaid). My question is which entities contains those information on Dynamics 365 for operations entreprise edition
Thanks in advance.
You can find it out from Vendor transactions form (VendTrans table). Go to vendor master > Transactions > Settlement tab and see last settled amount(SettledAmountMST), if its zero that means payment is not done and Invoice has balance. Simple logic would be If AmountMST = SettledAmountMST then invoice is fully paid .
as Sukrut Parab mention you, you can find it from the transaction
also, you find unpaid from open vendor invoices or settle transaction
And, you can find invoices stelled partially or fully in undo settlement form
You can view open vendor invoices cross Company from the wotkspace vendor payment
Did you find a solution to this? Can not see that any of the answers gives you what you are asking for?
You dont have to change workspace to view vendor payment (open invoices) cross Company but it might require a centralized payment organisation hierarki with relevant legal entities
Business Applications communities