cancel
Showing results for 
Search instead for 
Did you mean: 

Mark specific as Mandatory in Customer master

former_member327658
Participant
0 Kudos

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

View Entire Topic
narayanis
Active Contributor
0 Kudos

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