Skip to main content
Question

What populates the Fixed Asset Acquisition Date ?

  • October 11, 2026
  • 2 replies
  • 23 views

Forum|alt.badge.img+1

In IFS cloud what data is the Acquisition Date in fixed assets populated with?  

2 replies

Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21
  • Ultimate Hero (Partner)
  • October 12, 2026

Hello ​@BGEJGOULD 

Following function identifies the acquisition date

IFSAPP.FA_OBJECT_TRANSACTION_API.Get_Valid_Max_Event_Date 

Here is the function details. Basically it is checking the max date from object transactions for the fixed asset.




FUNCTION Get_Valid_Max_Event_Date (
company_ IN VARCHAR2,
object_id_ IN VARCHAR2 ) RETURN DATE
IS
FUNCTION Core (
company_ IN VARCHAR2,
object_id_ IN VARCHAR2 ) RETURN DATE
IS
valid_max_event_date_ DATE;
CURSOR Get_Valid_Max_Event_Date IS
SELECT MAX(event_date)
FROM FA_OBJECT_TRANSACTION_TAB
WHERE company = company_
AND object_id = object_id_
AND rowstate != 'Rollback';
BEGIN
OPEN Get_Valid_Max_Event_Date ;
FETCH Get_Valid_Max_Event_Date INTO valid_max_event_date_ ;
CLOSE Get_Valid_Max_Event_Date ;
RETURN valid_max_event_date_ ;
END Core;

BEGIN
RETURN Core(company_, object_id_);
END Get_Valid_Max_Event_Date;

Hope this helps


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • October 12, 2026

That feels like that could be the answer for the event date on the acquisition section of object balance analysis, whereas I am looking n teh main Fixed Asset Object page (field circled above).  For instance this object has transactions on it dated 12/10/26 but the acquisition date is displayed as 14/9/26.

 

Thanks for looking though, do you have the same tool for this field? ​@Furkan Zengin