120
We upgraded to 18.3 to 18.5 over the weekend. We just did our first Credit card batch using a bank 3rd party application and keep getting this error:
A save operation on table 'VPaymentWork' failed accessing SQL data. Microsoft SQL Server Invalid Column Name 'DOCTYPE'
Does anyone have any idea what this error means? We got the payments to print but not post or process.
Any input would be appreciated. I did send it to the bank's support too to see if they can assist.
Thanks!!
Wonderful, thanks for the update. Have a great day.
It was definitely a table from the 3rd party application we are using. We were able to recreate the table and linked the column. It was due to the upgrade we needed a new file from our bank.
Issue was resolved.
Thanks everyone for their input!!
Along with the GP Power Tools, you'll most likely need to capture a dexsql.log of this error message to find what is causing this error, which will most likely be a stored procedure of some type.
I'm not familiar with a 'VPaymentWork' table, so it may be a third-party or custom table, but either way, if we find the stored procedure, we can look at that procedure in SQL using sp_helptext and find what table(s) it is expecting this DOCTYPE column to be present in.
Once you have that, you can then verify the table(s) have that column or not.
By default, there are over 90 tables in Dynamics GP that have this DOCTYPE column in them, depending on what modules you have installed, so a log file would help narrow it down.
Thanks
Hi Barb
You need to identify which product the VPaymentWork table is from.
If you have GP Power Tools, you can use Resource Information to identify the product quickly and then recreate the table with SQL Maintenance (as long as Database Tools module is registered) GP Power Tools will backup and restore the data when the table is dropped and recreated.
Every GP customer should have GP Power Tools as it was initially created for solving issues with GP.
Regards
David
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (