Skip to Content
author's profile photo Former Member
Former Member

Mandatory field

Hi,

Is It possible to make any field mandatory in documents or item master,customer in SAPB1.

by

Isayah

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2007 at 01:48 AM

    I have a Microsoft Word file that takes you through the steps, drop me an email so I can send it to you

    Message was edited by:

    Davinder Singh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2007 at 01:40 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2007 at 08:16 PM

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

    Regards,

    WB

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 06, 2007 at 09:30 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 10, 2007 at 06:25 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2007 at 12:08 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.