Hello,
Is there any way to change this issue? Our quote number are all showing in comma separate, Can we make it just numeric value ?
What version are you working in? Is this on Quote Entry form, or a custom dashboard?
Numeric boxes have a Mask field that you can set like >>>>>>>>>9
(For this one, I wanted it to have at least one decimal place showing, hence the .9 at the end)
We are on 2023.2, for reference
3 Likes
yeah, formatting is kinda scattered around.
Extended Properties:
QuoteHed > QuoteNum:
So, by default, QuoteNum should NOT include commas.
But, if you’re using a custom dashboard… if could be formatted by other areas:
-
You can set formats within your DataViews
-
If your field value is coming in from a BAQ, the BAQ itself could have the QuoteNum field formatted with a comma, etc.
-
You can set formats on the compents (such as @jwphillips example above)
-
There is also a “Format” option on a numeric-box (which I’ve never played with to be honest), but it may impact the results as well…
1 Like
Our quote screen is customized one and our version is 2023.2.11
I don’t know if it is deprecated or subservient to some other setting, but in my experience, the Format section seems to do nothing…
2 Likes
Kinetic – Fiscal year and Fiscal period, showing with incorrect formats, includes commas and decimalsKB0134318
• Version 1.0 • 4mo ago Updated by Mauricio Elizondo • 48 Views
[ Print](javascript:void(0))
Issue
Kinetic – Fiscal year and Fiscal period, showing with incorrect formats, includes commas and decimals.
See examples:
Error
N/A
Resolution
- This issue was submitted to our Development team via the PRB0274469 - ERPS-239330
- It was reported in 2022.1.7, 2023.1.5, 2023.1.6, 2023.1.10, 2023.2.3, 2023.2.5, 2023.2.10, 2023.2.11
- It is scheduled to be corrected in 2024.1
So… workarounds until then
but our pilot version is 2024.1.5
1 Like
Was this resolved in a further release? We are on 2024.1.21 and are having similar issues with our sales order field that we’ve added to the TO Entry screen.
2 Likes
I’m having the same issue, does anyone know of a fix for this yet? We are on 2025.1
I doubt it will help as all the format option are terrible for just a vanilla number but the Source of the formatting is here from what I can tell.
2 different ways to display currency.
I feel like I am fighting with Excel again. They either need a Number Option or a Use Format Option. We are Piloting 2025.2.6 and I am going to replace these with text boxes for now.
2 Likes
Ok so I spent a little more time and found a Work Around that will make Numeric Boxes follow your Mask defined in the Base Parameters. It is fairly simple and has worked for me in a couple of places. In Formatting Click the Grouping Check box and save your layer. Then uncheck it and save again that is it.
If someone else can confirm that would be great. I tried multiple combos after I got it to work accidentally and Grouping seems to be the key.
1 Like