Hi,

I wouldn't recommend using database mass update to replace the execution of functions. Review the Legal notice in the for the Function in the Online help:

"This type of function is a development function whose use is probibitted in a standard use framework.

"Any legal consequences arising from the use of development tools on databases containing data which it is prohibitted by law to modify will be under the full responsibility of the customer. For further information, refer to the corresponding annex.

   "Indeed, the setup function of system transactions enables a mass update of the data of any table. The coherence rules linked with the  application are not controlled; it is a maintenance tool."

Database mass update doesn't take advantage of the business rules within Sage X3 and could leave you with corrupt data.

You could setup recurring tasks which allows you to schedule tasks. Closing periods and years is entails more than updates to a couple of fields. Running through Usage, Batch Server, Recurring task, will ensure that all the appropriate validations and data updates are completed.