Only Exporting the Endorsement Line at Package Breaks

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
User avatar
Terry
Site Admin
Posts: 1982
Joined: Wed Sep 20, 2006 3:45 pm

Only Exporting the Endorsement Line at Package Breaks

Post by Terry » Thu Jan 08, 2009 2:00 pm

If you want to export the endorsement information (including tray and package number), but only want it to be populated with each package break, copy and paste the following expression into the "expression" column. You'll need to make sure that the length of that exported field is 40.

PADR(IIF(!empty(pkgmark_),TRANSFORM(VAL(cont_id))+"*"+TRANSFORM(VAL(gpb_id))+PADL(ALLT(endorse),32,"*"),""),40)

Post Reply