Query


G

G E

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

Thanks
 
Ad

Advertisements

G

G E

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
 
Ad

Advertisements

J

Jeff

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;

<COLUMNDATA>
<TEXT skipblank="true" newline="true"> Customer.Name </TEXT>
<TEXT skipblank="true" newline="true"> Customer.HomeAddress.Company </TEXT>
<TEXT skipblank="true" newline="true"> Customer.HomeAddress.StreetAddress </TEXT>
<TEXT skipblank="true" newline="true"> Customer.HomeAddress.StreetAddress2 </TEXT>
<TEXT skipblank="true" newline="true"> Customer.HomeAddress.CityStateZip </TEXT>
</COLUMNDATA>


and delete the first line under the <COLUMNDATA> line


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

<COLUMNDATA>
<TEXT skipblank="true" newline="true"> Customer.ShipToAddress.Name </TEXT>
<TEXT skipblank="true" newline="true"> Customer.ShipToAddress.Company </TEXT>
<TEXT skipblank="true" newline="true"> Customer.ShipToAddress.StreetAddress </TEXT>
<TEXT skipblank="true" newline="true"> Customer.ShipToAddress.StreetAddress2 </TEXT>
<TEXT skipblank="true" newline="true"> Customer.ShipToAddress.CityStateZip </TEXT>
</COLUMNDATA>


and again, delete the first line under the <COLUMNDATA> 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.

<PROPERTIES>
<DESCRIPTION> Receipt - 40 column </DESCRIPTION>
<AUTHOR> Microsoft Corporation </AUTHOR>
<VERSION> Version 1.06 </VERSION>
</PROPERTIES


Save it and then go back into SO Manager | Database | Register List | Receipt Template | select the template | click on the magnifying glass at the end of the Sales line and select the new receipt you just created.

Only new sales will use this modified template.



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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query 3
Query 1
CGT Query 4
Mortgage query??????? 2
query on 1099 3
Budget queries 20
Ireland Stocktaking query 0
SS query 6

Top