Using credit limit field in PM to compare against open payables balance

(0) Share

Report

Posted on by lrecker

200

I am trying to find an easy way to keep up with track of what our available credit line is with our big suppliers. I have entered all the vendor credit limits in the vendor table but would like to have an SQL that would use that data and the open payables by due date to generate a report that would show what our available credit line is by week by vendor for the next month.

*This post is locked for comments

All responses (2)

Answers (1)

lrecker 200 on at

Like (0)

Report

RE: Using credit limit field in PM to compare against open payables balance

That is what I was looking for.

Thanks

Lisa
Verified answer

Victoria Yudin 22,768 on at

Like (0)

Report

RE: Using credit limit field in PM to compare against open payables balance

Hi LRecker,

I think this is what you're looking for: victoriayudin.com/.../sql-view-for-current-payables-aging-in-dynamics-gp