Search found 65 matches

by Dave
Fri Feb 29, 2008 3:29 pm
Forum: AccuZIP6 Future Releases
Topic: Ability to change order when printing presort reports
Replies: 2
Views: 14750

Print reports in custom order

This feature will be available soon in the 5.0 version. Also there will be the availability to print multiple copies from the print settings window for a single report.
Thank you for your suggestions.
by Dave
Fri Feb 29, 2008 12:02 pm
Forum: Import/Export
Topic: Export the tray and bundle fields without the leading zeros
Replies: 0
Views: 9038

Export the tray and bundle fields without the leading zeros

If you would like to export the Endorsement line without the leading zeros use the expression below in the export screen. Make sure there is a space between the quotes where indicated >>ID)),7," "))<<< ALLT(PADL(TRANSFORM(VAL(CONT_ID)),7," ")) +"*"+ALLT(PADL(TRANSFORM(VAL(GPB_ID)),3," "))+PADL(ALLT(...
by Dave
Thu Feb 28, 2008 3:57 pm
Forum: AccuZIP6 Commands
Topic: Get a prorated cost for any amount
Replies: 0
Views: 6927

Get a prorated cost for any amount

If you would like to prorate a cost for any amount you can use the following command to do so. This is useful if you are selling a service that is based on an annual cost and someone needs to purchase it for a portion of that. 1. Download and extract the prorate.zip file. 2.Extract the "FXP" and "DB...
by Dave
Wed Jan 30, 2008 4:25 pm
Forum: AccuZIP6 Commands
Topic: Create a new database for every Unique State in the database
Replies: 0
Views: 6737

Create a new database for every Unique State in the database

1. Download and extract the unique_st.zip file to the C:\Program Files\AccuZIP6 5.0 folder. 2.Create a command from the Edit>Command window. Type the following into the Command Statement Syntax area: DO UNIQUE_ST 3.The command will create a directory named “C:\ST files” and populate with separate db...
by Dave
Wed Jan 16, 2008 7:52 am
Forum: AccuZIP6 Commands
Topic: Convert Currency to Text From $.01 - $99,999.99
Replies: 0
Views: 6881

Convert Currency to Text From $.01 - $99,999.99

If you would like an equivalent text format of a dollar amount Download and extract the command to your AccuZIP6\Commands folder. This is an Excellent tool if you are printing invoices or checks! Make sure the amount is in a field named "Amount" and is a character type field Make sure the format is ...
by Dave
Mon Jan 14, 2008 3:46 pm
Forum: AccuZIP6 Commands
Topic: Move Tray & Pack mark to the last record in bundle
Replies: 0
Views: 6766

Move Tray & Pack mark to the last record in bundle

>>>>THIS COMMAND WORKS IN VER.5.0 ONLY<<<<< 1. Presort your database as normal. 2. Click on LABELS 3. Change the label format to DISK FILE 4. Change the format to AccuZIP6 5.x Database 5. Export the list. 6. Open the new list from the File>Open Database option in AccuZIP6 7. Run the command from the...
by Dave
Wed Jan 09, 2008 3:20 pm
Forum: Validation (CASS Certification)
Topic: AutoCASS
Replies: 1
Views: 10813

AutoCASS With 5.0

The 4.0 AutoCASS command will not work with the 5.0 version without additional help. The best thing to do is use the integrated script monitoring with 5.0. The script monitoring will be able to monitor folders throughout your hard drive or network for files to be processed. Click the link below for ...
by Dave
Mon Oct 29, 2007 10:03 am
Forum: AccuMUV NCOALink Unlimited Access and ANKLink
Topic: Create a quick CASS/NCOALink and ANKLink report
Replies: 0
Views: 9543

Create a quick CASS/NCOALink and ANKLink report

If you would like to print out a quick CASS/NCOALink and ANKLink report you can use this handy command. Download the cassncoareport.zip file to your hard drive . Place the command text in the AccuZIP6 5.0\Commands folder. You can run the command from the Edit>Commands option. AFTER you run the comma...
by Dave
Mon Oct 29, 2007 9:37 am
Forum: AccuZIP6 Commands
Topic: Quick CASS and NCOALink report
Replies: 0
Views: 6669

Quick CASS and NCOALink report

If you would like to print out a quick CASS/NCOALink and ANKLink report you can use this handy command. Download the cassncoareport.zip file, and unzip it into the C:\Program Files\AccuZIP6 5.0\Commands folder. After you download the command you can run it from the Edit>Commands option. Example of t...
by Dave
Tue Oct 02, 2007 7:11 am
Forum: AccuZIP6 Commands
Topic: Create an Excel file with count on 5 digit zips
Replies: 0
Views: 6690

Create an Excel file with count on 5 digit zips

Copy the following command into the command statement syntax area from the Edit>Command option, then click RUN. com_alias=alias() ON ERROR com_message=message() SET SAFETY OFF alter table alias() add column zip5 c(5) replace all zip5 with left(zip,5) SELECT zip5, city, st, count (zip5) as zipcnt ; ...
by Dave
Thu Aug 23, 2007 3:17 pm
Forum: AccuZIP6 Commands
Topic: Create your own simplified address list
Replies: 0
Views: 6766

Create your own simplified address list

1. Download the simplified.zip file to your hard drive 2. Extract the “dupwssrecs.FXP” to your AccuZIP6 4.0 Root Directory. 3. Place the Simplified Address Prep.txt file in the C:\Program Files\AccuZIP6 4.0\Commands folder. 4. I have created a template named “Simplified”, place that in a folder on y...
by Dave
Wed Jun 13, 2007 3:55 pm
Forum: AccuZIP6 Commands
Topic: Mark, Group and Count duplicates in your database
Replies: 0
Views: 7450

Mark, Group and Count duplicates in your database

Use this command to assign a group ID to the duplicates in your database as well as a count on how many are in each group and the priority record based on what you selected in the duplicate setup window. 1. Run your duplicate search as you normally would IMPORTANT: Make sure you have the “Backup Dup...
by Dave
Thu Apr 05, 2007 3:54 pm
Forum: AccuMUV NCOALink Unlimited Access and ANKLink
Topic: Disable the report generating after the NCOALink file Updade
Replies: 0
Views: 10332

Disable the report generating after the NCOALink file Updade

If you would like to disable the report generation after the NCOALink update then visit the AccuZIP6 Downloads page and download the item named AccuZIP6 4.0 Update . After downloading the update, exit the AccuZIP6 program, then double-click on the update to begin installation. In addition to downloa...
by Dave
Thu Apr 05, 2007 8:03 am
Forum: Printing
Topic: Assigning and different printer to a template.
Replies: 0
Views: 6130

Assigning and different printer to a template.

If you are trying to assign a different printer to your template in 5.0, you must first make sure the “Printer Environment” option is checked under the Report pull down menu. If you do not have this option checked the template will reset back to the default printer on your system. http://www.accuzip...
by Dave
Fri Feb 09, 2007 3:38 pm
Forum: AccuZIP6 Commands
Topic: Fill in City, ST information from ZIP alone.
Replies: 0
Views: 8798

Fill in City, ST information from ZIP alone.

If you have a need to populate the City and St fields when only the ZIP is available then use the following command. USE IN IIF(USED('_USZIPS'),SELECT('_USZIPS'),0) REPLACE ZIP WITH ALLT(SUBSTR(ADDRESS,RAT(" ",ALLT(ADDRESS)))),; ADDRESS WITH LEFT(ADDRESS,RAT(" ",ALLT(ADDRESS))); FOR EMPTY(ZIP) AND I...