Here we are going to discuss about the issue that causes the Sage 300 customized screen to display unnecessary “UAC popup” prompt when the sage 300 is logged in by non-administrative window user. We have come across this issue mostly in Windows 10 and later versions environment due to advanced security measures that has been implemented for windows OS.
In this blog we will see one of the possible cause for this issue and workaround that resolves this issue.
While working on Sage 300 v2020 upgrades and various screen customizations we came across the scenario that customized screens were not getting opened while current system user is not an administrator. It displays UAC alert while opening screen followed “Sage 300 Application installer” as shown in below screenshots:
There are many possibilities out of which, high security settings for “User Account Control” and unsigned ocx files are common cause.
But the, wrongly modified roto entry can be one of the cause for it, and in this blog we are going to discuss this briefly.
As pet our standard practice we normally copy the standard screen classid from roto.dat file and modify the control name part and classid part from it and set the new classid for customized screen.
Sometimes the standard screen version will be like 6,7,0,20 as displayed in the screenshot below :
As per normal process we will set the major and minor version for ocx while customizing or upgrading screen using VB by using user control project properties and setting Version information in “Make” tab as displayed below:
We mostly does not use the ‘Revision’ part in the version number and by default it remains as it is i.e. ‘0’. But this conflict in roto entry related to control can cause the above specified UAC warning popup to appear before opening the customized screen to Sage 300 and which may ask for system administrator user login before proceeding further. The simplest solution for this will be opening sage 300 with administrator user login but this won’t be always possible or not manageable (for security reasons) to give all Sage 300 users local system admin rights.
This bug can be resolved by properly modifying entry for customized screen.
We have to set version as 6,7,0,0 instead of 6,7,0,20( as in standard screen roto id). Here we have to specify version as 6,7,0,0 as mentioned in ocx properties as we have not mentioning the revision for the OCX control in user control project properties while building the same.
The above changes in roto id value will resolves and prevents the unnecessary UAC popup alerts when the window user is not an administrator. However, in this case the customized screens will get open without any UAC alert when the windows user is an administrator.
Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.
Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com, Dynamics 365 CRM and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using sData and web services to Sage business partners, end users and Sage PSG worldwide. Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.
For more details on Sage 300 and Sage 300c Services, please contact us at firstname.lastname@example.org, We will like to hear from you.