I would use a temp field to read the package number field and then make the package number field a calculation of temp+1.  This is assuming the first package is 0 and the second is 1 and so on.  Note the temp field would be the very first field in the right hand box

Are the last four digits of the tracking # always numeric?  If so, perhaps try using that as your package # (instead of trying to handle a sequence).

Hi BigLouie,

That is a cool idea, and seems straightforward. When creating the Temp001 with the Number Data Type I receive Error #26: Variable type invalid. Do you know why I'm getting this error? 

Hi Kevin,

Yes, the last 4 of the tracking # seem to be numeric, but the package # is already assigned in Sage in Shipping Data Entry. The Shipment in Sage needs the tracking information per package. The package number in Sage and UPS Worldship export do not match, as Worldship starts with 0 rather than 1. 

I may not be understanding your idea fully, how would the last four digits of tracking # equate to the package #?

I've used the method I suggested without being concerned about matching up with already created package #'s, because I only wanted the tracking # values in that table for viewing, printing on invoices, embedding in custom email messages... and just needed a unique numeric package # for that to work.  Mismatched package #'s didn't matter (in those scenarios).

If you need the tracking numbers to match existing packages, don't do what I suggested.

PackageNo is a string.  You have to convert your number to a text value, in the calculation.

Another thing you can try is change the Operation to Incr Assign with a default value of 0001.  It should always start with 0001 and if there is a second line it will assign 0002 and so on.  Or in your calculation NUM(Temp)+1

Hi Kevin,

Thank you for clarifying, it's really good to know that use-case. Our business needs require us to match package # to tracking # for our trading partners.

Thank you both. I'll try the Incr Assign with a default of 0001. 

Incr Assign does not work with our process as the packages are already created and that function created new packages with the tracking #s rather than assigning them to the already created packages. I'll test the calculation method. 

Edit: I needed to add 2 Temp fields. 1st temp field is String data type that reads the column data, and the 2nd is Number data type that converts the string into a number then adds 1. The PackageNo is a calculated field that converts the 2nd Temp field into a string. I'm going to test this and will update.