Schulz Consulting

Consulting and Upgrades

Sage 100 Shipping, Payment Processing and Warehouse Management – Webinar – 8/29/18

by

Are you looking to expand your use of automated shipping, payments and warehouse management with Sage 100 and Sage 100cloud? 

Join Starship, American Payments and Scanforce for a 1 hour review of their integrated solutions.

Learn how ScanForce, APS and StarShip enable you to create a mobile-enabled, integrated warehouse, shipping, and payment processing solution within Sage100 and Sage 100cloud.

It’s easy to modernize your processes in Sage 100. Here are some highlights of what you’ll hear and see in our 1-hour Webinar:

  • Sell more with Mobile Sales 
  • Empower your warehouse for faster fulfillment with WMS and multi-bin management
  • Cut down on shipping costs with integrated carrier rate shopping
  • Get paid faster with “click to pay” invoicing

 

Register for this August 29, 2018 webinar here

 

 

Dsd webinar 0829

Sage Intelligence Financial Reporting – September 12-13, 2018 – Save 20%

by

Save 20% on this two day Sage Intelligence report writing course with code DIVEIN2018C.

Offered by Sage this two day off-site course reviews the following Sage Intelligence skills:

  • Create financial reports using drag-and-drop Report Designer
  • Use the Report Designer Task Pane
  • Change the financial reporting structure using Reporting Trees
  • Automatically distribute and post reports
  • Consolidate the data in multiple company databases into a single financial

    • report

More information on Sage University ( SageU) website – here

Sage intelligence sage100

Sage 100cloud 2018.3 and Payroll 2.18.2 Updates Available for Download

by

Sage has just released the latest product updates for Sage 100cloud 2018 and Payroll 2.18.2.

 

The Sage 100cloud 2018.3 update includes important fixes to the core Sage 100cloud system:

  • Running the credit card settlement report in Accounts Receivable no longer produces an error ( TLS 1.2 compatibility )
  • PO Receipt Header User Defined Field (UDF) now updates PO Purchase Order Header UDF
  • Various Job Cost fixes ( 20 ) since the prior product update
  • Several Sales Order fixes
  • Apply Multiple Sales Orders to an Invoice
  • Improved Calendar Navigation
  • Item Images open in Photo Viewer
  • Sync Misc Charge Changes with Bill Tables
  • Program Fixes

The latest update for Sage 100cloud 2018.3 may be downloaded from the Sage portal – here.  If you are also using the Sage 100cloud Payroll module then download the payroll update from here.

Sage 100 2017.5 was also released. This is the last product update schedule for version 2017. You may access the download here.

 

What Internet Access is Required for Sage 100 or Sage 100cloud (ERP) ?

by

One question frequently asked by IT administrators and users is what level of Internet access is required by Sage 100cloud?  Depending upon what portions of Sage 100 or Sage 100cloud are in use you’ll need varying degrees of Internet access both to your server and potentially to your users’ workstations.

Here’s a list of currently required Internet access for a successful Sage 100cloud installation or upgrade. For the most current info please view this.

As of 5/26/2018:
Sage 100 and Sage 100cloud activation and registration URL requirements
Sage 100 and Sage 100cloud versions can automatically update keys. Reportedly Advanced keys are valid for both Standard and Advanced while Premium keys are valid only for premium:
2015.5+
2016.2+
2017.0+
2018.0+
Versions 5.20.3 (2015.3), 5.20.4 (2015.4), 5.30.1 (2016.1) will have the ability to update the payroll expiration date with the Update button by installing the Hot Fixes based on version KB 83158 ( https://goo.gl/NnlQbY ).
The Sage License Server (SLS) currently requires TLS v1.0 or 1.1
 
 
Sage Exchange Desktop – Credit Card Processing – Paya – Sage Payments
Ports:
SSL port 443
Ports 80, 8080
URLS:
* SageExchange.com
* SageVault.com
* SagePayments.com
Sage Intelligence
Requires direct Internet Access. Use of a proxy may impact athe bility to register the product.
1. First find out about your proxy setting, the best way to eliminate errors is to copy proxy setting from Internet explorer
2. In Internet Explorer, click Tools, Internet Options
3. Select the Connections tab and then select LAN Settings
4. Note the proxy settings in your Internet Explorer.
5. Open Sage Intelligence License Manager
6. Select File, Configure Internet Connection
7. In the Internet Access Type drop down list, select Proxy
8. Click Apply
9. Enter the Proxy Server Address and Port
10. Click Apply
11. If you are required to enter a login, select YES from the Prompt for Proxy logon and click Apply
12. Click OK and continue with registration
Sage 100 2018 Payroll 2.0 (Payroll Tax) / Sage Data Cloud
Sage e-Filing (Aatrix)
https://update.sage.com/au/services/UpdateService
These system requirements can change over time. Please check with your Sage partner or call Sage directly to obtain the most current requirements.
A complete list of supported hardware and operating systems may also be downloaded via the Sage KB here – Sage 100 Supported Platforms.

Crystal Compatibility and Sage 100

by

Have you recently started an upgrade from an earlier version of Sage 100 to Sage 100cloud or Sage 100 version 2018 and run into this Crystal Reporting error?

 

Crystal Report Windows Forms Viewer

“Unable to cast COM object of type”
‘CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass’ to interface type
‘CrystalDecisions.ReportAppServer.Controllers.ISCRReportSource’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{98CDE168-C1BF-4179-BE4C-F2CFA7CB8398}’ Failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

Here’s the reason that you are encountering the error and the way to fix it.

Example: Sage 100 or Sage 100cloud STANDARD upgrade from 2016 to 2018

  1. Install 2018 to SERVER
  2. Run 2018 workstation setup on a WORKSTATION which also has 2016 installed
  3. This breaks Crystal Printing on that 2018 workstation (at this point 2016 workstations can still print)
  4. To fix the 2018 printing, copy the Pvxwin32.exe.Config file from the 2018 SERVER “..\MAS90\Home” directory where Sage 100 2018 is installed, into the 2016 SERVER “..\MAS90\Home” directory of the previous version(s) where the error is experienced.
  5. The issue resolves for 2018 TEST WORKSTATION – BUT …
  6. However, because you copied the config files to the 2016 folder you break printing for 2016 LIVE WORKSTATIONS NOT YET UPGRADED WITH 2018 WKSETUP
  7. Unless those 2016 LIVE WORKSTATIONS (a) also install 2018 WKSETUP (or presumably you remove the Pvxwin32.exe.Config from above which breaks your 2018 workstation but lets 2016 without 2018 installed print ) AND you’ve moved the config described in (4) above.

Business Issue:

  • Generally not a big issue if you are doing an upgrade in one day because you can uninstall 2016 and install 2018 wksetup and everyone can print
  • The problem appears when a customer wants to test over the course of several days/weeks and wants to run 2016 and 2018 on the same workstation(s) in a production environment.
  • You can’t just give one person 2018 wksetup (and move the config to the 2016 folder) without doing the whole company or the fix above breaks the 2016 people who don’t have 2018 wksetup
  • While this may not seem like a huge issue it is problematic in large installs with 20+ user counts, shipping, receiving because of the time it takes to travel from workstation to workstation and debug minor issues,

Possible workaround on this would be:

  • Install 2018 for testing to a standalone workstation that is not used for any prior version
  • Test on this workstation that has no other Sage version(s)
  • When ready run wksetup on remaining workstations and remove prior Sage version
  • The issue with this workaround is other users can’t test various workstation issue such as printing, credit cards, etc

The Sage KB entry which more fully describes the resolution can be read online at – Error: “Unable to cast COM object of type” when printing in prior Sage 100 versions after installing Sage 100 2018

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.
Schulz Consulting