Microsoft GP (Great Plains)

Modifying operational records not imported properly due to a preemptive save in the ERP system
****Modifying data in the QES system should not be taken lightly and should only be done on the advice of our support staff.   Changing a system value to an...
Fri, 19 Jun, 2020 at 10:36 AM
Table details - Microsoft GP Vendor Combiner Error
When trying to combine vendors you get the following error: Conversion failed when converting the varchar value 'xxxxx' to data type int. The stor...
Fri, 19 Jun, 2020 at 10:37 AM
Implementation - Version Compatibility Matrix
Last Updated: Jan-19, 2015 The latest Horizons / Quality Essentials Suite software is listed here in a easy to use matrix.  Locate your Great Plains Versio...
Fri, 19 Jun, 2020 at 10:40 AM
Failed to Enable Constraints message
Q: I am using the HMS version of QES and getting an error "Failed to enable contstraints.  one or more rows contain values violating non-null, unique, ...
Fri, 19 Jun, 2020 at 10:42 AM
Find out what version of Microsoft GP (Great Plains) you are running
If we ask for your GP version please follow the steps below and send us a reply with the screenshot in it. 1) Open Microsoft GP 2) Click on the help ques...
Fri, 19 Jun, 2020 at 10:44 AM
Great Plains Security on SQL Tables
If for any reason you need to apply security against the GP tables eg. after an upgrade you can manually add the permissions with the following scripts.   R...
Tue, 21 Jul, 2020 at 11:08 AM
GP Horizons Manufacturing Table Resources
Horizons Manufacturing System – Tables   HMS Setup BOM50500 & 511 – HMS Setup window BOM50501 – Install and Setup – holds HMS version infor...
Wed, 21 Jul, 2021 at 4:14 PM
Installing HMS Report Viewer
Download the latest HMS installation zip file Create SQL user called "Reporting" that has access to the required company database and DYNGRP rol...
Tue, 7 Dec, 2021 at 3:13 PM