Did you run it with the STANDARD Report Setting? STANDARD Report Settings don't save. Try creating another name in order to save the Report Settings. Edit: And make sure you select Selection Criteria - "By Date".

Do you mean using the standard GL Detail report? I already have the GL range in a saved detail report. But using that saved template with all the settings I need does not run for one date when I run the task scheduler thank you

Yes, the standard GL Detail report. It works for me in 2021 with the Task Scheduler. Be sure to set the "By Date" option.

Yes, the standard GL Detail report. It works for me in 2021 with the Task Scheduler. Be sure to set the "By Date" option.

I have the by date option already - I want the report to run for the previous day's date every day at a certain time. I test run it and I get a date for 2018 for one report and 2015 for another - is there another setting I am missing? thank you

I'm not sure what either of us is missing, but the attached image shows my settings for both the Task Scheduler and the Report Setting I'm using to get the prior day. If you need to automate the date to always the prior day then you would need to use a 3rd party tool like Kevin says or you could script it using BOI.

the settings you had worked - I was missing the default report setting checked.

what is BOI? and how would the script work?

BOI stands for Business Object Interface. This link gives you an idea what that is. The "report date" they talk about in the title isn't a parameter like we are using with your issue. The "By Date", "Starting Date" and "Ending Date" would be changed in the way that the posting deals with a "field" and "field value".

thank you - I am not sure that my company has BOI already. do you know what module it is under in Sage100?

The BOI and UDS (User Defined Scripting aka "event scripting" and "button scripts") are built into all versions since 4.40. Several features have been added since the initial support (such as in version 2015). Recent discussions here give more information about relevant classes.

ok thank you - where would I find it in Sage100? I tried looking around in the modules but did not see it

BOI is not "in" Sage 100 it is an external programming interface. See the link above for classes. One accesses UDS event scripting, button scripting and UI scripting via Custom Office. Search the Sage 100 Help Topic with the keyword "scripting" or click here.

Sage 100 object framework API is presented as a COM/OLE interface with WSH for internal BOI scripting or using PVXCOM which is a COM/OLE wrapped version of ProvideX for framework and language access.