Copy to GL functionality in Dynamics GP 2013 R2

In GP 2013 R2, Accountants now have the ability to quickly copy data from an excel file and paste into the Financial Transaction Entry form.

Please find the below precise step to achieve this

1) Make sure accounting distribution excel ready as mentioned in the below format

2) Open the Journal Entry screen, enter the header details

3) Copy the excel values by excluding headers and click Paste Button from this window

4) The Distribution lines paste accordingly mentioned in the excel

Note: if the excel was not in the proper format, GL Transaction Validation Report appears to highlight the missing and format details

Post your comments regarding to this blog.

Regards,
Natarajan S

Resetting System password in Dynamics GP

Forgot your Dynamics GP system password?

They system password is stored in the SY02400 table located in the Dynamics database.  It is not recommended to remove or reinsert a record in this table.

Here is a simple script to reset the system password allowing the user to  redefine it.

Note:  It is highly recommended that you backup your database before trying out these commands or any other scripts.

Script:

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

Post your comments regarding to this blog.

Regards,
Natarajan S

Resetting System Password in PDK

Forgot your PDK system password?

The system password is stored in the PDK02400 table located in the Dynamics database. It is not recommended to remove or reinsert a record in this table.

Here is a simple update script to reset the system password allowing the user to redefine it.

Note: It is highly recommended that you backup your database before trying out these commands or any other scripts.

Script:

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

Post your comments regarding to this blog.

Regards,
Natarajan S

Dynamics GP SSRS Deployment

If you want to deploy Dynamics GP standard report in Report Server, then please make sure the Report Server is properly configured through Reporting Services Configuration Manager

1) Login to Dynamics GP, Go to Tools > Setup > System > Reproting Tools Setup

2) Paste the Report server and Report Manager URL, choose the desired company to deploy.

3) You can face the below error, Please close GP and run GP as administrator.

" The SQL Server Reporting Services setup information is not valid "

4) Now you can able to deploy the report. During deployment, you can face the below time out error.

5) Go to Report Sever installed folder, Open the Web file and find executionTimeout="9000". Add the maxRequestLength="20690" to that node.

6) Before saving that file, take the backup of the original file.

7) Now the error dint appear while redeploying the report.

8) GP standard reports are deployed in Report Manager as shown below.

9) You can add the deployed reports to your GP Home page, Click Customize this page from Home Tab

10) Customize this page screen appears, Click Business Analyser check box and click Arrow to open Business Analyzer Details screen as shown below.

11) Choose the corresponding reports and click insert

12) Now you can view the inserted report in Dynamics GP Home page.

Note: in Customize this page screen, Please don't check Show All option. if you check then your GP application get hang based on the machine performance.

Post your comments regarding to this blog.

Regards,
Natarajan S