Scripting

We wrote a little script for Sales Order Header that checks to see if the customer has old invoices, and if so, offers to place the customer on credit hold (via a Yes/No messagebox). Now our customer wants a script to automatically take their customer off credit hold during cash receipts entry, also via a Yes/No messagebox telling the user that the customer is on credit hold...do you want to remove the hold? It's working, but the only field I could find to validate on was the PostingAmt (i.e ""Amount Received"" on the Cash Receipts screen). Am I missing something, or are the CustomerNo and ARDivisionNo fields missing from the Column Post-Validate (and Column Pre-Validate) field list?

One rule I've heard is that columns that are part of the primary key are not available for column events, you can instead use the table post read event as it will be triggered even when a new key is created.

I'd trigger the script Pre-Write on the header.

Ah, makes sense. This is my first Cash Receipts script. Thanks guys.

You may also be able to do a UI script and trigger it post-load.

I know you're looking for a scripting solution but FYI I think DSD has a modification that can remove credit hold upon cash receipts.