Vendor Credit Balance

(1) Share

Report

Posted on by Jsabanovski

332

Hello Community,

Is there a way in D365 to see the credit balance remaining on a vendor that includes open invoices and open POs? For example, we have a vendor that has a $1 million limit which we can see in the vendor module under balances but it only shows the $400,000 in open invoices needing to be paid in our system. Is there a way to add open PO's left to receive to that total?

Thank you,

Jet

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Alireza Eshaghzadeh 14,839 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,
You can take this report from vendor transactions on records that are not fully settled (i.e. Open).

There is also information as summary by copilot that can be interesting:

Was this reply helpful? Yes No
Jsabanovski 332 on at

Like (1)

Report
Copy link

Link copied!

Hi Alireza,

That shows the breakdown of my open invoices, but I'm also looking at undelivered PO line items. This vendor includes all open invoices and future orders (e.g., our open PO lines to them) as part of our credit line. I was trying to see an easier way of seeing the cost of the PO lines that are remaining to be delivered and invoiced without actually going to each PO and calculating it out. Unfortunately, I do not have any Copilot function...I assume I have to get with my IT folks to enable that?

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,803 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi,

There is no standard report for Balance + PR, you can only control by Balance + All or Balance + PR from the AP paramater, for the report you can check the vendor balance list with credit limit report and customize it as that too only gives the balance based on the posted, not with open PO or PR.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,839 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The requirement you mentioned appears to be for a custom dashboard that provides insights into open invoices, past due invoices, and whether they are linked to a purchase order, along with the status of the PO.

Was this reply helpful? Yes No