I’m struggling to add a new currency field to my SOLine DAC.
Errors
When setting the value on any of the SOLines, if the value is >=100, then I get this error.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/85aebe0a-3acf-43a6-b959-96bb1dd63faa.png)
Customization
Here’s how I added the custom fields: I created two fields, a UsrSalesRepUnitCost and a UsrCurySalesRepUnitCost, with the following attributes in each.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/78d7370c-5d4f-473f-a273-c60ff1b8359a.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/443b0d25-3e60-419e-bcc4-bb2ab60319cd.png)
The “Database Scripts” section in the customization project window indicates the both of the custom fields are using the `DECIMAL(8, 4)` datatype, which I would assume would allow values as high as 9999.9999.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/7ab60804-835a-4325-8191-e2161eca2c60.png)
Questions
- Why am I getting an error indicating that the value 150.0000 is too large?
- Have I properly configured the two custom fields to accurately work for representing currency? I couldn’t find any resources in the documentation about creating custom currency fields.
Best answer by Dioris Aguilar
View original