|
Posted by Akber Alwani on January 8, 2008, 3:39 am
Please log in for more thread options
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:
> 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
>
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap