A Get/Change First Operation on Table coProcess failed Accessing SQL Data error message when you log into Microsoft Dynamics GP after moving from one server to another

Issue : 
         
                                A Get/Change First Operation on Table coProcess failed Accessing SQL Data” error message when you log into Microsoft Dynamics GP after moving from one server to another

Solution :

Step 1 : Goto sql server management studio and open sql server

Step 2 : Expand databases

Step 3 : Expand Company Database

Step 4 : Expand security node in under company database

Step 5 : Expand users

Step 6 : Delete the user(Which user you trying to login GP)

Step 7 : Login GP using sa user

Step 8 : Goto Microsoft Dynamics GP--Tools--Setup--System--User Access

Step 9 : Select the deleted user and uncheck the company access

Step 10 : Again check the Company access

Step 11 : Select OK

Step 12 : Goto Microsoft Dynamics GP--Tools--Setup--System--User Security

Step 13: Select the user and assign the role

Now you can login GP using same user

                             

Unable to start the Transact-SQL debugger, could not connect to the Database Engine instance ‘XXXX’. Make sure you have enabled the debugging firewall exceptions and are using a login that is a member of the sysadmin fixed server role.

Issue :

          When i am trying to debug the Stored Procedure from sql, i got the below issue.

"Unable to start the Transact-SQL debugger, could not connect to the Database Engine instance ‘XXXX’. Make sure you have enabled the debugging firewall exceptions and are using a login that is a member of the sysadmin fixed server role."

Solution : 
     
Step 1 :Expand the Security
Step 2 :Right click of Logins
Step 3 :Select New Login

Step 4 : Enter your windows user name
Step 5 : User name should be Domain\User Name
Step 6 : Go to Server roles
Step 7 : Select Public
Step 8: Go to User Mappings and select Database(Which database against you want to debug)
Step 9 : Assign role member ship as Public and DYNGRP
Step 10 : Select OK
Now try to debug it will work.
      

Menus for Visual Studio Tools GP 2015

Visual Studio Tools for GP 2015 we can download from Winthrop Development constants portal

Please use the below link for downloading

http://www.mekorma.com/products/visual-studio-integration-toolkit.aspx

How to Change Lot Number expiration Date and Manufactured Date in Dynamics GP

Step 1 : Microsoft Dynamics GP >> Utilities >> Inventory >> Edit Lot Number Attributes

Step 2 : Select Item Number

Step 3 : Select Lot Number

Step 4 : Change Expiration and Manufactured Date 

Step 5 : Select Process

Cannot Insert Duplicate key row in object AAG40000 with unique index 'XXXXXXX'.

Issue :

In my case i have two separate companies.One is live and another one is test.I have restored company data base from live company to test company.In my live company analytical accounting is activated.So when ever i tried to post transaction in test company i had analytical accounting related issues.Below i given the solution for that.

Solution 1:

Restore the dynamics database from live server to test server.
Solution 2:

1. Update the status of AA to '1' (1=installed, but not activated) to start the activation process over. Run this script against the Dynamics database:

Update AAG00104 set aaCompanyStatus = '1' where CMPANYID = 'xx'

(Insert the value of the Company ID from the SY01500 table for the xx placeholder.)


2. Execute these scripts in to clear out all the AA data tables. Run these scripts all at the same time against the company database:

Delete AAG10000

Delete AAG10001

Delete AAG10002

Delete AAG10003

Delete AAG20000

Delete AAG20001

Delete AAG20002

Delete AAG20003

Delete AAG30000

Delete AAG30001

Delete AAG30002

Delete AAG30003

Delete AAG40000

Delete AAG40001

Delete AAG40002

Delete AAG40003

3.Start the activation Process

GO to Tools---Setup--Company--Analytical Accounting--Setup




Select Create Default Record



Select Next

After completing select finish

There is an Active Purchase Order Approval Workflow in Dynamics GP 2015

Issue :

          When i am trying to integrate Receiving Transaction Entry through econnect I got the below issue.
         "There is an active Purchase Order Approval workflow"
 
           This is dynamics GP 2015 econnect procedure issue.I have decrypt the taPopRcptlineInsert procedure.This procedure checks work flow status as 9.But Purchase Order completed Status is 6 not 9.

Solution 1:

                decrypt the taPopRcptlineInsert procedure and modify.

Solution 2:
     
               Step 1 : Update the Workflow status as 9
                         

UPDATE POP10100 SET Workflow_Status = 9 WHERE PONUMBER = @PONUMBER

            Step 2 : Execute the econnect method for integrating purchase receipt

            Step 3 : After integrating again update the status as 6

UPDATE POP10100 SET Workflow_Status = 6 WHERE PONUMBER = @PONUMBER

The Stored Procedure aagCreateGLWorkSLWorkSLRealTimePost returned the following results:DBMS:2627,Microsoft Dynamics GP:2627

Issue :


In my case i have two separate companies.One is live and another one is test.I have restored company data base from live company to test company.In my live company analytical accounting is activated.So when ever i tried to post transaction in test company i had analytical accounting related issues.Below i given the solution for that.

Solution 1:

Restore the dynamics database from live server to test server.
Solution 2:

1. Update the status of AA to '1' (1=installed, but not activated) to start the activation process over. Run this script against the Dynamics database:

Update AAG00104 set aaCompanyStatus = '1' where CMPANYID = 'xx'

(Insert the value of the Company ID from the SY01500 table for the xx placeholder.)


2. Execute these scripts in to clear out all the AA data tables. Run these scripts all at the same time against the company database:

Delete AAG10000

Delete AAG10001

Delete AAG10002

Delete AAG10003

Delete AAG20000

Delete AAG20001

Delete AAG20002

Delete AAG20003

Delete AAG30000

Delete AAG30001

Delete AAG30002

Delete AAG30003

Delete AAG40000

Delete AAG40001

Delete AAG40002

Delete AAG40003

3.Start the activation Process

GO to Tools---Setup--Company--Analytical Accounting--Setup




Select Create Default Record



Select Next

After completing select finish

Calculate SSCC Check Digit

The last digit of a bar code number is a computer check digit which makes sure the bar code is correctly composed. Below is Logic for generating the Check Digit for SSCC number

The following table gives an example to illustrate how a Check Digit is calculated

Below i have created Stored Procedure to perform the check digit algorithm for SSCC

CREATE PROCEDURE [dbo].[CHECK_DIGIT]

(@PALLET_ID VARCHAR(100),@CHECKDIGIT_TOTAL VARCHAR(20) OUTPUT)

AS

BEGIN

DECLARE @LENGTH INT = 0,

                      @i TINYINT = 0,

                      @evenDigitSum INT = 0,

@oddDigitSum INT = 0,

                      @EA INT = 0,

                      @SumOfDigit INT = 0,

                      @TOTALCHECKDIGIT INT = 0,

                      @CHECKDIGIT INT = 0,

@NEAREST_TEN INT = 0,

                      @ROUNDVALUE INT = 0,

                      @ADD_ZERO INT = 0,

                      @CONVERT_STRING VARCHAR(10),

                      @CONVERT_INT INT = 0,

@TOTAL_CHECK_DIGIT INT  = 0

SET @LENGTH = LEN(RTRIM(LTRIM(@PALLET_ID)))

SET @i = 1

WHILE (@i <= @LENGTH)

BEGIN

SET @EA = @i % 2

IF @EA = 0

BEGIN

SET @evenDigitSum = CONVERT(TINYINT, SUBSTRING(@PALLET_ID,@i,1))

SET @evenDigitSum = @evenDigitSum * 3

SET @SumOfDigit = @evenDigitSum

END

ELSE

BEGIN

SET @oddDigitSum = CONVERT(TINYINT, SUBSTRING(@PALLET_ID,@i,1))

SET @oddDigitSum = @oddDigitSum * 1

SET @SumOfDigit = @oddDigitSum

END

SET @TOTALCHECKDIGIT = @TOTALCHECKDIGIT + @SumOfDigit

SET @i = @i + 1

END

SET @NEAREST_TEN = @TOTALCHECKDIGIT % 10

SET @ROUNDVALUE = ROUND(@NEAREST_TEN,2)

IF @ROUNDVALUE > 1 

BEGIN  

SET @CONVERT_INT = 10 - @ROUNDVALUE

END

ELSE

BEGIN

SET @CONVERT_INT = 0

END 

SET @TOTAL_CHECK_DIGIT = @CONVERT_INT

SET @CHECKDIGIT_TOTAL  = CONVERT(varchar(20), @TOTAL_CHECK_DIGIT)

RETURN @CHECKDIGIT_TOTAL

END

GO

You don't have access to this requisition number in Dynamics GP

Error : 

I have configured the PR workflow by department wise and setup approver also. I created new PR and submit it.After submitting it goes to approver based on department.When approver tries to pull up the requisition, that time i got below issue.

              You don't have access to this requisition number

Solution : 

Go to Microsoft Dynamics GP > Tools > Setup > Purchasing > Purchase Order Processing

Click on the requisition button, and then click on the "check box" for all requisition.

Hope this Helps!

How to enable Remember Username and password in Dynamics GP login screen.

In Dynamics GP2010, 2013, 2015 GP allows you to save username and password so that users need not enter their username or passwords each time they login.

But by default you may see GP would have disabled the Remember user and password checkbox.

How to enable it? Here is the solution.

Solution:

Navigate to   Dynamics GP|Tools|Setup|System|System preferences.

Check the Option Enable Remember User checkbox. Click OK.

So when you login next time you will the remember user and password option enabled.

I have tried this and has worked for me, but unfortunately not all the time and not in all the machine. After a small investigation I found there is a switch inDex.ini to be included. Unfortunately GP didn’t add by itself .So open you Dex.ini file in your GP installation folder. Check for the switch

RememberUser=True

If it is not there then add this Switch to your Dex.ini and open GP again. It works for sure. 

Create Chunk file in dexterity for Dynamics GP

1. Open Dexterity Utilities
2. Navigate to File Menu –> Open Source Dictionary (Dictionary you used for your development.)
3. Go to Utilities ->Extract

•                   Give a name for your Extracted Dictionary
•                   Now your Extract dictionary will have all your new forms and reports.

4. Navigate to File Menu –> Open Destination Dictionary ( Use extracted dictionary created in previous step.)
5. Go to Transfer ->Dictionary module

•                   Modified GP Forms and Reports will be updated

5. Close the Source and Destination Dictionary
6. Navigate to File Menu –> Open  Editable Dictionary ( Use extracted Dictionary )
7. Go to Utilities ->Product Information

•                     Enter the details of your product

8. Go to Utilities
9. Auto Chunk

Before performing the above steps its a good and time saving practice to create macro file so that you need not again and again do the above steps.Below are the steps to create macro file in dexterity utilities.

Before creating chunk ,in menu bar you can see a menu named Macro.

1. click Macro
2. select Record

That’s it, from then on what ever you do inside the window will be recorded. once you have completed all the above steps stop macro. Next time when creating chunk file just run the macro.

Also do have a look into David Musgrave Best Practice for Dexterity Version and Build Numbers explaining a very important concept that should be followed in chunk creation process.

Leave a comment

The type or namespace name 'Dynamics' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?) issue in Dynamics GP 2015 R2

Error :

         The type or namespace name 'Dynamics' does not exist in the namespace 'Microsoft' (are you missing an assembly reference?) issue in Dynamics GP 2015 R2.
 

Solution :

            Step 1:    Change the .Net framework to 4.5.1 and build the project
          Step 2:    Close the application and Reopen Visual Studio to Run as Administrator


          

Microsoft sql server native client 11.0 sql server A.NET framework error occurred during execution of user-defined routine or aggregate "GetAsignedUsers"

Error Message :

 Microsoft sql server native client 11.0 sql server A.NET
framework error occurred during execution of user-defined routine or aggregate "GetAsignedUsers"


Solution :

Run this against your Dynamics database:

exec wfDeployClrAssemblies