Sage 100

 View Only
Expand all | Collapse all

VI - cycles vs. app server (Sage 100 advanced 4.50

  • 1.  VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-10-2013 17:08
    VI - cycles vs. app server (Sage 100 advanced 4.50) Have three VI jobs that need to run overnight. One exports AP invoices from company code ""A"", next one imports those invoices to AP invoice data entry in company code ""B"", and the last imports ""payments"" into manual check entry in company code ""A"". This is to move AP from one company to parent company. I'd use the cycle feature, but it doesn't seem to allow you to specify the company, just hours, minutes, etc. In pre 4.40.4 you could create a batch file with VI command line, add it to task scheduler and set it to run. I just got through reading that in 4.40.4 and above for Sage 100 Advanced article 110-405391, you have to create ""Apps"" in the Application Server, then set up the batch file on a workstation and schedule it to run. This contradicts the help file in VI, ""Note Shutting down Sage MAS 90 terminates any job running from a shortcut, whether the job was started before or after Sage MAS 90 was launched."" Is that why you need to use the Application Server to avoid being logged into Sage 100 run the batch file runs? So has anyone done it that way - setup the job in the application server, then a batch file on a workstation running from task scheduler? Or can I just run the batch file on the server....


  • 2.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-10-2013 17:16
    My money is on Alnoor to post the solution.....


  • 3.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-10-2013 17:24
    Maybe I'll just call him and offer him money...


  • 4.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-10-2013 17:43
    Will probably result in the fastest response.......


  • 5.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-10-2013 18:08
    Wow Jeff I'm a little bit speechless. After everything I've contributed and the number of times I've saved your ass, this bit of snarkiness is way below the belt don't ya think?


  • 6.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-10-2013 18:14
    I am running VI Jobs from a batch file and they are working fine (below is the batch file) on V4.40 and V5.0. I have it running from the Window 2008 Task Scheduler. (Note they run in the background) c: cd ""\Flores Apps\Sage\v440\MAS90\Home"" PVXWIN32.EXE ..\LAUNCHER\SOTAPGM.INI ..\SOA\STARTUP.M4P -ARG DIRECT UION user password SFN VIWX0B AUTO @ping 127.0.0.1 -n 40 > nul PVXWIN32.EXE ..\LAUNCHER\SOTAPGM.INI ..\SOA\STARTUP.M4P -ARG DIRECT UION user password SFN VIWI2X AUTO NOTE: They are running as MAS90 Job not MAS200 but it you run on the server it doesn't matter. NOTE 2: the ping command is a wait command so the first imports finisnes exporting prior to importing


  • 7.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-10-2013 18:20
    BTW, I may be out of line but it sounds like the DSD AP multi-company would be helpful. (APMU)


  • 8.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-10-2013 18:29
    Wow, @AlnoorCassim, my apologies!!! My post was more for the CALLING you, NOT the offering money. It has always been my first option to call people in times of critical need to ensure a timely response. If after the initial discussion, it is apparent that a quick solution is not in the near future, then the discussion becomes one involving plan M. Again, my apologies, as that was NOT my intent. And yes, you have ALWAYS been there for me!


  • 9.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-10-2013 18:48
    @JimWoodhead thank you so much, I didn't know about the ping - I use sleep when needed for pauses between executions. You have UION not UIOFF, any particular reason? And no you're not out of line, the AP Multi-company would be great, if the client had the budget. Now I owe you one!


  • 10.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-11-2013 04:33
    @AlnoorCassim I didn't interpret Jeff's comment as a dig and agree you've gone above and way beyond. People should recognize you are bombarded from all sides with tech issues and hopefully are willing to compensate appropriately even on things that they request you share such as scripts or workarounds.


  • 11.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-11-2013 05:23
    I initially read it the same way Alnoor did. Then reading later with fresher eyes (don't ask where I got them) I got what was being done there.


  • 12.  RE: VI - cycles vs. app server (Sage 100 advanced 4.50

    Posted 06-11-2013 11:13
    I think we just expect ""snarkinesss"" from Jeff, recognizing it is just snark with good intentions.