I ran into this with a customer who was upgrading from legacy Timecard to Time Track. I believe their issue was that they never imported to Payroll but they did import to Job Cost. This created a large file that stayed around until we cleared out the items which were never going to purge to history.
One issue that caused this is old Timecard had an option to purge whereas initially Time Track had no such purge. Once you upgrade/migrated to 2.0 and the user started to enter transactions there was no easy way to purge out this extra history.
As I recall there were two solutions to this.
1. Sage
suggested this workaround which is what I used without problem ( I suggest doing this first in a TST company)
From the prior thread referenced above:
Update: I went into this customer data and made a TST company. Within the TST company I turned off the integration between Payroll and Time Track (which they don't pass data between) and was immediately prompted ""When you click Accept, all Time Track entries that either have a job cost status of updated or do not have a job number will be transferred to Time Track History"" then it asks if I want to continue. I answer yes and the system appears to transfer the very old data to history. In this specific user case they were NOT sending data to payroll and only sent the data to job cost. So there was never a flag set showing that payroll data was transferred. I think without turning off payroll integration that this old data may have stayed around and not transferred to history. Note: The new 2018 Time Track apparently only copies data to history as part of the posting process and only when any integrated modules (JC / PR) indicate that the data was transferred. This is in contract to the prior Timecard where there was a manual utility to perform this move to history. Ultimately, the business issue is that when a Sage 100 2018 user of Timecard does NOT transfer timecard data to history BEFORE migrating to 2018 then there is no separate menu option to do so. This can mean that entering time is potentially be very slow (depending upon the amount of history) as Sage goes through all the old data prior to displaying the Time Track data entry screen for a specific user.
2. Subsequent to the release of Time Track Sage created a utility which can purge details records which I think both Michelle and Beth are alluding to - one URL with info in the KB is
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=91440&sliceId=1&docLink=true&languageId=&isDocLink=true¤tmsID=MS_Customer&cmd=&openedFromDocument=true&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990
------------------------------