HQ/Store date mismatch

We have never found a solution for changing all the sales data to the correct date. If someone has a solution, I would love to see it. Another thing we found when stores set future dates is they will poll at sales data between 4/25/2006 including the journals from that date forward until you reach 5/25/2006. In your case they will only poll one months worth of data. The timestamp at HQ doesn't reset until you reach 5/25/2005. We had stores that were taking 3+ hours to do a poll on dial-up internet. Microsoft spent 2 months working on a solution with us and here is the simple query that reset the timestamp at HQ.

--Delete TimeStamp

SELECT * FROM TimeStampLog WHERE ServerTime > getdate() ORDER BY ServerTime DESC

--If the above query results in any rows, please save the results and run the following query:

delete from timestamplog where ServerTime > getdate()

--This will remove those records so that they will not be considered when deciding which --timestamp to use for data uploads.

--Then, run a 401 after deleting these entries to verify that large recordsets are not being --uploaded

ScottFC wrote: