Sage 100

Is there a way to automate the update of Daily Transaction Registers without use the Sage 100 Advanced Task Scheduler? I tried the Sage 100 Advanced Task Scheduler and it appears to be locking up the GL and then no one can update the DTR's. Thanks for your input!!

I don't think I've actually scripted DTRs, but I have scripted General Journal Entry updates to Deferred. I never had much luck printing reliably to anything else.

For how long does it lock up the G/L? I suppose another option could be to use something like [MacroExpress](https://www.macros.com/).

It doesn't seem to release it until you reboot the server or kill the pvxwin.exe task.

That doesn't sound right. Anything in the KB?

Here's another: Task Scheduler tasks hang or no longer finish Products Sage 100 Description Task Scheduler tasks hang or no longer finish Disclaimer Backup Warning Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage Business Partner, network administrator, or Sage Customer Support Analyst. Cause The SY_ActivityLog.m4t may be corrupted Resolution Browse to the ...\MAS90\MAS_System\ directory and rename the SY_ActivityLog.m4t file. Restart Sage 100 to recreate the file. Rerun scheduled task Category Corruption Data and database Entitlement Open ID:58757Last modified:4-9-2016

Looks like a known issue. Maybe this will help: Scheduled task in Task Scheduler is leaving stranded pvxwin32.exe task Products Sage 100 Description Scheduled task in Task Scheduler is leaving stranded pvxwin32.exe task Cause Tasks that are run in Task scheduler require a Task Scheduler Log to print. If a printer is not configured to print the log, the task will not complete, leaving a stranded task Resolution Configure default printer on server so user configured to run task can also print Task Scheduler Log Additional information Click here to vote for an enhancement to have ability to create log file instead of printing to paper Category Configuration Settings and preferences Entitlement Open Defect ID 105907 ID:75776Last modified:5-6-2016

Brett, thank you for the info. I will see if we can get a printer setup on the server to print the logs. I will see if that resolves the issue.

Unless I misunderstand, I'm guessing you could just set up a fictitious printer to fake it out.

If you set the default printer as the MS XPS print object, there may be an invisible prompt for a file name...

Denise, I've scripted scheduled DTR's for many modules that print or go to paperless if you decide to give up on yet another hyped feature...