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