Author Archives: nijamkhan

About nijamkhan

I am simple Hardworking,and i would like improve the Knowledge time by time

You receive an error message when you try to access, to enter, to save, to print, or to post transactions in the Sales Transaction Entry window in Microsoft Dynamics GP

SYMPTOMS When you try to access, to enter, to save, to print, or to post transactions in the Sales Transaction Entry window in Microsoft Dynamics GP, you receive one of the following error messages: A get/change operation on table <table_name> … Continue reading

Posted in Uncategorized | Leave a comment

Great Plains Error – A get/change first operation on table ‘coProcess’ failed

1. Log in to Microsoft Dynamics GP as sa user. 2. Click the Tools menu, click Setup, and then click User. 3. Click the user who is receiving the error message. Make sure that you can successfully access this user. … Continue reading

Posted in Uncategorized | Leave a comment

Error message when you try to delete a user record that is stuck in the User Activity window: “Get Change Operation on SY_Current Activity Record Was Already Locked”

SYMPTOMS When you try to delete a user record that is stuck in the User Activity window in Microsoft Dynamics GP or in Microsoft Business Solutions – Great Plains, you receive the following error message: Get Change Operation on SY … Continue reading

Posted in Uncategorized | Leave a comment

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