Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

You do not have a licence to use this product on multicurrency databases

Status
Not open for further replies.

Deborahza

Technical User
Jan 16, 2009
17
GB
Hi all,

Have this issue when running a macro. Had it at two different clients with different versions of Sage 300.
One is V6 and the other is 2012 (would need to confirm) and all use SQL.

If they restart the server (using local install) or log off completely and log back in (RDP) it clears the error.

I have attached the one client's error as I could replicate in a test environment.

Any ideas?

TYIA
Debbie
 
The first one is for automatically putting AP Invoices on hold and the other is for a GL extract.
 
Check your code, there must be something weird going on.

Sage 300 Certified Consultant
 
I have seen this issue at various clients that are using RDP to access Sage. After a great deal of research i discovered that the issue is caused by windows being slow to copy over registry keys for the user when they log in. I normally see this the most at clients using RDP and running Sage as part of their login. It is not limited to this as i also have it with full desktop users but not as much. Clicking the Sage icon several times does eventually get it to run.
This is what I found and used. I placed this is a batch files that runs when the user loggs in. This might not be your issue but it fixed mine!
#
# Author: Matthew Arnold (matthew.arnold@live.ca)
# Licese: This file may be freely distributed as long as it remains unchanged.
# Copyright: Copyright ©2014 Matthew Arnold. All Rights Reserved.
# Used to start Sage300 when you do not have a license to run this product is being displayed
# Issue is probably caused by userinit.exe not copying the user reg keys over before the accpac.exe runs

$userSID = ([wmi]"win32_userAccount.Domain='$env:UserDomain',Name='$env:UserName'").SID

Copy-Item -Path "HKLM:\SOFTWARE\Wow6432Node\ACCPAC International, Inc.\ACCPAC\Configuration" -Destination "HKCU:\SOFTWARE\ACCPAC INTERNATIONAL, INC.\ACCPAC" -Recurse -Force
Copy-Item -Path "HKLM:\SOFTWARE\Wow6432Node\ACCPAC International, Inc.\ACCPAC\Configuration" -Destination "Registry::HKEY_Users\$userSID\Software\ACCPAC INTERNATIONAL, INC.\ACCPAC" -Recurse -Force

$path = Get-Item -Path "HKCU:\SOFTWARE\ACCPAC INTERNATIONAL, INC.\ACCPAC\CONFIGURATION" | Get-ItemProperty -Name "Programs" | Select -ExpandProperty "Programs"
& "$path\Runtime\AccPac.exe"
 
Thanks Phil :)
Will give it a try.

Have a great weekend.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top