×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

SBT 5.0 we have so many records in the tables, how do we purge some records

SBT 5.0 we have so many records in the tables, how do we purge some records

SBT 5.0 we have so many records in the tables, how do we purge some records

(OP)
Hi Guys,
We have a lot records for years in all the tables that are part of SBT PRO 5.0 so actually we don't need to have records in the tables from year 2008 and before, where in SBT we can get rid records we don't need anymore so we can delete them and pack ?

Thanks in advance for your help
Ernesto

RE: SBT 5.0 we have so many records in the tables, how do we purge some records

At the time of Period Close for each module, you have the ability to delete records.
Delete Trans History ( Transactions ). Be careful when you enter the cutoff date. Password is "destruct". We leave at least 18 months worth of transactions.

Edgar
Integrated Bar Code Systems, Inc.

RE: SBT 5.0 we have so many records in the tables, how do we purge some records

(OP)
Thanks a lot Edgar

RE: SBT 5.0 we have so many records in the tables, how do we purge some records

You can move and then purge some system records anytime in the System Manager module.

Matthew Lefkowitz
Lefkowitz Systems, Inc.
www.lefkowitzsys.com

RE: SBT 5.0 we have so many records in the tables, how do we purge some records

(OP)
Hi Matthew ,
sorry, but What do you mean with move ?
Thanks a lot
Ernesto

RE: SBT 5.0 we have so many records in the tables, how do we purge some records

My mistake. The ability to move first and purge later was added in newer versions of Pro. But in Pro 5.0 you have the option to purge various system data tables in the SM module. Go to Transactions -> Purge. The Activity and Change Log is the one that usually has a lot of useless data. The error log can also be quite large.

Matthew Lefkowitz
Lefkowitz Systems, Inc.
www.lefkowitzsys.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close