Customer Knowledge Base

Space shortcuts

Page tree

To setup Dealertrack interface:

Steps:

  1. go to Setup > Preferences > Interfaces
  2. Select DealerTrack Detail (seamless) and click Save.

Then please follow these steps:

  1. Login to Dealertrack/iConnect system
  2. [NOTE: Steps 2-3-4 are one time setup only!]  Go to Data Exchange application menu and then select OpenTrack
    1. If you don't see OpenTrack menu option under Data Exchange application menu, your user security will need to be adjusted. Under User Security, find Data Extraction section and enable "Authorize to OpenTrack"
  3. After clicking OpenTrack link, you'll see Active Methods screen. Here click the Add button
  4. For Method, select Accounting. For Vendor field, select PAYMATE SOFTWARE from the list. Enter Access Begins date in mmddyy format. You don't have to put a date into AccessEnds field.
  5. Go to Clarity/Platinum. Go to Payroll->Export->Export to G/L Special
  6. Under Preferences set the "batch Date", this will affect the period in which the Journal Entries are posted too.
  7. Set your G/L export preferences (dates etc.)
  8. Go to G/L Preferences tab
    1. Click on the Information link from the top right menu on iConnect. Note the Arkona server number (e.g. ARKONA1 or ARKONA2). The "Server name" parameter in Paymate is the Arkona server in iConnect system. So if your server is "ARKONA1", enter ARKONA1.ARKONA.COM in Server name field. If your server name is ARKONA2, enter ARKONA2.ARKONA.COM under Server name.
    2. From the Information link at the top, find your Company number (2 characters usually) and Enterprise code (4 characters usually). Enter these parameters into Paymate G/L parameters
    3. For username, enter paymate
    4. For password, enter jd?p5C0
    5. Journal value can be found iConnect, click on Enter Transactions and then click on Journal dropdown. A new window which contains Journal codes will come up. This is a 3 character code and usually it is PAY (for PAYROLL). The G/L entries will be posted to this journal.
    6. Journal Description: Please enter a description here, such as "February 02, 2012 Salary Payroll"
    7. Click Next and click Export. Your entries will be exported to Delatertrack/iConnect system
      1. If you receive an error, please take a note of the error message. Ensure that Paymate is setup under Vendors list (step 4)

Paymate also has a seamless interface to retrieve your G/L accounts from Dealertrack/iConnect. Go to Setup->Preferences->Interfaces and enable the "Use code finder" feature, then go to Setup->General Ledger Settings->Refresh G/L Code Finder. The parameters required are the same as G/L Export screen, and you will need to give access to PAYMATE in vendors list.

NB.

The employee number will be used as the Control Number during exports.  The control number does NOT have to exist in DealerTrack UNLESS the Journal Entries are being posted against a Accounts Payable or Accounts Receivable GL Account Code.

If the GL account is a Accounts Payable the Employee must be setup as a VENDOR

If the GL account is a Accounts Receivable the Employee must be setup as a CUSTOMER

If the customer is planning on printing their payroll cheques via DealerTrack then the Employees would likewise be defined as VENDORS


For assistance in setting up OpenTrack follow this document

OpenTrack Vendor Setup.pdf