RE: Error message when you start Microsoft Dynamics GP on a client workstation: "A product on the computer is on a different version than the database version"
Derek Albaugh
I'm trying to add the CPY (7131) on my existing 18.2.1036 US setup.. Since you can't select the module 7131 CPY from the control panel after the setup was done in a non-CA country, I threw the chunk file CANPAY.cnk into the GP folder and started GP.. When running GP Utilities, it complains about not being able to upgrade module 7131:
First I realized that the CANPAY.cnk was of an outdated version 18.0.0376 (I believe), so it would make sense that the upgrade wouldn't work. I then extracted the chunk file from the YE Tax update CAN, which is build 18.2.1058 and copied it into the GP folder..
GPU would complain again :
Failure encountered ON 5/28/2020 at 10:56:52 AM. Error: Product 7131 does not support upgrading from version 18.0.628.
I then wiped out all referenced entries in DU000010, DU000020, DU000030 & DB_Upgrade about 7131, and ran GPU again.. this time it was a much lower version complain:
Failure encountered ON 5/28/2020 at 12:17:08 PM. Error: Product 7131 does not support upgrading from version 8.0.0.
I made a backup of the DU000010 entries for 7131 and can put them back, as it looks like the upgrade path is missing some versions within that table apparently..
I know about the only supported way from MS to add CPY to UPR in an existing GP instance (US) is to setup another GP instance, which I find a little silly.. as many companies are facing this problematic after proceeding with acquisitions and merger. Most time it's the other way around, having a CAN setup that needs to add UPR, which is much easier, but in some cases it's a US company that needs to add a Canadian branch and wants to use Payroll too.