Vendor Invoice Status, (Paid and Unpaid)

(0) Share

Report

Posted on by Community Member

Hi All,

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.

Categories:

Finance and Operations

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Sukrut Parab 71,741 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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 .

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Sten Baumgarten 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi kmerouane

You can view open vendor invoices cross Company from the wotkspace vendor payment

Kind regards

Sten

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Kmerouane,

Did you find a solution to this? Can not see that any of the answers gives you what you are asking for?

Was this reply helpful? Yes No
Suggested answer

Sten Baumgarten 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

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

Kind regards

Was this reply helpful? Yes No