Query

Oct 06, 2006 2 Replies

Rate this thread:

G E 19 years ago

I need to take the individuals name off of all my customers shipping addresses. Can anyone help me write a query?

Thanks

Vote

G E 19 years ago

Never Mind.

I really want to eliminate the individuals name that show up on invoices (on the bill to or ship to) and I want just the customers business name to show. Is this possible?

Thanks

Vote

Jeff 19 years ago

GE,

You will have to modify the Receipt Template.

Make a copy of the one you are using now and work with the copy. Give is a different filename too.

To edit the file, use Notepad

1) To delete the Customer's name from the Bill to, find the section below;

Customer.Name Customer.HomeAddress.Company Customer.HomeAddress.StreetAddress Customer.HomeAddress.StreetAddress2 Customer.HomeAddress.CityStateZip

and delete the first line under the line

2) To delete the Customer's name from the Ship to, find the section below;

Customer.ShipToAddress.Name Customer.ShipToAddress.Company Customer.ShipToAddress.StreetAddress Customer.ShipToAddress.StreetAddress2 Customer.ShipToAddress.CityStateZip

and again, delete the first line under the line.

3) While you're at it, in the section below, change the description line something descriptive like Receipt - 40 column without Customer Name, for example, so you'll be able to identify it later.

Receipt - 40 column Microsoft Corporation Version 1.06

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required