How Reset Transaction Number to 1

How do i reset the transaction number to 1 after i have clear all the sales data using Store Operation Administrator?The Set Next Transaction Number option in Store Operation Administrator does not allow me to do that, is there anyway i could change it manually inside the database, which table in the RMS database stores the information of transaction number?

Reply to
MJay
Loading thread data ...

Hi Mjay, It normally not happen as you said I tried to "Delete the Transaction" first and then system has also reseted the Sequence No. You make sure that you are in Database Menu then click on "Delete Transactions" button

else if this won't work then you go to to sql enterprise > database > rmsdb

right click on this and open in design mode. then go to TransactionNumber Field and on the column property and Make Identity field proper to No and then save the table I mean close X button.

Re do the same thing and then this time enable the identity field to Yes. and save the table.

I use this way of work around there are scripts also which do but I don't have right now.

"MJay" wrote:

Reply to
Akber Alwani

If you absolutely must have transaction #1, you should start a new database.

Trying to delete or change the transaction table will probably not go well. Forget about it. >99% of the time modifiying/deleting the transaction table

*will* screw things up beyond repair.

Why is it so critical for the next Transaction to be Number One. Why not

1001 or 10001? This you can do with 'set next transaction number'.

Tom

Reply to
Terrible Tom

dbcc checkident ( 'item' ,reseed, 1)

Glenn Adams Tiber Creek C> How do i reset the transaction number to 1 after i have clear all the sales

Reply to
Glenn Adams [MVP - Retail Mgmt

Reply to
MJay

Reply to
MJay

Reply to
MJay

HI Mjay, Yes you can do the same thing to run this script to transaction table: dbcc checkident ( '[transaction]' ,reseed, 1)

You can run the above script to any table which has wrong identitiy seed assign, which normally not happen.

"MJay" wrote:

Reply to
Akber Alwani
Reply to
CptSoft

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.