cancel
Showing results for 
Search instead for 
Did you mean: 

PAN CARD Number based Assesee Type should selection in BP master Data?

former_member275969
Participant
0 Kudos

Hi Friends

I need PAN Card Number based Assess type Should be selection is mandatary like i will explain

if PAN card   No  BTZPK9368M (Is person pan no)

If PAN card  No   BRTCU1258K(Is Company no)

Based on PAN Card  No 4th letter to be check the validation

that is  In BP master data PAN No , 4th letter is 'P' ,the Assess type in General tab should be  'Individual'

that is  In BP master data PAN No , 4th letter is 'C'or 'F' or 'A' or 'T' or 'B' or 'L' or 'J' or, 'G' ,the Assess type in General tab should be  'Company'


that is  In BP master data PAN No , 4th letter is 'H' ,the Assess type in General tab should be  'Others'


This validation to be check when BP master subject to with holding tax


Please help me out


Regards

REDDY

Accepted Solutions (1)

Accepted Solutions (1)

former_member227598
Active Contributor
0 Kudos

Hi Reddy,

Please create the SP TN for such requirement.

Rgds,

Kamlesh Naware

former_member227598
Active Contributor
0 Kudos

Hi Reddy ,

Please the reference for below SP & make the changes as per your requirements.

IF @transaction_type IN ('A', 'U') AND (@Object_type = '2')

begin

  if exists (SELECT T0.CardCode

  FROM OCRD T0  INNER JOIN CRD7 T1 ON T0.[CardCode] = T1.[CardCode]

  WHERE

       ( substring( T1.[TaxId0],4,1) ='P') and

  

  T0.Cardcode = @list_of_cols_val_tab_del)

begin

set @Error = 10

Set @error_message = N'Make sure PAN No right'

end

End

Rgds,

Kamlesh Naware

former_member275969
Participant
0 Kudos

Hi Sir

I am unable to write this purpose plz write SPTN for this Help me out

Regards

REDDY

former_member275969
Participant
0 Kudos
former_member275969
Participant
0 Kudos

Hi Sir

For above senario i need when PAN  no 4th Letter 'P' it should be Other is mandatory,

For remainaing any other than 'P' it should come  COmpany

Regards

REDDY

former_member275969
Participant
0 Kudos

hi friends

i got the solutions for this

---------------------Select Assessee type as Individual----------------------------------

If @Object_Type='2' and (@Transaction_type='A' or @Transaction_type='U')

If exists (Select s.CardCode from OCRD s inner join CRD7 h on s.CardCode = h.CardCode where (substring(h.TaxId0,4,1) in ('P','H') and s.TypWTReprt <> 'P'

and s.CardCode=@list_of_cols_val_tab_del))

Begin

Select @error ='-2843256',

@error_message ='Select Assessee type as others'

End

end

Regards

REDDYK

Answers (0)