Profile cover photo
Profile photo
Mohammed Tohamy
About
Posts

Post has attachment
Settlement issue in AX2012R3
After
I done the data migration from AX2012FP to AX2012R3 customer realize that there
are some issues in the settlements some of them are not appearing in the   Settle Open Transactions  and
others are not not appearing either in the  Settle Open Transactio...
Add a comment...

Post has attachment
MS Dynamics GP2013 R2: Error the selected company is not configured of the current MS Dynamics GP System database
After restore a database from company A to company B open SQL management then under B database open SY00100 table then correct the CMPANYID and your company ID is located under DYNAMICS.db in SY01500 table.
Add a comment...

Post has attachment
Restore AX db Backup From Another Domain "Log in Failed to Microsoft Dynamics AX 2012FP, R2 and R3"
1. Give the domain user access to the database(s), it should be the same user added in the service log in. 2. Open the command and type "wmic path win32_useraccount where name="{Domain user name Same user used in step 1}". 3. Open USERINFO table and add the...
Add a comment...

Post has attachment
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.
Add a comment...

Post has attachment
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 r un the below script against  the company database Select *  From PA000001  Then run the below sc...
Add a comment...

Post has attachment
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.MC40...
Add a comment...

Post has attachment
How To Reset MS Dynamics GP System Password
UPDATE DYNAMICS..SY02400 SET DMYPWDID=1,PASSWORD = 0x00202020202020202020202020202020
Add a comment...

Post has attachment
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
Add a comment...

Post has attachment
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.
Add a comment...

Post has attachment
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' Del...
Add a comment...
Wait while more posts are being loaded