Mandatory fields

chamarthi509

Hi all,

I created mandatory fields for the Item table.
I called the function in OnInsert() of table & OnQueryCloseform() trigger

But it is allowing me to create new record even if all the mandatory fields were not given :roll:

Please can anyone help me.

Thanks in advance.

Regards,
Mani

Luc_VanDyck

That's something which is very difficult to accomplish in NAV. Search the forum for some different approaches: http://lmsmfy.com/?q=mandatory+fields

kriki

If you are using NAV2009R2, maybe there is a way, but it might be dangerous:
Use the OnDatabaseInsert- and OnDatabaseModify-functions in codeunit 1. Put there you controls and you are sure that you intercept all. ALSO inserts/modifies done by programs!!!!!!

So probably you need to check it if the Description-field is filled in. The insert of T27 is done to save the new key from the numberseries so the numberseries can be freed again for others.