Mandatory field

If you are OK with using an add-on product you might take a look at the Business One Usability Package (B1UP) from Boyum-IT. You can get more information at http://www.b1up.net">www.b1up.net. This has functionality to make just about any field, including UDFs, as mandatory.

In the SDK forum there some postings about this. This can be acomplished using the SBO_SP_TransactionNotification store procedure.

Regards,

WB

Through normal use of SAP B1 making a field mandatory is not possible. Only UDFs can be made mandatory.

However a workaround would be to create an aproval procedure based on the field in question "not null". This way if an entry has not been made in this field, it will fire off the approval procedure. if you name the A.P. accordingly when the user goes to add the marketing document, the message will appear with the name of the A.P. and an opourtunity for the user to enter a remark before sending it to the approver. <b>If</b> the user reads the title of the A.P. they should realise that they need to fill this field in, and so click cancel and enter the mandatory field.

A quick way is to enter this piece of code in the SP_TransactionNotification trigger. This one makes the Customer reference field mandatory on the sales order:

If @object_type = '17'

begin

Declare @refcli as nvarchar(2)

Select @refcli =

(SELECT top 1 T0.NumAtCard

FROM ORDR T0

where T0.docentry = @list_of_cols_val_tab_del

order by NumAtCard

)

from ORDR where docentry = @list_of_cols_val_tab_del

if @refcli='' or @refcli is null

begin

set @error = 1

set @error_message = 'No Customer References !'

end

end

WOW - talk about coincidence...there is another alternative to this - SAP B1 lets you handle it several ways...

one customer wanted a similar type of situation to be an alert message to the supervisor of ten employees due to the number of errors coming up with the missing field...so we wrote something quick and it helped resolve the issue within a week (although the supervisor still has the alert message on).

Isayah - see the thread titled "User Defined Query and Alerts" by Groovy UK...it might be a possible alternative?