You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If a module is configured with a custom currency field, an additional column called "currency_id" is also created.
When a new record is created this value is NULL.
When the record is updated this value is then changed to be an empty string.
If the currency field is used within a report with an aggregated function combined with grouping of another column, then the report shows duplicated records due to the differing values of NULL and an empty string.
Expected Behavior
The stored value of the "currency_id" should be consistent
Actual Behavior
For new records "currency_id" is NULL, once opened and resaved this value is then an empty string.
Steps to Reproduce
Add a currency field to a module
Create a new record and save it
Observe the value "currency_id" column in the custom field table is NULL
Create a second record
Open the second record and save it
Observe the value "currency_id" column in the custom field table is now an empty string
Context
Medium priority
Your Environment
SuiteCRM Version used: 7.14.3
Environment name and version (e.g. MySQL, PHP 7): PHP 8.1, MariaDB 10.11.6
Operating System and version (e.g Ubuntu 16.04): Debian 12
The text was updated successfully, but these errors were encountered:
Issue
If a module is configured with a custom currency field, an additional column called "currency_id" is also created.
When a new record is created this value is NULL.
When the record is updated this value is then changed to be an empty string.
If the currency field is used within a report with an aggregated function combined with grouping of another column, then the report shows duplicated records due to the differing values of NULL and an empty string.
Expected Behavior
The stored value of the "currency_id" should be consistent
Actual Behavior
For new records "currency_id" is NULL, once opened and resaved this value is then an empty string.
Steps to Reproduce
Context
Medium priority
Your Environment
The text was updated successfully, but these errors were encountered: