Mark specific as Mandatory in Customer master

[former_member327658]

Dear Experts,

I have a field in address tab in BP Master where I select Tax Code this field I want it as mandatory for Card Type Customer only.

As we know we can have several Ship To warehouses and for the currently selected warehouse the Tax Code field should be mandatory.

Please let me know how to create notification for this.

Regards,

Kunal Yadav

[narayanis]

Hi,

IF :object_type = '2' AND (:transaction_type='A' or :transaction_type='U') THEN

          Declare TaxCode nvarchar(500);
          SELECT ifnull(CRD1."U_TaxCode",'')INTO TaxCode FROM OCRD Inner Join CRD1 On 

          OCRD."CardCode" = CRD1."CardCode" WHERE OCRD."CardCode" = :list_of_cols_val_tab_del and

          CRD1."AdresType" = 'S';

          if IfNull(TaxCode,'') = '' then

               SELECT 201 INTO error from DUMMY;

               SELECT 'Please Enter Tax Code' INTO error_message from DUMMY;

         END IF;

End If;

Regards