Mohammed Tohamy : Cannot locate another server in GP2013 R2 in GP ut...

Mohammed Tohamy : Cannot locate another server in GP2013 R2 in GP ut...: Open start menu put the below link C:\Windows\SysWOW64\odbcad32.exe Then Create your new ODBC and locate your server.

Cannot locate another server in GP2013 R2 in GP utilities

Open start menu put the below link
C:\Windows\SysWOW64\odbcad32.exe

Then Create your new ODBC and locate your server.

MS Dynamics GP: This contract is being used by another user.

1. Let all users log off from GP.
2. Try to access the same contract, if you still getting the same error run the below script

Open SQL Management Studio then run the below script against the company database

Select * 

From PA000001 

Then run the below script 

Delete PA000001 

Maximum stored procedure, function, trigger, or view nesting level exceeded

While upgrade from GP10.0 SP2 to GP10.0 SP5 and running the GP utilities i got the below error 

Case:

CREATE TRIGGER [dbo].[zDT_MC40200U] ON [dbo].[MC40200] AFTER UPDATE 

AS

set nocount on

BEGIN

UPDATE dbo.MC40200 SET DEX_ROW_TS = GETUTCDATE()

FROM dbo.MC40200, inserted 

WHERE MC40200.CURNCYID = inserted.CURNCYID

END

set nocount off

GO

Invalid Column Name DEX_ROW_TS

Solution:

I've created this column manually in Dynamics.dbo.MC40200 then re-run the utilities and it has been passed. 

How To Reset MS Dynamics GP System Password

UPDATE DYNAMICS..SY02400 SET DMYPWDID=1,PASSWORD = 0x00202020202020202020202020202020

Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'run'.

while running that script "run DBCC CHECKDB" i got the above error to solve it create the following stored procedure and re-run the script again.




CREATE PROCEDURE run

AS

SELECT * FROM SYS.tables

An inconsistency was detected during an internal operation in database 'tempdb'

Also if you lost the "Tempdb" tables, all what you have to do is restart the SQL server as the Tempdb" tables created each time you restarting the SQL server.

This Document Number has been used- Billing- MS Dynamics GP

First you have to delete the document number in RM00401 and run the following script:

Delete PA13100 where PADocnumber20 = 'XX'
Delete PA13200 where PADocnumber20 = 'XX'
Delete PA13202 where PADocnumber20 = 'XX'
Delete PA10802 where PADocnumber20 = 'XX'
Delete PA01901 where PADocnumber20 = 'XX'

Mohammed Tohamy : Deploy the default reports AX 2012

Mohammed Tohamy : Deploy the default reports AX 2012: 1.        Open Microsoft Dynamics AX 2012 Management Shell from Administrative Tools                      I.                         C...

The journal entry number you've entered doesn't exist, hasn't been posted or is in history. enter or select a valid journal entry number

Update the missing required fields in GL10000 for that Journal and opened it then post it.

Mohammed Tohamy : Deploy the default reports AX 2012

Mohammed Tohamy : Deploy the default reports AX 2012: 1.        Open Microsoft Dynamics AX 2012 Management Shell from Administrative Tools                      I.                         C...

Deploy the default reports AX 2012

1.       Open Microsoft Dynamics AX 2012 Management Shell from Administrative Tools

                     I.                        Click Start > Administrative Tools.

                    II.                        Right-click the Microsoft Dynamics AX 2012 Management Shell option.

                  III.                        Click Run as administrator.

2.       Retrieve a list of the reports that are included with Microsoft Dynamics AX, and store the list in a local variable by entering the following command:

Windows PowerShell

      $reports = Get-AXReport -ReportName *

3.  View the list of reports by entering the following command:

Windows PowerShell

$reports

4.       To deploy all reports, enter the following command:

Windows PowerShell

Publish-AXReport –ReportName *

5.       To deploy two or more specific reports, enter the names of the reports. For example, to deploy the CustTransList and CustTransOpenPerDate reports, enter the following command:

Windows PowerShell

Publish-AXReport -ReportName CustTransList, CustTransOpenPerDate

Error While Installing AX2012 R2

Error:

The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. (Exception from HRESULT: 0x80070422)

Solutions:

It's the windows update service is disabled, enable it and error will be resolved.

AX 2012 R2 Reports Deployment Errors

Case:

You do not have privileges to deploy to server: "Server Name". For deployment, you must have administrative rights to the SQL Server Reporting Services (SSRS) server. Contact your administrator to deploy.

Solutions:

Try the following command while publishing the default reports

For All Reports : "Publish-AXReport -ReportName * -SkipReportServerAdminCheck"

For Single Report : "Publish-AXReport -ReportName CustTransList -SkipReportServerAdminCheck"

System could not find the domain in ax 2012

Simply add the domain server IP in your local machine DNS IP.