How do I format the decimal places displayed on a column in a grid

A user is asking us to show more decimal places on the Purchase Advisor->Supplier Price Lists tab for the Base Unit Price column.

If I look at the Dataview the field has five digits in the format

If I look at the data that is returned it has more than two decimal places, so I know the data coming over is good.

Where can I set the display format on the individual columns?

We are using 2023.1.30.

You should be able to do this by defining an Erp Editor Model for that column (although, I would think this would be automatic, since it’s defined in the data view… :man_shrugging:)

In the grid properties, under Data > Grid Model > Columns, select the BaseUnitPrice column, then Erp Editor to Number and enter the Erp Editor Model menu
image

Then under Advanced, you can enter the same mask as is in the data view for that column:

3 Likes

That’s exactly what I needed to know. Thank you for your prompt help.

1 Like