Create Facing Slips for Simplified Address Lists

If you need Facing slips for your Simplified Address List follow the steps below.

Download the facing.zip file
Copy the “Facing Slip.txt” file to the C:\Program Files\AccuZIP6 5.0 (x86)\Commands folder.
Copy the other 2 Report files to the C:\Program Files\AccuZIP6 5.0 (x86)\Reports folder.
Presort the list as normal.
In the Print Presort screen, Click the Print Labels icon
In the Print Settings screen, click on the Output pull down menu and choose Disk File, then click "Continue".
In the Export Setup window, check the Export All Fields box beneath the field list. Click on Export Format and choose AccuZIP6 5.x Database. Click Export. Leave the file name as disk file.dbf and choose where you want to save the file, then click Save.
Close the Export Setup window, the Print Settings window, and Print Presort. Close your database as well.
Pull down the File menu and choose Open Database. Open the disk file.dbf.
Pull down the Edit menu and choose Command. From the Command Statement pull down menu, choose the Facing Slips command. Click Run, then close the Command window.

NOTE: If you're presorting a Packages on Pallets mailing, run this command instead:

ON ERROR COM_MESSAGE=MESSAGE()
SET SAFETY OFF
COM_ALIAS=ALIAS()
SELECT(COM_ALIAS)
ALTER TABLE ALIAS() ADD COLUMN PIECE C(8)
SELECT PALLET_ID,MAX(GPB_ID) AS PIECE ;
FROM (COM_ALIAS) GROUP BY 1 INTO TABLE C:\PIECE.DBF
USE
USE ("C:\PIECE.DBF") IN 0 ALIAS "PIECE"
SELECT ("PIECE")
INDEX ON ALLT(PALLET_ID) TAG MYTAG
SELECT(COM_ALIAS)
INDEX ON ALLT(PALLET_ID) TAG MYTAG
REPLACE PIECE WITH PIECE.PIECE FOR SEEK(ALLT(PALLET_ID) ,"PIECE")
REPLACE ALL PIECE WITH TRANSFORM(VAL(PIECE))
USE IN IIF(USED("PIECE"),SELECT("PIECE"),0)

**REMAINING
COM_ALIAS=ALIAS()
SELECT(COM_ALIAS)
ALTER TABLE ALIAS() ADD COLUMN PIECE C(8)
SELECT CONT_ID,MAX(GPB_ID) AS PIECE ;
FROM (COM_ALIAS) GROUP BY 1 INTO TABLE C:\PIECE.DBF
USE
USE ("C:\PIECE.DBF") IN 0 ALIAS "PIECE"
SELECT ("PIECE")
INDEX ON ALLT(CONT_ID) TAG MYTAG
SELECT(COM_ALIAS)
INDEX ON ALLT(CONT_ID) TAG MYTAG
REPLACE PIECE WITH PIECE.PIECE FOR EMPTY(PALLET_ID) AND SEEK(ALLT(CONT_ID) ,"PIECE")
REPLACE ALL PIECE WITH TRANSFORM(VAL(PIECE))
USE IN IIF(USED("PIECE"),SELECT("PIECE"),0)

Now you can print the Facing Slip report from the File>Print Report option. The report is named "Facing Slips.frx"

« Back to Tech Notes

New to the
Mailing
Industry?
More Info

Professional Services
More Info

"I recently ended probably the most helpful chat ever with your employee Aurora Crouch! She was so extremely thorough and made sure that the install and setup of Accuzip was ready to go. She was also so patient and polite as I fumbled around trying to remember how a PC works! I honestly can't say enough about how amazing and helpful and kind she was! I appreciate her help so very much, she is a great employee and makes it so easy for people like me (who have no idea what they are doing) to get things set up as they need to be. Thank you so much for all of your help and for having someone like Aurora on staff, she is literally a godsend!"

C.C., Savannah, GA