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
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.
Regards,
Natarajan S
No comments:
Post a Comment