Force Input

bhuber

On the Customer card, I would like to force the user to input a Customer Posting Group. The Not Blank Property only does this if the user enters a value in this field. How can I force input even if the user does not enter a value in this field?

triff

One way of doing this is to put TESTFIELD(Customer Posting Group) on the ONINSERT triger of the form. But you have to set the DELAYINSERT trigger to 'No' or else you can not even start to insert a record.

The only problem with this is that the customer number is not inserted until the whole card is filled in and you move to the next record.

The other option is to put TESTFIELD(Customer Posting Group) on the ONMODIFY trigger of the customer form. ONINSERT gets called with a blank record and puts the customer number in the record.
The problem with this is if you change a record with no Customer Posting Group you are forced to enter on. Of course this may be an advantage.

PAul Baxter

Mohan

Hi,
You can put TESTFIELD("Customer Posting Group") in On Qurey Close Form () trigger,the system won't allow the user to come out of the Customer Card screen until the Customer Posting group filled.
Mohan babu

wbenefiel

This is an ongoing (problem?) situation in Navision. It is simply not designed to force users to enter a specific field. Any work around you come up with will either
1. Wipe out several fields worth of data when it errors and rolls back.

or

2. The user can by pass the error (by not closing the form and instead inserting or moving on the another record. (This doesn't fire the OnQuerryCloseForm trigger)

The best solution I have ever found is to have the users click a "Test" button. This validates all fields and produces a Message not an error of what is wrong/missing. Now the problem here is that the users have to press the button. At some point a user must be held accountable. You could also add a new field that get populated when the users "tests" the new record.

---

Bill Benefiel
NCPS,NCSD,NCDS
Manager of Information Systems
Overhead Door Company of Indianapolis
billb@ohdindy.com