Skip to Content
0
Former Member
Jul 23, 2008 at 02:37 AM

On hold if outside payment terms

71 Views

Hi all,

In B1 its possible to activate a system that alerts if BP is over credit or commitment limit.

What my cust needs is a system that sets the BP to 'on hold' if the BP is outside payment terms.

So if there are any open invoices that are overdue or outside pay terms for this BP...

Are there any queries in existance that would make this possible.

I suppose this would be a type of update query....

All thoughts appreciated.

Thanks,

John