Sage 100

 View Only
Expand all | Collapse all

I have a client the just moved from an internal se

  • 1.  I have a client the just moved from an internal se

    Posted 06-08-2017 11:19
    I have a client the just moved from an internal server to a cloud hosted Server. (Sage100 version 2017) This is a one-user hosted server with plenty of RAM and processor. The client reported slow printing; I logged into the cloud server and sure enough it was slow (30 seconds to print a 3 page chart of accounts); Preview was a little faster but still took 10 seconds. I reported it to the cloud IT support and they said they logged in and could preview in 1 second or less, but they did not have any way to print. That got me thinking! I turned off my redirected printers before logging into the server and sure enough I could preview same report almost instantaneously. I've logged in and out with and without redirected printers and can confidently say that redirected printers are slowing this down. My question is: Does anyone know what can be done? This is a cloud hosted server, Is it even possible to install a network printer remotely on a hosted server? I wouldn't think so, but maybe there is a way. This is Sage 100 standard so we don't have CS ODBC, but I don't think that would help anyway, they are logging in directly to the server where Sage100 is installed. Would installing the print drivers on the server speed this up? if so is there any trick to installing them and making Sage use those rather than the redirected drivers? This is not urgent but the client is looking for an resolution, so any help is appreciated.


  • 2.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 11:22
    I want to follow along on this one as I have two clients with the same issues. I have read redirected printers can be an issue (when combined with a slower internet connection).


  • 3.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 11:36
    I'm tagging along with Larry for the same reasons.


  • 4.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 12:07
    Crystal reports uses client-side printing, and Sage 100 Standard uses client side processing. The print data has to be passed to the client to be assembled for printing. How is the client connected to the server? Is it a vpn and a remote client, or is the client on the server (like remote desktop).


  • 5.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 12:20
    They are logging in through remote desktop directly on the Sage100 server which I think rules out all network connections.


  • 6.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 12:35
    You can have IT turn off the redirection of the printers.


  • 7.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 12:38
    BTW. This isn't a tested solution just brainstorming.


  • 8.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 12:38
    Set up a vpn. Create a static IP for the printer. Install the print driver on the remote server and print to the IP port.


  • 9.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 12:44
    that sounds like it might work, I'll see what the hosted server's IT gurus think. I have already asked them about installing the printer drivers to see if that helps and I've not heard back from them just yet.


  • 10.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 13:03
    I have had issues several times with re-directed printers and always turn off the redirection if the printer is not needed.


  • 11.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 13:04
    I guess that gets to the heart of my question, if they turn off redirected printers, I don't think they can print.


  • 12.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 13:06
    That is why I mentioned printing over a vpn directly to an ip address. You don't need re-direction. You aren't re-directing anything just printing from the server to the printer. If the client is on the same subnet as the server via a vpn then the printer is local to the server.


  • 13.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 13:45
    If only a single user than this will work. Multiple users from multiple workstations to multiple printers is not a really valid option. All of this is prefaced on a VPN being able to be established between the two locations.


  • 14.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 14:06
    if the multiple users are at the same location and using the same printer then it will work. If there is more than one printer at the same location then you have to set up a printer for each device. Same as a local area network. Even if the users are in two different offices a vpn can be established at each office. Of course, the more WAN bandwidth the more efficient all of the devices operate.


  • 15.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 14:15
    If you have five users at the same location connected via a vpn and all five send a job to the printer at the same time, the print jobs will spool on the server. The last person to send the print job may have to wait in line for the print out, but the printing should use the same network resources. Of course it isn't going to work very well if your vpn is established using a 2400 baud dial up modem. You need to have some dedicated bandwidth.,


  • 16.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 14:36
    I guess what I was saying is that the administration gets more complicated as you get more variables (true with everything I guess).


  • 17.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 15:14
    @GeorgeKhairallah you might be of assistance here :)


  • 18.  RE: I have a client the just moved from an internal se

    Posted 06-08-2017 16:43
    I've done this a couple of ways. For re-directed printers, you want to experiment with whether installing the manufacturer's driver helps or hurts performance. To do this successfully, you must match the driver version with the client's version exactly. If a manufacturer's driver is not available, terminal services will attempt to use ""Easy Print"" which is like ""Plug-and-Pray"". If this is not workable, a VPN as Doug suggested is the best choice however your cloud service may prohibit it. If that's the case, you may want to look at ThinPrint and its competitors.


  • 19.  RE: I have a client the just moved from an internal se

    Posted 06-13-2017 13:53
    just so you don't think I've forgotten everyone, the hosting IT people are currently installing a matching driver I sent to them today. I will then email the client and ask them to test again. I probably won't hear back until tomorrow.


  • 20.  RE: I have a client the just moved from an internal se

    Posted 06-14-2017 13:44
    I just turned on my client to paperless and directed the printing to a driver on the server to a local printer. I am still getting long delays. What is going on with Sage printing inside a terminal server environment.


  • 21.  RE: I have a client the just moved from an internal se

    Posted 06-14-2017 14:00
    we have had problems when the Terminal server uses PCL5 drivers.