Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. An incorrect RECON batch is created in Payroll when you reconcile attendance transactions in Human Resources in Microsoft Dynamics GP

An incorrect RECON batch is created in Payroll when you reconcile attendance transactions in Human Resources in Microsoft Dynamics GP

Symptoms

When you reconcile attendance transactions in Human Resources in Microsoft Dynamics GP, an incorrect RECON batch is created in Payroll in Microsoft Dynamics GP. The batch includes transactions that were created in Human Resources in a prior pay period.

↑ Back to the top

Cause

This problem occurs because the reconcile process incorrectly includes human resource transactions from the TATX1030 table that have an ATTTRXSTATUS value of 1 and of 3.

↑ Back to the top

Resolution

To resolve this problem, obtain the latest service pack for Microsoft Dynamics GP 9.0. For more information, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer.

Partners
https://mbs.microsoft.com/partnersource/products/GreatPlains/downloads/servicepack
Customers
https://mbs.microsoft.com/customersource/support/downloads/servicepacks

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft Dynamics GP 9.0 Service Pack 1.

↑ Back to the top

More Information

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

To remove the incorrect RECON batch, run the following script against your company database.

Note To run the following script, use SQL Query Analyzer in Microsoft SQL Server. If you are using Microsoft SQL Server Desktop Engine (also known as MSDE 2000), use the Support Administrator Console.
DELETE FROM UPR10301 WHERE BACHNUMB ='RECON'
DELETE FROM UPR10302 WHERE BACHNUMB ='RECON'

↑ Back to the top

Keywords: kbnosurvey, kbexpertiseinter, kbtshoot, kbmbspartner, kbmbsmigrate, kbprb, kb

↑ Back to the top

Article Info
Article ID : 919346
Revision : 1
Created on : 3/25/2017
Published on : 1/4/2015
Exists online : False
Views : 99