Sage 100

 View Only
Back to discussions
Expand all | Collapse all

Sage 2018 Premium Task Scheduler

  • 1.  Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 15:25
    Hi All,  Have a client on 2018 premium with Scanforce.    What they are trying to accomplish is to have Inventory Transactions automatically posted once they are scanned in.   Scanforce wrote a routine to trigger the task after the import is done.  The Task is to print/post the Inventory Transaction register and then print/post the daily transaction register.   The problem is the task does not work and Brian Reddeman said that Task Scheduler is broken in 2018 and should not be used.   
      Does anyone know a way to accomplish this.  I know it can be done with custom programming but wondering if any of the wizards out there know of another option.

    Thanks!!

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------


  • 2.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 15:34

    You would need to create a batch file to use the "execute a Sage program externally" that Sage has always supported.  The only gotcha is that you must set up a default printer for the user you use in the batch file for the register to print to.  Then Scanforce should be able to invoke the batch file to do the posting.

     

    However, this can be fragile, so you may want to go with custom route.

     

    Regards,

     

    Bob Sosbee

    Accounting Systems, Inc.

    810 Dutch Square Blvd Ste 103 | Columbia, SC 29210

    Ph: 803.252.6154x245  | Fx: 803.753.9818 | Toll free: 855.383.6154

    E-Mail: bsosbee@asifocus.com

    Web: www.asifocus.com

    Follow Us: Twitter | Facebook | LinkedIn

     

    Confidentiality Notice: This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this email in error, please reply immediately and delete the message.

     



    ------Original Message------

    Hi All,  Have a client on 2018 premium with Scanforce.    What they are trying to accomplish is to have Inventory Transactions automatically posted once they are scanned in.   Scanforce wrote a routine to trigger the task after the import is done.  The Task is to print/post the Inventory Transaction register and then print/post the daily transaction register.   The problem is the task does not work and Brian Reddeman said that Task Scheduler is broken in 2018 and should not be used.   
      Does anyone know a way to accomplish this.  I know it can be done with custom programming but wondering if any of the wizards out there know of another option.

    Thanks!!

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------


  • 3.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 15:51

    Hey Bob,

      That was exactly what I was thinking however I got stuck on what the task name would be for the batch job.  Generally, this was done for VI and you used Sage's name for the job.   What would I use for the Inventory Transaction Register?   

     

      In Task Manager, it creates a name for the task but I don't believe I can use that..

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     



    ------Original Message------

    You would need to create a batch file to use the "execute a Sage program externally" that Sage has always supported.  The only gotcha is that you must set up a default printer for the user you use in the batch file for the register to print to.  Then Scanforce should be able to invoke the batch file to do the posting.

     

    However, this can be fragile, so you may want to go with custom route.

     

    Regards,

     

    Bob Sosbee

    Accounting Systems, Inc.

    810 Dutch Square Blvd Ste 103 | Columbia, SC 29210

    Ph: 803.252.6154x245  | Fx: 803.753.9818 | Toll free: 855.383.6154

    E-Mail: bsosbee@asifocus.com

    Web: www.asifocus.com

    Follow Us: Twitter | Facebook | LinkedIn

     

    Confidentiality Notice: This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this email in error, please reply immediately and delete the message.

     





  • 4.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 15:56
    What does "the task does not work" mean.  Auto-Posting can be difficult to get running under any circumstances.  You generally need to use a Windows account with local admin permissions, and a valid / online physical printer (no mapped print object, local with full permissions) as the default. Never chain posting the DTR in the same task.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 16:11
    (We have a 2018 Premium customer who uses auto-post nightly...).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 6.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 16:25

    Kevin,

      It means when you run it, nothing happens.   It does not update the batch.  Yes, default printer, admin permissions, etc.  Had Sage review more than once.   The tech said they get calls like this all the time and that the Task Scheduler in 2018 is broken.   That part was from Brian Reddeman.

     

      I will try removing the DTR from the task.  That part is not critical – only the inventory levels.     Thanks for the info!

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     



    ------Original Message------

    (We have a 2018 Premium customer who uses auto-post nightly...).

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------


  • 7.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 16:35
    Task Scheduler certainly was broken on Premium, but that was before v2018.

    Can you "Run Now" successfully?  Does your scheduled start attempt get logged anywhere?


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 8.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 16:46
    If it helps, we trigger the update from a scheduled batch file, not directly from Task Scheduler. 

    schtasks /run /s SERVERNAME /tn "SCHEDULEDTASKNAME"

    We get the task working, enabled but not scheduled (create using the Sage interface, then tweak settings like "Run with highest privileges" directly in Windows Task Scheduler...), then don't even breathe in the general direction of it... triggering from a different scheduled task.

    It goes without saying that mapped drive paths can't be used, and bad print objects are a constant issue.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 9.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 16:34

    Howdy, Bob!

     

    Sage's name for it is IM_TRANSACTIONREGISTER_UI which may need .pvc added to the end.

     

    Regards,

     

    Bob Sosbee

    Accounting Systems, Inc.

    810 Dutch Square Blvd Ste 103 | Columbia, SC 29210

    Ph: 803.252.6154x245  | Fx: 803.753.9818 | Toll free: 855.383.6154

    E-Mail: bsosbee@asifocus.com

    Web: www.asifocus.com

    Follow Us: Twitter | Facebook | LinkedIn

     

    Confidentiality Notice: This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this email in error, please reply immediately and delete the message.

     



    ------Original Message------

    Hey Bob,

      That was exactly what I was thinking however I got stuck on what the task name would be for the batch job.  Generally, this was done for VI and you used Sage's name for the job.   What would I use for the Inventory Transaction Register?   

     

      In Task Manager, it creates a name for the task but I don't believe I can use that..

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     





  • 10.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 17:02
    What does the /tn in this line represent @Kevin Moyes?

    schtasks /run /s SERVERNAME /tn "SCHEDULEDTASKNAME"


    ​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


  • 11.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 17:10
    That is the task name, as it appears in Windows Task Scheduler.  "schtasks" is a Windows utility.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 12.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 19:19
    Understood, thank you!

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


  • 13.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-11-2020 23:50
    I'll add that i did have to report an issue with the task scheduler to sage a while back but they were supposed to have patched it in one of the product updates that followed. Here is the KB article for it.
    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=92735

    However, the biggest issue with the task scheduler feature is its insistence on printing out the task scheduler log after each run. I work around this by setting up a virtual printer using the generic text driver with a port that points to a local file, i.e. "C:\Sage\PrinterOutput.txt". Then you can set the printer as the default printer for the user that the task will run under, this will make sure you won't have printer related issues for the task log. You can still use paperless for the actual journal/register. The user that the task runs under must have sufficient rights to all paths involved.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


  • 14.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-12-2020 10:58
    I've more commonly used a paused print queue (to not waste paper on those useless logs), but the generic driver / text file output is a good idea.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 15.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-12-2020 12:38

    Hi All,

      Removing the DTR from the task got it to work (and making sure I had the correct default printer).    Now just have to setup the batch after hours to test.    Thanks everyone!

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     



    ------Original Message------

    I'll add that i did have to report an issue with the task scheduler to sage a while back but they were supposed to have patched it in one of the product updates that followed. Here is the KB article for it.
    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=92735

    However, the biggest issue with the task scheduler feature is its insistence on printing out the task scheduler log after each run. I work around this by setting up a virtual printer using the generic text driver with a port that points to a local file, i.e. "C:\Sage\PrinterOutput.txt". Then you can set the printer as the default printer for the user that the task will run under, this will make sure you won't have printer related issues for the task log. You can still use paperless for the actual journal/register. The user that the task runs under must have sufficient rights to all paths involved.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------


  • 16.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-15-2020 21:02
    @Bob Sosbee please post the results, thank you.​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


  • 17.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-17-2020 10:27
    Howdy, Moira!
    I think you mean @Robert Osborn...
    ​

    ------------------------------
    Bob Sosbee
    Senior Developer
    Accounting Systems, Inc. (ASI)
    Covina CA
    803-252-6154 x245
    ------------------------------

    Original Message


  • 18.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-17-2020 11:52
    Hi Moira,
       Well ran headlong into a brick wall.  Went I setup the task in the application server, the task "disappeared" in Sage Task Manager.  Recreating it gave me a message that access is denied.    I am going to remove it from the application server and revert back to the task scheduler.    Sounded like a good idea in theory.

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------

    Original Message


  • 19.  RE: Sage 2018 Premium Task Scheduler

    Posted 02-17-2020 15:55
    Thank you for the update @Robert Osborn.
    ​

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------

    Original Message


Related Content