Skip to main content

Hello,

 

For scheduling the database task for General Ledger Update you need to fill in From_User and To_User. For those Parameters it is not possible to fill in % to just select all users but you really need to select the first and last user. 

 

The situation with this is that it needs to be regular checked if new users are created and if those parameters needs to be updated. Is there a way that we can just standard select all users without the necessity to regular validate if the selected users are still correct?

 

Regards,

Robin

Hi ​@robin.voorend  - I had a similar question / curiosity, so I’d spent some time digging through the GEN_LED_VOUCHER_UPDATE_API.Start_Update__ procedure, and see that it indeed performs insert statements with a BETWEEN clause for evaluating which User IDs (USERID) should be included in this process. This would require an amendment to some SELECT and INSERT statements, but would totally be feasible if IFS included this change in an SU or future release (currently on 24R1 SU9) to allow for these wild-cards.

Hopefully IFS sees this and considers it for a future update (if it isn’t handled already.)
Regards,

Randy
 

 

The only out of the box way I have come up with to address this is to setup two fake users. One user ID that will be the first, and one that will always be the last. Then, deactivated the account(s). Not ideal obviously.

Terms & ConditionsCookie settingsAccessibility statement