Open Forum

Expand all | Collapse all

HR Attendance Transaction

  • 1.  HR Attendance Transaction

    GOLD CONTRIBUTOR
    Posted 22 days ago
    I have a transaction in the tatx1030 table that is set to a transaction status of processing (2 in the sql table field attrxstatus field). The batch no longer exists, so i can't go edit/void the transaction.  How can I get this transaction out of this status?

    This issue came up when we were trying to inactivate the timecode for the employees as they have left.

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: HR Attendance Transaction

    GOLD CONTRIBUTOR
    Posted 22 days ago
    A little update to this.....I looked at all the transactions in the tatx1030 table for the particular date and bachnumb of the previous transaction and 850 out of 860 transactions have a status of '2' and the other ten have a stauts of '3.'

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: HR Attendance Transaction

    GOLD CONTRIBUTOR
    Posted 21 days ago
    I also tried running the Reconcile Attendance Translations Process in our test company, but that did not do the trick.  It took about a third of the attendance transactions and pushed them into payroll transactions, when they've already been paid on these attendance transactions.  It left the other two thirds alone, but the timecode had been inactivated for the other two thirds of employees.

    ------------------------------
    Andy Berntson
    Fargo Public Schools
    Fargo ND
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: HR Attendance Transaction

    GPUG ALL STAR
    Posted 18 days ago
    Hi Andy,
    I would mark off the trx to set the ATTTRXstatus = 3 (completed) that are flagged as 2, then you should be fine.

    Thanks
    Terry
    Terry Heley | Sr. Escalation Engineer | Microsoft Dynamics
    701-492-6376 (o) | 701-412-5619 (m) | theley@microsoft.com


    ------------------------------
    Terry Heley
    HR/PR expert
    Microsoft
    West Fargo ND
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role