Total Cost on Software Entitlement (alm_license) Recalculated Only After Opening Record
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
an hour ago
We implemented a Before Insert Business Rule on the alm_license table because the entitlements are imported with Unit Cost in USD, while our ServiceNow instance currency is EUR. The Business Rule converts the Unit Cost from USD to EUR during import.
The currency conversion is working correctly. After import, the Unit Cost field shows the converted EUR value as expected.
However, I am observing an issue with the Total Cost field:
- I import an entitlement with Unit Cost in USD.
- The Business Rule converts the Unit Cost to EUR successfully.
- In the alm_license list view, the Total Cost initially appears to be calculated using the original USD value (based on my manual calculations).
- When I open the entitlement record, the Total Cost is automatically recalculated and updated using the converted EUR value.
- After returning to the alm_license list view and refreshing, the Total Cost also shows the correct EUR-based value.
It appears that some OOB process or client-side calculation is recalculating and updating the Total Cost only when the record is opened.
Questions:
- Is Total Cost expected to be recalculated only when the entitlement record is opened?
- Is there any OOB Business Rule, Script Include, or post-import process that recalculates Total Cost after import?
- Has anyone observed a delay between Unit Cost updates and Total Cost recalculation on Software Entitlements (alm_license)?
- What is the recommended approach to ensure the correct Total Cost is displayed immediately after import without opening the record?
Any guidance would be appreciated.
Thanks!
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
19m ago
Hi @Tejaswini Morey,
the Unit Cost is being updated during import, but the Total Cost is not reflecting that value immediately.
check
- Verify how the Total Cost field is maintained in your instance (Dictionary, Business Rules, Script Includes, or calculated field definition).
- Use Debug Business Rule during the import to identify any OOTB or custom logic that updates Total Cost.
- Review your Transform Map and ensure the currency conversion occurs before the record is inserted.
- Compare the field values immediately after import with the values after opening the record to determine whether another server-side process is updating the record.
- If required, consider performing the currency conversion in an onBefore Transform Script so that the converted Unit Cost is available before the entitlement record is created.