default delivery address in goodsreturn

[former_member208987]

Hi,

is there a way to get the default delivery address from BP in goodsreturn on tab logistic. Maybe FMS??

thx

Mark

[Former Member · Accepted solution]

Hi

Here is your stuff.

select isnull(t0.street,'')+' '+char(13)+isnull(t0.zipcode,'')+' '+isnull(t0.city,'')+char(13)+isnull(t0.country,'') from crd1 t0,ocrd t1
where t0.cardcode=t1.cardcode
and t0.cardcode=$[$4.1.0]
and t0.adrestype='S' and t1.mailaddres=t0.street

Regards

Taimoor

[Former Member]

Hi,

Check this , I hope it will work for you.

select isnull(t0.street,'')' 'isnull(t0.block,'')' 'isnull(t0.city,'') from crd1 t0,ocrd t1

where t0.cardcode=t1.cardcode

and t0.cardcode=$[$4.1.0]

and t0.adrestype='S' and t1.mailaddres=t0.street

Regards,

Taimoor

[former_member208987]

Hi Taimor,

I changed it a little bit.

select isnull(t0.street,'')' 'isnull(t0.zipcode,'')' 'isnull(t0.city,'') from crd1 t0,ocrd t1 where t0.cardcode=t1.cardcode and t0.cardcode=$[$4.1.0] and t0.adrestype='S' and t1.mailaddres=t0.street

Is it possible to give the result of the query in 2 separated lines.

street

zipcode + city

country

THX

Mark

Edited by: M. Hageman on Jun 7, 2010 3:30 PM

[zal_parchem2]

Hello Mark - a small suggestion as your question is a bit unclear and folks might be able to answer it quicker...

Do you mean you want the ship to address from the vendor to appear and in what field on the Goods Return Logistics Tab?

Take care and good luck - Zal

[former_member208987]

Hello Zal,

correct, the default shipto address from the vendor in the shipto field on the logistic tab in goodsreturn.

I have created now an FMS which gives the address from the goodsreturn. But the default shipto address of the vendor would be nicer.

Select $[ORPD.ADDRESS]

gr, Mark