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

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

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