Run Sage 50 / 200 Report Tool v1.4 — Getting “No supported Sage 200 product found or incorrect login details”

Introduction

Tasks with the Run Sage 50 / 200 Report tool, connected to Sage 200c (2017 or 2018), are failing. In the Event Log, you are seeing “No supported Sage 200 product found or incorrect login details”. However, the connection to Sage 200 is valid, as are the login credentials used.

Cause

Due to the underlying structure of Sage 200c (2017 and above), only a valid Sage 200c user can connect. Task impersonsation is required for each task containing a Run Sage 50 / 200 Report step.

Resolution

Each task containing a Run Sage 50 / 200 Report step must be run as the Sage 200c user added in the Run Sage 50 / 200 Report‘s global configuration. This user must also be part of the same domain as the user logged into the BPA Platform server for task impersonation to work.

  1. Open the relevant task.
  2. Go to the General tab and click Options.
  3. Go to the Impersonation tab.
  4. Enable Specify User.
  5. Click Browse.
  6. In Enter the object name to select enter same the username as in the Login field of the Run Sage 50 / 200 Report‘s global configuration.
  7. Click Check Names, then OK.
  8. Click OK.

    The Domain field should be automatically filled in.

  9. Enter the relevant Password.
  10. Repeat for all other Run Sage 50 / 200 Report tasks.