NumAtCard field to be made compulsory

[Former Member]

Hi all ,

I want to make Customer/Vendor reference number mandatory.

How can I do it?

Plz help ..

Regards

Amol A Mangalkar

[former_member583013]

What document are you adding, SO, PO,...?? It could be due to the wrong Object type.

[gilbert_ngo2]

Hello,

I am adding an A/R Invoice. I'm using the Object_type='13'. The stored procedures works during Update Mode, but in Add mode, it won't block the saving of the ducument.

[former_member583013]

Amol,

Add this Code to the transaction Notification Stored Procedure. Change the Obj_type to the document type you want.

<i>OBJECT TYPE = 13 (A/R Invoice)

OBJECT TYPE = 15 (Delivery)

OBJECT TYPE = 17 (Sales Order)</i>

IF @object_type='13' AND (@transaction_type='A' or @transaction_type='U')

BEGIN

IF EXISTS (SELECT DOCENTRY FROM OINV WHERE (LEN(NUMATCARD)<1 OR NUMATCARD IS NULL) AND DOCENTRY= @list_of_cols_val_tab_del)

BEGIN

SELECT @Error = 1, @error_message = 'No Custromer Reference Entered'

END

END

Regards

Suda

[gilbert_ngo2]

Hi Suda Sampath,

I tried your query in SAP Stored Procedure, but it still got posted when i haven't enter any numatcard or customer reference number? I'm using SBO2005 SP1 PL18.

[Former Member]

add an approval to kick off if its blank or

check the value of the field on the formdataevent before add.