Integrating master record(s) using GP Macro

Dynamics GP has an inbuilt integration feature which helpful for the users to integrate data from flat files in a precise way.

Before going to start integrating data\record(s), once should create a sample macro for the corresponding screen.

Below example guide to create a consolidated macro for cards screen(Item Master).

1) Record a macro by Tools > Macro > Record from the corresponding screen before entering the sample record.

2) Note the mandatory fields from the screen. Also based on the flat file columns, one can enter the data in the screen during recording process.

3) Once the records entered hit save the entry and go Tools > Macro > Stop Record to create a source macro.

4) Open the source macro, select all the lines and paste in a MS word. Under Mailings > Start Mail Merge > Step by Step Mail Merge Wizard as shown below.

5) Click Directory and Next starting document.

6) Check Use the current document and click Next select recipients.

7) Choose Use an existing list and hit browse to pick the excel file(containing bulk record(s)).

8) Pick the corresponding record sheet, preview the data in Mail Merge Recipients.

9) Insert the corresponding fields to the hard-coded values using Insert Merge Field.

10) Field aligned as shown below.

11) Once the field(s) inserted, click Next arrange your directory and Next preview your directory.

12) First data is appeared for our reference, if there is any mistake hit back and redo the process. If okay, click Next complete the merge to a new document.

13) Now Final macro is ready. Select all,copy the text and paste in a notepad and save the file in macro(*.mac) format.

14) Go to corresponding screen, go to Tools > Macro > Play to choose the created macro for integration.

Thus one can integrate the records using GP macro(s) without using any code in precise time.

Note: One can remain patient during the integration process else macro stops with partial integration.

To learn about integrating a bulk transaction using GP macro? Please stay tuned!!!

Post your comments regarding to this blog.

Regards,
Natarajan S

Customizing Business Portal components in Dynamics GP

In Business Portal, One can customize the page based on the end user roles. The user who customize the Business Portal must be an Administrative user and BP Internal User.

Please find the below steps to customize the Business Portal components.

1) Login as Administrative user.

2) From the home page, go to Site Actions > Site Settings > People and Groups to open People and Group page.

3) In the Peoples and Groups page click more from Groups pane to list the default groups. Select BP Internal User to add the user to that group(If the end users access all the BP pages). 

4) Before customizing the Page, List and segregate the users based on their roles. Users with higher roles should added to BP Internal User, rest can face the customized page.

5) In the Home page, click Site Actions > site Settings > Modify Navigation to open navigation page.

6) From the site Navigation settings page, one can perform the list of options

Hide a web page

One can hide the list of pages based on the above hierarchy.

7) Once the changes done. the end users face the customized page based on their roles.

Add or remove web part

One can also add or remove web part for certain web page by, go to Site Actions > Edit Page

8) Click publish to save the changes.

Post your comments regarding to this blog.

Regards,
Natarajan S

Things to be configured to proceed with Dexterity development

Developing customization's in GP has been done by few ways depends on the requirement but most probably every one has an eye on Dexterity development to start with.

To start with customization development in dexterity, please make sure the following things are adopted in the dexterity installation location so that the developers can easily navigate to test mode through development dictionary to test their development and changes.

Go to Dexterity installation folder, Backup the following files

1) Back the Dex.ini file to the new place or rename it to some name(eg: DexOld.ini).

Go to GP Installation folder and copy the following files

1) Dex.ini file from data folder in GP installation location

2) GPDWin32.dll from GP installation folder

Paste the GPDWin32.dll file to Dexterity installation folder and paste the Dex.ini(from GP installation folder) to data folder in Dexterity installation location.

Now you can launch the Dexterity, do some customization and test the customization by test mode.

Thus you can easily swap from development dictionary to GP front end through test mode and vise versa.

Post your comments regarding to this blog.

Regards,
Natarajan S

Extenders for Dynamics GP

Extender for Dynamics GP, used to capture user defined information without code by adding additional window(s) to the main screen. It is also used to expand notes and macros.

Assign multiple windows to any form and gain instant access to look ups and sub forms. Extender makes data entry and navigation fast and intuitive.

By using we can generate custom smartlist(s) report based on our needs.

The below example guides you to setup additional window for Sales Transaction Entry

1) Go to Microsoft Dynamics GP > Tools > Extender > Extender

2) Select Detail windows and click New to create a extender screen

3) Click Options to choose the extender screen appearance.

4) Now check the entry and make sure the extender screen appear in correct occurrence.

Post your comments regarding to this blog.

Regards,
Natarajan S

Table import in Dynamics GP

Table Import in Dynamics GP, a powerful feature to import records from the flat file based on the table structure. Please find the below steps to integrate the data.

1) Go to Microsoft Dynamics GP > Tools > Integrate > Table Import to Open the Table Import    Definition screen.

2) Define a name and description related to current import process.

3) Choose the file format, point the source file and choose the corresponding table.

4) Map the flat file field to the corresponding table field.

5) click Import to integrate the flat file records.

6) We can receive a status message after every integration.

Note: 
1) Before importing a record from flat file, make sure the flat file columns exactly match the GP table columns and also your flat file must contains the data of required fields in respective GP screen going to import.

2) It is mostly preferred to import the master data and it is not recommend for transaction table(s) to face the transaction error(s).

Post your comments regarding to this blog.

Regards,
Natarajan S

Adding Custom Report to GP Home page Metics\Business Analyzer

It is easy to add a custom SSRS report to GP home page Metrics\Business Analyzer. Please find the below steps.

1) Create a custom SSRS report which has to be run with default parameter(s).

2) Launch report manager url where the standard GP SSRS reports are deployed.

3) Go to the corresponding company folder >> corresponding module folder and make sure Charts And KPIs folder is present.

4) Upload the custom SSRS rdl file.

5) Click Manage > Data Sources to point the data source. Point the corresponding company database

6) Click OK to save the changes and make sure the report is running in report manager.

7) Launch GP, open Customize your home page screen and click Metrics\Business Analyzer expansion button to open Metrics Detail screen.

8) Choose the custom report and click insert to save the changes

9) Now the report get added to the GP home page as shown below

Post your comments regarding to this blog.

Regards,
Natarajan S

Importing ADP transactions into General Ledger

Accountants now have the feature to import payroll transactions from their legacy system to Dynamics GP's Journal Entry. Payroll Connect lets you import Automated Data Processing (ADP) account  transactions from an ADP file into Microsoft Dynamics GP General Ledger.

You can achieve this from Payroll connect's Import From ADP

1) Export the payroll transactions from the legacy system.

2) Transaction file must be in the below format as shown below

"","001100000","GJ","04302014","6000.80","REF 1","DESC 0","REF 2","REF 3","02"
"","001100000","GJ","04302014","-1000.20","REF 1","DESC 1","REF 2","REF 3","02"

field details as listed as reference

Client Code - This field is assigned by ADP but is not used in Microsoft Dynamics GP. If this  field is not used in Microsoft Dynamics GP, you can leave this field blank.

GL Account Nos - This field is used for the distribution account number. Do not use spaces, dashes or commas.

Journal Source code - If you create a batch for the import, GJ (General Journal) is displayed in the Batch Type field.

Date - This field is not used in Microsoft Dynamics GP. The transaction date for  the journal entry is used as the date that is entered in the import window.

Amount - This field is used for the debit lines and the credit lines of the distributions. Negative amounts are preceded by a minus sign (-).

Ref Nos 1 - This field is not used in Microsoft Dynamics GP, but still must exist.

Desc - This field is used as the description for the corresponding distribution line.

Ref Nos 2 - This field is not used in Microsoft Dynamics GP, but still must exist.

Ref Nos 3 - This field is not used in Microsoft Dynamics GP, but still must exist.

Record code - This field is assigned by ADP but is not used in Microsoft Dynamics GP.

3) Export and save the file as comma delimited file(*.csv).

4) Open GP, go to Microsoft Dynamics GP menu >> Tools >> Integrate >> Import From ADP

5) Choose an existing batch or create a new batch.

6) Pick the transaction date.

7) Choose the file and click Process.

8) Now the file get convert as JE once it dint encounter error during import.

Post your comments regarding to this blog.

Regards,
Natarajan S

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