Fixing the incorrect date on Master Register

Hello,

We had one store get their timing off on 12/26/07 to 12/27/07, where the time on the master register was change to 1/11/2008 to 1/12/2008. This data has not been pickup by the RMS HQ Server since their date were off for

12/26/07 to 12/27/07. Our accounting department is needed this data to close out for the year.

I have pickup an backup copy of the database and place it on our LAB store setup, where we run several queries changing the date back to 12/26/07 to

12/27/07. When we look at the batches in the Journal all the transactions are showing the correct date now, but the X, Z, ZZ reports still show the 1/11/08 to 1/12/08 date as when they were created. We think these are created by the time stamp and can't be change.

The data poll fine over to the Test RMS HQ Server and the data can be query for the lost data on the Test RMS HQ Server. We are looking to run these queries at the store database then polling to the Real RMS HQ Server.

Has anyone else ran into this problem before? How did you correct it on your side? Did you do it the same way we did in our test lab?

We need to do this before the store has real sales on the 1/11/08 and 1/12/08.

Ed

Reply to
Ed
Loading thread data ...

hi ed the z zz is not becuase of time stamp but it is because of the bitmap saved in journal table. please look the journal table and change just the date but you can't do anything with bitmap.

Akber

"Ed" wrote:

Reply to
Akber Alwani

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.