Exporting Endorsement for 1st piece in a Package

Exporting expressions and information including exporting data in presort order or import order, and importing information, along with error messages that may apply to this category.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
Kristen
Moderator
Posts: 726
Joined: Wed Sep 20, 2006 3:46 pm

Exporting Endorsement for 1st piece in a Package

Post by Kristen » Wed Jul 23, 2008 3:04 pm

Below is the expression to export a database in presorted order and only have the endorsement line export for the first record in each package.

You’ll want to put this in the Export setup screen’s expression area next to the field Endorse:

IIF(!EMPTY(traymark_),ALLT(PADL(TRANSFORM(VAL(cont_id)),3," "))+"*"+ALLT(PADL(TRANSFORM(VAL(gpb_id)),3," "))+PADL(ALLT(Endorse),30,"*"),SPACE(40))

Post Reply