Skip to main content
Answer

History Log IFS Cloud 24R2.4

  • November 20, 2025
  • 4 replies
  • 81 views
S
Hero (Customer)
Forum|alt.badge.img+11

All, 

We have set up the following history log on the INVENTORY_PART_IN_STOCK_TAB.

Availability control is the only attribute that I want to be logged at insert, update and delete. As insert is selected is this is why we are getting every transaction logged into the history as per below even though there is no value? I thought that the log only created when there is a value added to the field not when it is value is NULL, which it is when I check the DB.

Any insight here much appreciated as this is now creating far too many records.

Sarah

Best answer by Savinda.Tennakoon


Because you selected Insert in the History Log Configuration, every new row in INVENTORY_PART_IN_STOCK_TAB triggers a log entry for the Availability Control attribute ,even if it’s NULL.

4 replies

Savinda.Tennakoon
Hero (Employee)
Forum|alt.badge.img+8


Because you selected Insert in the History Log Configuration, every new row in INVENTORY_PART_IN_STOCK_TAB triggers a log entry for the Availability Control attribute ,even if it’s NULL.

S
Indika99
S
Hero (Customer)
Forum|alt.badge.img+11
  • sholmes
  • Author
  • Hero (Customer)
  • November 20, 2025

​@Savinda.Tennakoon - thanks for the information - but why has this changed from Apps9? Apps9 only recorded a log when that field had an entry that was not default, I will change the system to update and delete only hopefully this will reduce the volume in the history log.

Savinda.Tennakoon
Savinda.Tennakoon
Hero (Employee)
Forum|alt.badge.img+8

In Apps 9, the History Log was more selective and often skipped logging when:

The field was NULL or had a default value.
Insert logging was conditional.


In IFS Cloud, the History Log mechanism was redesigned for consistency and auditing compliance:

If Insert is enabled for an attribute, it logs every insert regardless of whether the value is NULL or default.
This ensures a complete audit trail for all transactions, which is a regulatory requirement in some industries.

S
Indika99
S
Hero (Customer)
Forum|alt.badge.img+11
  • sholmes
  • Author
  • Hero (Customer)
  • November 20, 2025

Hi ​@Savinda.Tennakoon  - so if I select only the update and delete will it also log everything for audit purposes or will it apply a filter to only that field being updated?

Savinda.Tennakoon
A
Terms & ConditionsCookie settingsAccessibility statement