Value of "currency_id" in custom table changes from NULL to an empty string when saving #10425
Labels
Priority:Important
Issues & PRs that are important; broken functions, errors - there are workarounds
Severity: Moderate
Key function failed, but no or little impact
Type: Bug
Bugs within the core SuiteCRM codebase
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: