Get the money amount into a barcode and get it scanned correctly

Hi,

I inserted a new barcode (code 39) with the fields of property roll number and pay amount. The roll number is scanned correctly on the generated PDF file. However, the pay amount is always scanned as a zero although it is correctly displayed with preview (by checking the human readable message box).

Is this a data type issue or something else?

Appreciated very much for any suggestions or helps.

John

I just tested it and it scans fine on my end.

I created a field named Roll (type Integer) and a field named Pay (type Currency) and I added them both as the content to the Code39 barcode. You may want to check whether your barcode scanner is set to allow Currency/Decimal characters as that may be an option you have to enable on the scanner itself. I only tested using my phone’s Barcode Scanner as I don’t have an actual scanner with me but phone scanners are notoriously more finicky than hardware scanners, so I have to believe it’s something to do with its configuration.

Thanks Phil. I did have formatted the amount as currency and the readable tax showing something like $23.22. The scanner doesn’t like it. Although I can suggest a setting change of the scanner just for testing purpose, but the scanner from our city hall payment section won’t allow us to do it as other payment bills currently do not use this format.

So I have tried to concatenate the string type of roll number (42135676) with a string type of padding zeros plus a float type of amount, such as 2322 (23.22 * 100 to get rid of the period and the dollar sign) and feed them into the barcode. The final result value is like 42135676000002322. Then the roll number got scanned correctly, but the amount of 23.22 is not. All I got is zero for the amount.

John