Bill to adresses

[Former Member]

Hi all,

i want to ask that i have not entered any value in BILL TO adress & the customer adress is filled in SHIP-TO Adress.I have taken both the databases at the PLD.NOw when i hve not entered any value in bill-to adress then also it is picking showing the value by default,how should i avoid these.Its rare that bill-to adress is filled.Rep asap.........

mona

Edited by: Darius Heydarian on Mar 25, 2008 5:58 PM

[former_member186095]

Hi madam,

I suggest to escalate this problem to SAp Support. I've tested your problem, it is okay in my database the bill to address is unavailable in the PLD where in the BP address tab --> bill to address is emptied.

Rgds,

[Former Member]

Hi jimmy,

Here in Adress Field Each & every thing is taken Separately such as BILL to street,block,city,zipcode.Ship to is reflecting properly but not the Bill To.Rep ASAp

mona.

[former_member186095]

I am sorry that you have problem with the report. I have suggested you to share this issue to SAP support.

Rgds,

[Former Member]

Hi,

ok thanx a lot i will do that.

Regards

mona

[Former Member]

Hello Mona,

Please clarify what you are asking.

1. What documents are you printing? (AR Invoices?)

2. Do you have a Bill-to address on the BP Master?

3. Are you saying that your printed documents (the PLD?) are showing a Bill-to address? If so, what field does the PLD say should be printed where the Bill-to address is appearing?

Regards,

Douglas McDove

[Former Member]

actually bill-to adress is empty tghen also in pld it is showing the value.

[former_member583013]

The Bill-to address could be empty on the Screen but on the PLD the field mapped could be something else.

You have to look into the PLD and see what database fields are mapped in the area where you see the Bill to address.

Suda

[Former Member]

Dear suda,

I hve picked up the same database that is empty.I had picked up Bill-to street,block city which is required smetimes.even if the screen is blank then then also by default it is showing the same adress filled in ship-to adress why so.?

mona

[former_member583013]

In a marketing document, the Billto address is stored is one single field called Billto. It is found in the Header table. Example ORDR.Billto for Sales Order Bill to.

When you refer as Billto Name, Street, Block, it refers to BP Addresses / Master table.

Is this the case?

Suda

[Former Member]

Hi,

yes u r rght.....these is the case.but i had to pick up the value from master & not from the sales order table,layout is disturbing wht should i do in such case........

mona

[Former Member]

Hi,

Try to create a field on the layout with the Bill-To from the marketing document, then make it not visible. Now link all your address fields one by one to this hidden field. It means, they will only appear if you have any data in your Bill-To field.

[Former Member]

Hi ,

I tried it out but its getting Hang.when i went to see the preview.Rep asap.

mona

[Former Member]

Ok, try the following:

Create a new field with the following formula:

Field_111!=' '

where Field_111 is your Bill-To field which we need to check whether empty or not. If the field is not empty, this formula will give you value 1. So hide this field and link all your address fields to this new one.

In this case when your Bill-To address is blank, your address fields will not be visible, but when the address is filled, all your linked address fields will be seen.

[Former Member]

Hi dear,

It is showing me error as mising field & wrong formulae what should i do now?

mona

[Former Member]

Hi,

Could you please tell me what does Field_111!=' '

Actually Refers.....................I am still stuck up with that problem.Also How many Items could Fit in 1 page depents on what?..........Reply ASAP....

Mona

[Former Member]

Hi,

When I refer to a field number, because I don't know the field number you have in your system, I refer it as Field_xxx or something similar.

In this case you probably have the Bill-To field on your layout but I don't know the number of that field so you should change the Field_111 that I used for explaining the solution to the field number of your Bill-To.

Then create a new formula type field -which will have a different number again but I don't know that number- which will refer to your Bill-To field explained above. So if I suppose your Bill-To field is the Field_111 then this new field should have the content: Field_111!=' '. This field you will use only for linking other fields to it so make it unvisible.

Then you can link all your address fields to this formula field so that they will be displayed only in the case when your Bill-To address is not blank.

[Former Member]

Hi,

I tried out.It is working properly .But when i click on print preview it is getting stuck up & if only 1 item is there it is repearting 10 times......what should be done in such case?Its urgent pls do reply me ASAp.

mona.

[Former Member]

Have you created this layout from another form? It can happen when for example you create an Invoice from a Sales Order form and although it is an Invoice, there is a field left referring to the Sales Order table.

Go through the Field Index field-by-field and make sure there are no fields left from the other document type.

[Former Member]

Hi Dear,

I will Explain u in Detail what exactly i am doing

=>

The Situation is I want to reflect two Adress Fields I.e SHIP-TO ADRESSES & BILL-TO ADRESSES.In BP MASTER DATA my bill to Adress Field is Blank & In SHIP TO Adresses i have picked up some value.Which is reflecting properly,But when i am picking BILL-TO Adress in master data it is blank Then also by default it is picking up some value.I tried the way you said but pld is geting stuck up .What should be done in such case.2morow is 1st of APRIL & we have to take print out from SAP.Thats why its urgent.I had not used anyother form for these???????Pls help me if u could ASAP.........My print document is OUTGOING EXCISE INVOICE

mona