cancel
Showing results for 
Search instead for 
Did you mean: 

Need small information... about oinv address

Former Member
0 Kudos

hi.

I am running below query in sql..

select Address  from OINV where oinv.CardCode = 'CE73'

it is coming from invoice under logistic tab..

My problem is that

some invoices are having with TEL:+39 02 25459028 and some are not having with Tel:+  at logistic tab.

if i need Tel no what should i do....

EPE ITALIANA S.R.L VIALE SPAGNA - 112 ANG  VIA S. MARIA-20093 COLOGNO MONZESE (MI) ITALY TEL:+39 02 25459028

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI. any information plz..

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check under Business partner data--->Address tab. You can add telephone number in address lines. Once added you can get in query as well as in print.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

hi.

thanks for your reply...

this is address i have seen at sales invoice at logistics tabl

EPE ITALIANA S.R.L

VIALE SPAGNA - 112 ANG

VIA S. MARIA-20093

COLOGNO MONZESE (MI) ITALY

TEL:+39 02 25459028

if i see the bp master address... under ship to or bill to

there is no telephone address from where it was captured

any information plz update me..

Former Member
0 Kudos

HI,

May be it was updated by the user manually for certain invoices as this information does not exist in the BP master data.

You may also check log files.

Thanks,

Joseph

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Add telephone number under BP master data--->Bill to address-->Address line

Thanks & Regards,

Nagarajan

Answers (0)