I don't think you need the time stamp when uploading the data, try just using the date. Also make sure you have the class in there. And if I recall you need to have the payrate field which should be an hourly rate and the salary field which would their salary. Based on how the employee is setup to be paid in epicor you need to fill out the right field.
We were wanting to do a mass add of employee pay rate changes using the DMT Payroll..Employee Rate template. I have all the required columns that the template needs to work but whenever I run it, I get an error message (see below) for
every Employee ID I try to update and the update fails.. Anyone have any idea what I’m doing wrong. I tried adding the “emplink” field just to add another level of uniqueness but that still doesn’t work.
Table: PREmpRt
Company='FLEXIAL' EmpID='0063' RateDate='7/11/2016 12:00:00 AM' RowIdent='': ForeignKeyConstraint EmpRate requires the child key values (FLEXIAL, 0063) to exist in the
parent table.
2016-07-11T15:22:24 Company FLEXIAL EmpID = 0068 RateDate = 2016-07-04 Failed to enable constraints. One or more rows contain values violating non-null, unique, or
foreign-key constraints.
Best regards
Mike Abell
IT Manager
Flexial Corporation a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA
I'm not sure what your problem is with the DMT. As an alternative, when we have had problems getting info loaded up via a DMT, we've turned to updateable dashboards to upload. I'm not sure if it is an alternative for your situation, but thought I'd share. We have an individual who is getting pretty good with dashboards. We're on 9.05.702A.
NOTICE: This email and any attachments are considered confidential and intended for the addressee only. If you have received this email in error, please notify the sender as soon as possible and delete this email. If you are not the intended addressee, any dissemination, distribution or copying of this message is strictly prohibited by law.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 11, 2016 3:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 DMT. ANyone ever got the Paryoll employee rate template to work
We were wanting to do a mass add of employee pay rate changes using the DMT Payroll..Employee Rate template. I have all the required columns that the template needs to work but whenever I run it, I get an error message (see below) for every Employee ID I try to update and the update fails.. Anyone have any idea what I'm doing wrong. I tried adding the "emplink" field just to add another level of uniqueness but that still doesn't work.
Table: PREmpRt
Company='FLEXIAL' EmpID='0063' RateDate='7/11/2016 12:00:00 AM' RowIdent='': ForeignKeyConstraint EmpRate requires the child key values (FLEXIAL, 0063) to exist in the parent table.
2016-07-11T15:22:24 Company FLEXIAL EmpID = 0068 RateDate = 2016-07-04 Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
Best regards
Mike Abell
IT Manager
Flexial Corporation
a company of BOA Group
1483 Gould Drive, Cookeville, TN 38506, USA