cancel
Showing results for 
Search instead for 
Did you mean: 

Address of Business Partner

Former Member
0 Kudos
77

Hi

     I want to print the address of Default Contact person of Business partner

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Try:

SELECT T0.CardCode, T0.CardName,T1.Address

FROM OCRD T0

Inner join ocpr t1 on t1.name =t0.CntctPrsn

WHERE T0.[CardCode] = '[%0]'

Answers (3)

Answers (3)

pvsbprasad
Active Contributor
0 Kudos

HI,

Try this

SELECT T0.[CardCode], T0.[CntctPrsn], T1.[Address],  T1.[Street], T1.[County] FROM OCRD T0  INNER JOIN CRD1 T1 ON T0.CardCode = T1.CardCode WHERE T0.[CardCode] = [%0]

Regards,

Prasad

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Sunny Brar,

Please try this:

SELECT T0.[CardCode], T0.[CntctPrsn], T1.[Address], T1.[Address2], T1.[Address3], T1.[Street], T1.[County] FROM OCRD T0  INNER JOIN CRD1 T1 ON T0.CardCode = T1.CardCode WHERE T0.[CardCode] = [%0]

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi,

Do you want have a list or print on certain documents?

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon

    I will give the option to user to select Business Partner & that Business Partner Default Contact Person address i want to print . I don't want list. It will be one at a time.

Thanks

KennedyT21
Active Contributor
0 Kudos

Hi Sunny Brar...

Try This change the fields required..

SELECT T0.[CardCode], T0.[CardName],t1.Address

FROM OCRD T0

Inner join ocpr t1 on t0.cardcode=t1.cardcode

WHERE T0.[CardCode] = [%0] 

Hope Helpful

Regards

Kennedy