Sage 100

Quick question. Sage 100 (any version), custom office numeric UDF mask. Any way to set up a percentage field that will show a percent sign such as 5.100% as in the commission rate field? Adding the ""%"" produces ""invalid mask"".

Check the ""Help"" on the Mask field on the UDF setup screen.

Upon looking in Help, it doesn't appear the % sign is an option, unless there's maybe a way to do it as a String Mask (vs. Numeric). Otherwise could you just instead create a text label for the percentage sign and place it right up against / next to your UDF?

That's a bummer. p779 (http://docs.pvxplus.com/PVXV7.pdf) seems to suggest that the % sign should show up (as an Other), though % is a special identifier in ProvideX. Can you try a double % (%%)?

Double or single: You entered an invalid mask: ###.000%% A numeric mask can only contain number signs, zeros, commas, and a single decimal point.

Also, I can get a string mask to look right, but entering the number on screen is way too funky. You cannot enter a decimal point and it starts at the rightmost character. So if you entered just a ""4"" or ""4."", it would show up as 0.004% in the string field.