Support 805.461.7300
Sales
Our Technology. Your Success.
Live Chat
Tech Notes

Create Facing Slips For Simplified Address Lists on Pallets

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

  1. Download the facing-slips-pallets.zip file
  2. Copy the “Facing Slip.txt” file to the C:\Program Files\AccuZIP6 5.0 (x86)\Commands folder.
  3. Copy the other 2 Report files to the C:\Program Files\AccuZIP6 5.0 (x86)\Reports folder.
  4. Presort the list as normal.
  5. In the Print Presort screen, Click the Print Labels icon
  6. In the Print Settings screen, click on the Output pull down menu and choose Disk File, then click "Continue".
  7. 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.
  8. Close the Export Setup window, the Print Settings window, and Print Presort. Close your database as well.
  9. Pull down the File menu and choose Open Database. Open the disk file.dbf.
  10. 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 wanted to take a minute to write accolades for your employee Eric Lambeth. I have been calling on Eric for training and help in the Accuzip software since May and I want you to know that from a client standpoint, he is second to none! Eric has gone way above and beyond in helping me learn and navigate your software as well as helping us through some crazy situations we have encountered. It is clearly evident that he knows this software inside and out. It is also evident that Eric loves the customer and is willing to do whatever it takes to help – he has even answered emails and called me on the weekend to help through some stuff I was unsure of! I cannot express enough how wonderful Eric has been for our organization. I will tell you that I came to this organization with a background in BCC software with plans to transition to BCC software. Eric’s knowledge, guidance, training, and willingness to help at all hours of the day/week has sold me on Accuzip! Your software solution is more user friendly and the support staff far exceeds BCC! I am also looking forward to investigating your other software solutions.
S.M., Elmhurst, IL