How to Make a field mandatory in Po draft

[Former Member]

How to make a mandatory field in Po draft ????

Can any body guide me

Regards,

K.Ramasamy

[kothandaraman_nagarajan · Accepted solution]

Hi,

Change object type to 112 in above code.

if @transaction_type = 'A' and @object_type = '112'

begin

if exists(select T.docentry from OPOR T where T.docentry =@list_of_cols_val_tab_del and

(T.comments is null or T.Comments=''))

begin

SET @error = 17

SET @error_message = N'Please enter value, field cannot be blank'

end

end

Thanks.

[KennedyT21 · Accepted solution]

Table Name changed  to draft table..

if @transaction_type = 'A' and @object_type = '112'

begin

if exists(select T.docentry from ODRF T

where T.docentry=@list_of_cols_val_tab_del and

(T.comments is null or T.Comments=''))

begin

SET @error = 17

SET @error_message = N'Please enter value, field cannot be blank'

end

end

Regards

Kennedy

[Former Member]

Not yet but I done an alternate method...While selecting the Taxcode the Fms will update in the field .. So this is the solution I made instead of restricting using stored procedure.. So the field will not be empty

[KennedyT21]

Great mark the thread as assumed answer and close....

[Former Member]

Thanks for the Response kennedy , nagaraj , bhusan

[KennedyT21]

Issue is solved or not...

[KennedyT21]

Close the Thread with the correct and helpful answers

Regards

Kennedy

[agustin_marcoscividanes]

Hi

first, I would customize the field label and I would change the style to bold. I would do this in all fields I want to be mandatory.

Second, you can use the Transaction Notification to check if all mandatory fields have value; or you can use SDK.

Kind regards.

Agustín Marcos Cividanes

[Former Member]

Kennedy Can I get any sample transaction notification for the PO draft document Regards, K.Ramasamy

[Former Member]

Hi Ramasay,

Please find the below query for your requirement.

if @transaction_type = 'A' and @object_type = '22'

begin

if exists(select T.docentry from OPOR T where T.docentry = @list_of_cols_val_tab_del and

(T.comments is null or T.Comments=''))

begin

SET @error = 17

SET @error_message = N'Please enter value, field cannot be blank'

end

end

Please change comments with your desire field.

Regards,

Bhushan Verma

[KennedyT21]

You can Use the Transaction Notification ....

Rgds