320
I'm trying to create a barcode on our packing list that contains the item number, serial number and the quantity for this serial number. However, when I try to 'CAT' these fields together, I receive an error on the qty.
So, I'm trying to convert the qty to a string so I can concatenate them into a calculated field.
Any advice on converting qty field to string?
*This post is locked for comments
Why not try using RW_Format() which I got added to version 7.0 onwards.
function returns string OUT_string;
in vcurrency IN_currency; { value to format }
in integer IN_cur_symbol; { non zero = display currency symbol }
in integer IN_thou_sep; { non zero = display thousands separator }
in integer IN_dec_places; { number of decimal places }
in integer IN_neg_type; { how to display negative values }
{ Values for IN_neg_type:
1 = SYSTEMNEG
2 = MINUSNEG
3 = PARENNEG
4 = CRNEG
+ 100 for %
}
David
I can get the item number and serial number to print (3of9) without an issue, it is only when I add the quantity that I get the error.
Our client has requested 3 of 9.
So I guess the question is, within Report Writer can you convert a numeric field to a string?
My guess is the real problem is getting the count per serial number per item. I'm not familiar enough with serial/lot tracked inventory to do more than guess.
What barcode symbology are you using? I'm just curious because I wouldn't try encoding this much data using Code39.
Kirk
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (