My new GI has a calculated numeric value which the view displays as a decimal (19,4). I would like the value to display as a currency with 2 decimal places and comma separators.
Probably because I am new also, I can’t figure out how to alter the presentation in the view.
Thank you!
Tom Morris
Best answer by Laura02
Hello Tom.
Please try these formatting ideas.
Populate the Schema Field with a field that looks like your desired format ( currency with 2 decimal places and comma separators).
Click into the Data Field using the pencil icon, and then use conversion options to change your field.
Thanks for your compliment! - you flatter me. I have average intelligence and education…. but higher than average years of experience. 😉
I found the definition for Schema Field in the Help:
Form Reference section of Help is where you can find the Field-by-field definitions. From the Help icon in Generic Inquiries screen, scroll to the bottom of the help menu that appears, and select Form Reference for Generic Inquiry.
Next, select the section of the screen where the field you have a question about is located:
There is a Form Reference section containing field definitions in Every Screen of Acumatica.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.