Hello,I have a client that is on SP5 for GP but the Dynamics Online Services tables are not in their DB. So when the user goes to post cash receipts, he receives errors related to the following tables:• doCreditCardAuthorizationActivity• VMKT.dbo.DO10100• doCashWork• VMKT.dbo.DO10200How do I create the tables so these errors go away? Or is there another preferred solution?
Hi, can you post the complete error message? (or is the above the complete text?)
Have you tried running a Grant.sql against the DYNAMICS and company databases?
If this doesn't work, and you are 100% sure the tables don't exist, then you could look at creating them through Dynamics GP >> Tools >> Maintenance >> SQL. Select just the Create Table and Create Stored Procs options for the tables listd in the error message. (i.e. don't select Drop Table or Drop Auto Proc).
Back up everything first!! all databases. In fact, if you can - do it in a test enviornment and fully test everything before you replicate it in Live.
Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/
Hey I did had that error,
I fixed it by going into Programs > Microsoft Dynamics > GP > Database Maintenance
(not withing dynamics GP, but on your computer)
and run the maintenance utility and recreate the views, stored procedures and triggers for the 6499 product (Dynamics Online Services)
then run Grant.sql
and try again.
This error is temporarily fixed if you disable Dynamics Online Services from the Customization Maintenance window (as a test)
I am guessing that you are using the Nodus Credit Card Advantage software as the DO tables are familure to me and most of my clients use CCA. Contact Nodus directly as there is a maintenance task to be run to build these tables.
Richard L. Whaley Author, Publisher, Consultant
Enhancing your Dynamics Knowledge!
Dynamics Online Services (Product 6499) was added to GP 10.0 in SP5 and GP 2010 in SP1. It caused quite a commotion because of several errors like what you have seen, and also many problems during upgrades. You have discovered one way to fix it. Some others are to do a 'repair' on the install, reinstall the sp and in some cases simply adding to the .set file.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * firstname.lastname@example.org
Thanks Guys - the quick responses are appreciated and reassuring. Both Ian and Francisco sent me on the right path. We were able to recreate the necessary database items to resolve this issue. Here are the steps we performed.
Have everyone logout of GP.
Go into Dynamics (as SA) --> Maintenance --> SQL --> selected Dynamics DB, Dynamics Online Service product, click DO Setup, Create Table and Create Auto Procedures and then process. Then we performed this for each company we selected DO Cash rec work, DO Credit Card svcs activity, DO credit card setup and create tables and create auto procedures then process. Re-run Grant.SQL
Good luck to future folks who need it. This saved us!