You’re offline. This is a read only version of the page.
Just did Year End Update for Dynamics GP 2010. Now when Accounting tries to enter a Cash Receipt they get a string of errors starting when the put the check number in. I will list them in order.
-GPS Error SCRIPT NAME GetLastCashCreditCardGuid : 41 Click OK
-SQL Error SCRIPT NAME GetLastCashCreditCardGuid : 207 {Microsoft}[SQL Server][Invalid column name 'NextElectronicNumber' Click OK
-ODBC Error SCRIPT NAME GetLastCashCreditCardGuid :S0022 Click OK
-A get/change operation on table 'doCustBillingAddress' cannot find the table, when saving.
When the user clicks OK and posts this batch it seems to post OK but I am worried about all the errors and would like to correct.
Thanks in advance,
Zach Ungerman
IT Manager/Dairy Specialists
*This post is locked for comments
Hi dbergmanroc,
Did you exactly do as suggested by Bill Cambell? While removing the 6449 Product from the Dynamics.set and DynUtil.set. Did u decreased the number count from the top by 1 ? e.g If the total count before deleting a product is 11, if you remove a product it should be decreased by 1 and set it as 10.
Are you getting any error message while trying to log into GP? if so, can you share the error details it will be useful for us to figure out your exact problem.
Bill, I did this now I can't get back into GP at all and there were no addins relating to to the online services in the addmins file - just ones from eone for collections management
Zack while I trust that this is not a issue for you any longer, I thought I would post my solution to this matter.
Remove any thing to do with Online Services
1 - Microsoft Dynamics GP > Tools > Customization > Customization Status
2 - Edit 6449 from the Dynamics.set and DynUtil.set
3 - Remove from the Addins folder the GP Online dll
Once this is done we were able to get past all the errors.
Hope this helps anyone else searching with this error.
Zack did you ever get any assistance on this - I am getting a similar problem happening on an old client installation - no errors during the application of the 2014 Tax Update - now when we try to enter Cash we get all kinds of SQL errors.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (