Hi friends, 

We have a business requirement to have a vb script that would pop up a message box on the sales order entry as soon as we tab out of customer no field or set as a user-invoked button. 

If the customer has any open invoices that are past due?  The logic should do a table-level query to AR_OpenInvoice where screen.customerno = table.customerno and table.balance > 0 and table.invoiceduedate < currentdate.

In case anyone has come across a similar requirement or solution, could you please share your findings. Also if there is alterate solution approach, please recommend and advise.

Thanks

AJ