Mandatory field

[Former Member]

Hi,

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

by

Isayah

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

my mail id isayah_i@yahoo.co.in

isayahisaac@gmail.com

[Former Member · Accepted solution]

Hi Davinder,

Can you please forward the word document to me too? My email id is gyaneshrupani@hotmail.com

Regards,

Gyanesh

[Former Member · Accepted solution]

hi please to email too...my email is htarranco@gmail.com...

tnx in advance..

[vincent_provendier · Accepted solution]

Hi Davinder,

Can you please forward the word document to me too? My email id is sebastien.guy@parrot.com

Best Regards,

Sébastien

[Former Member · Accepted solution]

Hi Davinder,

Can you please forward the word document to me too? My email id is alvnpraveen@gmail.com

Best Regards,

praveen

[Former Member · Accepted solution]

Hi Davinder,

Can you please forward the word document to me too? My email id is cheung7@gmail.com

Thanks.

[john-paul_dellaputa · Accepted solution]

Can you please tell me if the word document is an official SAP one, and where it came from?

Or please send it to: jp@advance.on.net

Thanks,

JP.

[Former Member · Accepted solution]

Hai Davinder,

Please send me a copy of Word Document. My email address : ssrraja@yahoo.com.

Thanks & Regards

Raja.S

[Former Member · Accepted solution]

Greetings,

Hi there guys, I cant email the document one at a time to everyone, so I've taken a step to host it on Rapidshare, and you can download it from there.

The link is below:

http://rapidshare.com/files/72809879/How_to_make_system_field_mandatory.doc.html

<i>SAP Mods, do let me know if I'm not allowed to have an external link to a file share /file upload site here</i>

[Former Member · Accepted solution]

Hai Davinder,

Thanks. I have received your Word Document FIle.

Regards

Raja.S

[Former Member · Accepted solution]

Hi Everyone,

Please send me a copy of Word Document.

My email address : Magesh2006@gmail.com.

Regards

Magesh.

[former_member1092910 · Accepted solution]

Please share!

jm.angel@unlimitedelectro.com

[zal_parchem2]

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?

[Former Member]

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

[Former Member]

Hi,

I personally use this option.

I've extended it, with two external tables to make this configurable by a functional consultant.

At the end, I have only to create single rows in UDT (directly in B1), with configurable error messages.

Regards,

Eric

[Former Member]

Hello Eric,

can you please explain your concept with the UDTs in more details.

Thank you in advance,

Anton

[Former Member]

Hi,

Yes I can...

Taking time (for personnal reasons...) to answer.

But for sure, I'll do it in the following days.

Regards,

Eric

[Former Member]

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 <a href="http://www.b1up.net">www.b1up.net</a>. This has functionality to make just about any field, including UDFs, as mandatory.

[john_treweeks]

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.

[Former Member]

thanks for replying my query,

if u sent your reply more simple manner it will be easy to understand for me as i am new to sapb1

[Former Member]

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

Regards,

WB