Hello all,

I have this script (code below) that works, but I can't figure out how to get it to run using a customer as the search base. When this script is run I need it to do the script based on the current customer being billed.

Thanks

Dave

I can't read your script, it is way too small.

Since you are on a Mac,

Print your script to Preview, and then copy it and paste into a Reply here.

Lee

If you save the image to your desktop, you can zoom it and see the steps.

Find [Over Credit Limit Invoices] Copy

Perform Script [ “Allow User Abort” ]

Perform Script [ “Set Error Capture” ]

Perform Script [ “Last Layout [store]” ]

Set Field [ QUOTES::KF_CUST_ID_q; QUOTES::KF_CUST_ID_q ]

Perform Find [ Specified Find Requests: Find Records; Criteria: INVOICES::Status: “Billed” ] [ Restore ]

Extend Found Set [ Specified Find Requests: Find Records; Criteria: INVOICES::Status: “Cancel” ] [ Restore ]

Set Variable [ $CreditLimit; Value:Sum(INVOICES::Price_Grand_Total) ]

Set Field [ QUOTES::testfield; $CreditLimit ]

#ABOVE FIELD IS JUST USED TO VIEW THE SUM OF THE INVOICES, USED FOR TESTING ONLY

Show All Records

If [ $CreditLimit ≥ CUSTOMERS::CreditLimit ]

Show Custom Dialog [ Title: "Account over Credit Limit"; Message: " ACCOUNT HAS REACHED IT'S CREDIT LIMIT!"; Buttons: “OK” ]

End If

Perform Script [ “Last Layout [Restore]” ]