Monday, November 17, 2014

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 


Thursday, July 17, 2014

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. 

Sunday, June 8, 2014

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.

Monday, March 31, 2014

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'

Wednesday, February 26, 2014

Tuesday, February 25, 2014

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...

Wednesday, January 29, 2014

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.

Thursday, January 23, 2014

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"