1. Home
  2. Point-Of-Sale Software
  3. how to remove all old transaction from HQ Database?

how to remove all old transaction from HQ Database?

I deleted the trasaction from a store (store administrator -> database-

delete transaction)

and now i want to delete it from the HQ. How can i do that ?

I tried to create "style:401 request data upload" worksheet and setting the effictive date to an old date. as i read and quote from the manual: "Before uploading data, any transactions in the Headquarters database that were previously uploaded for the same time period are deleted. This ensures that the Headquarters database will not receive duplicate records even if the same data upload worksheet upload is executed more than once."

but it didn't have any effect. what best way to remove this data?

Ramy

Reply to
Ramy0101
Loading thread data ...

Ramy -

If you really want to delete your trxs from HQ and not preserve the data (not really recommended, possibly why there are no post backs yet):

You can execute the same selective delete queries you used on SO in HQ - just make sure you run selects for the trxs you are going to remove - maybe backup this info by exporting and filing away - then Backup your db - and execute your delete statements.

Good luck.

Reply to
jocelynp

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.