Skip to main content
Question

How to update the Thru_Date when importing a Fixed Assets Object from an external file?

  • October 17, 2024
  • 1 reply
  • 71 views

Forum|alt.badge.img

Hi All,

My requirement is to update the total accumulated depreciation up to the cutoff date during the import process and set the cutoff date as the Thru_Date. Then, when running depreciation using the Depreciation Proposal, depreciation should be calculated correctly only for the period after the cutoff date.

1 reply

FlorianTauber
Do Gooder (Partner)
Forum|alt.badge.img+4
  • Do Gooder (Partner)
  • 13 replies
  • January 13, 2025

Hi Asanka Dinesh,

I cannot answer your question directly, but I can tell you about our approach, from a migration perspective:

For the migration of fixed assets incl. needed transactions, we don’t use the default wizard in IFS. Instead, we’re creating the FA Objects with the migration tool (currently FNDMIG) and afterwards adding the transactions via script (FA_OBJECT_TRANSACTION_API.NEW__).

This enables us to fill the date information individually (like TRANSACTION_DATE, EVENT_DATE, RETROACTIVE_DATE) → we can set the thru date.

Specifically we create at least 3 transactions per object:

  1. (Acccumulated) Acquisition
  2. (Accumulated) Depreciation value previous FY
  3. (Accumulated) Deprecisation value current FY

Keep in mind, that there might be more than one ledger / book.

 

BR

Florian

FLEXiCODE


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings