Epicor 9: Rounding of Caluculated fields in BAQ Designer
Epicor 9: Rounding of Caluculated fields in BAQ Designer
(OP)
Hi,
Has anyone extensively used the BAQ designer in Epicor 9.0?
I'm pulling through the Orderdtl.DocUnitPrice among other values into the BAQ., it automatically displays using 5 decimal places, even though i've customised the field on Sales Order Entry to only display to 2.
I can't sem to customise the BAQ or the dashboard to keep the figure at 2 decimal places so have created calculated fields to create my own decimal variation, using the following simple code:
Decimal (orderdtl.DocUnitPrice)
However, the field rounds down in every instance. For example my unit price could be 10.99999 but the calculated field only shows, 10.00
Any hints or tips would be appreciated.
Has anyone extensively used the BAQ designer in Epicor 9.0?
I'm pulling through the Orderdtl.DocUnitPrice among other values into the BAQ., it automatically displays using 5 decimal places, even though i've customised the field on Sales Order Entry to only display to 2.
I can't sem to customise the BAQ or the dashboard to keep the figure at 2 decimal places so have created calculated fields to create my own decimal variation, using the following simple code:
Decimal (orderdtl.DocUnitPrice)
However, the field rounds down in every instance. For example my unit price could be 10.99999 but the calculated field only shows, 10.00
Any hints or tips would be appreciated.
Talk To Other Members