|
|
Groups: Member
Posts: 6
|
Hi:
I posted a question on your support web page and I can't seem to find the response - sorry...
I am using Mailers+4 and recently added the eLot option.
eLot appears to give me a substantial savings on flats with Enhanced CRRT rates but I am confused about the sequence of the labels.
When I run labels or sort by the Sequence Number provided by Mailers+4 the records are grouped by CRRT but there doesn't seem to be any correlation to or order by LOT Number or LOT Order.
The post response essentially said a sequence is not required once the packages are separated by CRRT.
That's great if true but I want to confirm before I take mail down there and get whacked...
Can you confirm what the print sequence is within CRRT, if any? Am I safe in sorting by the sequence number provided by Mailers+4 and just batching by CRRT?
I've asked the Mailpiece Design Analyst for my area what his ruling is and if/when I get a response I'll add it to this post.
Thanks so much.
Don.
|
|
Groups: Administration
Posts: 58
|
Hi Don, here is a blurp from the USPS Domestic Mail Manual on ELOT for flats.
345.6.9.6
"6.9.6 Updating Line-of-Travel Sequence Information
Unless the mail is prepared in carrier walk sequence, line-of-travel (LOT) sequence is required for mailings at Standard Mail Enhanced Carrier Route basic prices. LOT sequence is not an exact walk sequence but a sequence of ZIP+4 codes arranged in the order that the route is served by a carrier. (First the ZIP+4 groups are sequenced, then the addresses within each are identified as being in ascending or descending order.) The USPS eLOT product provides a list of the ZIP+4 codes each carrier route serves, identifies the order in which they are delivered, and provides an indicator specifying whether the addresses that share the same ZIP+4 code must be sorted in ascending or descending order. When a range of ZIP+4 codes on the same carrier route are assigned the same sequence number, the addresses bearing those ZIP+4 codes must be arranged in ascending ZIP+4 code order before the sequence number is assigned. LOT information must be updated within 90 days before the date of mailing."
So you can sort the sequence number but only by the last 4 digits of this number. The sequence number consists of 14 characters..
First 2 characters = Job Number
Next 4 characters = Container Number
Next 4 characters = Package Number
Last 4 characters = Sequence Number
After presorting in Mailers+4 it may be easier to export the results in presorted order if your using a .txt or .dbf file.
|
|
Groups: Member
Posts: 6
|
Thank you for your kind response Paul.
Yes, I export my file back to MS Access after presorting in Mailers+4 so I can sort on pretty much anything.
Pasted below are 20 records from a run I did with eLot.
When looking at the last 4 characters of the Sequence Number they are in order. This is the order the labels would be in if I printed from Mailers+4.
But when looking at the corresponding LOT Number, there doesn't seem to be any correlation - they jump all over.
Should I override the Mailers+4 Sequence Number and sort by something else such as LOT Number?
Thank you again.
zip-dpb CRRT Container Package Seq_Num LOT Order LOT Number
137602701076 C008 000001 000001 0000010010001 D 0078
137602708321 C008 000001 000001 0000010010002 A 0082
137604102105 C008 000001 000001 0000010010003 A 0053
137602759703 C008 000001 000001 0000010010004 A 0133
137602701175 C008 000001 000001 0000010010005 D 0076
137602753222 C008 000001 000001 0000010010006 A 0117
137602763195 C008 000001 000001 0000010010007 D 0128
137602727050 C008 000001 000001 0000010010008 D 0120
137602735015 C008 000001 000001 0000010010009 A 0113
137602703119 C008 000001 000001 0000010010010 D 0072
137602759721 C008 000001 000001 0000010010011 A 0133
137602779134 C008 000001 000001 0000010010012 D 0131
137602712146 C008 000001 000001 0000010010013 A 0092
137602805233 C008 000001 000001 0000010010014 D 0063
137602711192 C008 000001 000001 0000010010015 D 0090
137602723298 C008 000001 000001 0000010010016 D 0163
137604175394 C008 000001 000001 0000010010017 A 0049
137602753286 C008 000001 000001 0000010010018 A 0117
137602723018 C008 000001 000001 0000010010019 D 0171
137602805071 C008 000001 000001 0000010010020 D 0063
|
|
Groups: Administration
Posts: 58
|
Hi Don,
The lot numbers should not be this way. I have a quick question. Within Mailers+4 if you go to "Format Fields" and click the "Presort" tab...can you check to see if you have "Walk Sequence" formatted? If you do uncheck this button and rerun the presort. Let me know if the Lot numbers are in order.
Paul
|
|
Groups: Member
Posts: 6
|
Thank you Paul:
It looks like that did it.
I did in fact have the WALK SEQUENCE block checked in FORMAT and I unchecked and reran.
Below are the first 20 records from the same job again and now there is a LOT Number correlation to Sequence Number.
I see the ENDORSEMENT now includes the LOT Number in addition to the CRRT which it had not before.
It appears this has solved my problem - do you agree?
I think now I can print from MS Access sorting by Sequence Number - thank you so much.
CRRT Container Package Seq_Num Endorsemen LOT Order LOT Number DPBC
C008 000001 000001 0000010010001 ECRLOT 0002D**C008 D 0002 07
C008 000001 000001 0000010010002 ECRLOT 0002D**C008 D 0002 01
C008 000001 000001 0000010010003 ECRLOT 0002D**C008 D 0002 01
C008 000001 000001 0000010010004 ECRLOT 0003D**C008 D 0003 09
C008 000001 000001 0000010010005 ECRLOT 0003D**C008 D 0003 07
C008 000001 000001 0000010010006 ECRLOT 0006D**C008 D 0006 05
C008 000001 000001 0000010010007 ECRLOT 0007A**C008 A 0007 04
C008 000001 000001 0000010010008 ECRLOT 0007A**C008 A 0007 06
C008 000001 000001 0000010010009 ECRLOT 0007A**C008 A 0007 08
C008 000001 000001 0000010010010 ECRLOT 0007A**C008 A 0007 10
C008 000001 000001 0000010010011 ECRLOT 0008A**C008 A 0008 11
C008 000001 000001 0000010010012 ECRLOT 0009A**C008 A 0009 11
C008 000001 000001 0000010010013 ECRLOT 0010D**C008 D 0010 16
C008 000001 000001 0000010010014 ECRLOT 0010D**C008 D 0010 06
C008 000001 000001 0000010010015 ECRLOT 0010D**C008 D 0010 04
C008 000001 000001 0000010010016 ECRLOT 0010D**C008 D 0010 04
C008 000001 000001 0000010010017 ECRLOT 0011A**C008 A 0011 17
C008 000001 000001 0000010010018 ECRLOT 0012D**C008 D 0012 12
C008 000001 000001 0000010010019 ECRLOT 0013A**C008 A 0013 20
C008 000001 000001 0000010010020 ECRLOT 0013A**C008 A 0013 22
|
|
Groups: Administration
Posts: 58
|
Hi Don,
Yes it looks like you are good to go.
Best Regards
Paul
|
|
|
Guest |
