Category Archives: Uncategorized

Steps for Installing eConnect using the Microsoft Installation Media

This week’s Tech Tuesday is from our support guru, David Youngquist, who has included steps for installing eConnect using the Microsoft Dynamics GP 2013 installer instead of installing it from the SmartConnect media below: 1. If you prefer to install … Continue reading

Posted in Uncategorized | Leave a comment

GP2015 R2 Upgrade – “ASI_MSTR_Explorer_Favorites: Number of results columns doesn’t match table definition”

After upgrading to GP2015 R2, while doing a routine testing, following error message was thrown while trying to open Smartlist: Full message as follows: Unhandled database exception: A get/change operation on table ‘ASI_MSTR_Explorer_Favorites’ failed accessing SQL data. Number of results columns … Continue reading

Posted in Uncategorized | Leave a comment

“String overflow on set” message in Microsoft Dynamics GP,….Unhandled script exception: String overflow on set ‘[Not Found]’. EXCEPTION_CLASS_SCRIPT_STRING_OVERFLOW,…Symption #2 – A compupter check batch in Payables Management keeps going to Batch Recovery and you get this message: String overflow on set ‘Voucher Number – WORK’.

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs. OPTION 1: In the top menubar in Microsoft Dynamics GP, click … Continue reading

Posted in Uncategorized | Leave a comment

Updating Inventory Decimal Places through SQL

UPDATE IV00105 SET DECPLCUR = 3 WHERE ITEMNMBR = ‘XXX’ GO UPDATE IV00101 SET DECPLCUR = 3 WHERE ITEMNMBR = ‘XXX’

Posted in Uncategorized | Leave a comment

CompanyR.dic and CompanyF.dic needs to be Upgraded to the Company.

Hello Everyone, Today I got an issue like When i logined in to GP ,i got a error please see the below Image: I found the Solution for this,please follow the below steps: 1)Before changing the Dynamic.set file take a … Continue reading

Posted in Uncategorized | Leave a comment

VBA Modifier Forms in Dynamics GP ,Would not show the Data.

If Customized VBA Forms wont reflect the data ,Please follow the Steps. 1)Take the backup of packages from Microsoft Dynamics GP–>Tools–>Customize–>Customization Maintenance. Export all packages like Select all and Click on Export,save the package. 2)Go to the Microsoft Dynamics GP … Continue reading

Posted in Uncategorized | Leave a comment

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help Invalid object name ‘ReportServerTempDB.dbo.TempCatalog’. Could not use view or function ‘ExtendedCatalog’ because of binding errors.

For this Error ,we need to check some of basic information,in your SQL Server management  check on DB’s list like: ReportServerTempDB is available or not, if not? then go to to MS-SQL 2008 r2 Installation folder and Check there ReportServerTempDB.mdf, ReportServerTempDB_log.ldf’ are … Continue reading

Posted in Uncategorized | Leave a comment

Error message when you import purchase orders into Microsoft Dynamics GP from Microsoft Retail Management System Headquarters: “7321-Decimal places passed in for UNITCOST does not match setup”

select * from  IV00105 where  itemnmbr=’OFC’  –update IV00105 set DECPLCUR = 5 where  itemnmbr=’OFC’

Posted in Uncategorized | Leave a comment

How to filter Empty or Null Values IN Smart list Report.

Please Look into the Image: Here We have been filtering the two cases,like 1)In Report 1099 Type is not Equal to “Not a 1099 Vendor”. 2)Second filter is for removing Empty or Null values from Report. Select Column name and … Continue reading

Posted in Uncategorized | Leave a comment

“Prevent saving changes that require the table to be re-created” negative effects”

I was modifying a column in SQL Server 2008 today, changing the datatype from something like currency(18,0) to (19,2). I got the usual error “The changes you have made require the following tables to be dropped and re-created” from SQL … Continue reading

Posted in Uncategorized | Leave a comment