Browse By Tags

  • Purging Remittances

    In recent experience, when purging remittances you can't actually choose a specific range of remits to purge, it just does everything that's been printed (to my knowledge). So I was hoping to purge really old remittances and ended up purging all of them…
  • Is Purging records contain serialized stock items?

    I have just run a purge in Sage 50 2023 and many of the records were not purged because the records contained Serialized Stock Items. Since we serialize stock items we sell, this means a lot of our records are affected. Is there any way that old old records…
  • How can I purge the records from the Performance Index function (AIOBENCH)

    Hopefully you all know about and use the "Performance index" (AIOBENCH) feature to monitor your system performance. (Development, Utilities, Verifications, Performance index) Whilst it is useful to be able to review the old data as a comparison to more…
  • Purging Vendors in Sage 50

    When purging vendors one of the criterions of a vendor not being purged is payments. Is payments and Bill/Pay Bills the same when purging? I know the process is different, but I am not sure if it applies as the same when purging files.
  • Purge Old Companies

    I need to purge several companies that are historic and/or were test companies. These companies do not have existing transactions. I know there were issues with the Purge functions that would allow me to do this. Are these working again in version 2019…
  • Purging records that contain serialized stock items?

    I have just run a purge in Sage 50 2023 and many of the records were not purged because the records contained Serialized Stock Items. Since we serialize stock items we sell, this means a lot of our records are affected. Is there any way that old old records…
  • Archiving & Purges

    Hello Sage City, As a Sage partner, I have heard numerous horror stories about the "PURGE" function in older v5, v6 and v7 versions of Sage X3. A customer of mine will be migrating to v12 shortly and asked about purging old data from the database…
  • How to archive and purge transactions programmatically?

    Hi all, I have check on the documentation. but there is no guide to do archive and purge transactions programmatically. What I want to do is to select specific transactions by item code, and archive & purge these transaction, and delete the item code…
  • Alert: Potential data issue when archiving or purging HISTODUD table (Open item archive)

    Update 28/02/23 : The recommendation is to run a "complete" archive (for example : PCECPT, SINVOICE, PAYMENTH, GACCENTRY, BALANCE, HISTODUD) and the behaviour seems correct in CONSBAH in SEED and HSEED folder. To be clearly documented in the near future…
  • Error in Purge

    Hi All I have error when Purge Data, may i know how to solve it? Any company or people can provide this soloution?
  • Error 20 File Non-existent when purging trace files

    Hi everyone, I met the below error when trying to purge trace files (ATRACE). Error 20 File Non-existent Error [email protected]/eputra$adx Line number 33 Could you please advise me how to fix it? Thanks !
  • Purge Taking Forever and Going Very Slow

    Hello, Long story short I am purging closed clients and it's going unbelievably slowly. I am trying to purge the database from everything from our closed clients. When I run the purge, I select "Closed" clients and nothing else, no other filters…
  • Purge Data - SO_LastPurchaseHistory & SO_ARInvoiceHistoryLink

    I am starting the process of purging data from our company. This is the guide that I'm following: www.connerash.com/.../Sage100History-HowToPurge.pdf One thing I have noticed after purging records from AR, IM, and SO, is that there are tables that are…
  • Does Purging a Matter Remove it Completely from the Database?

    When I set a client/matter as Closed and then use the Purge tool, it certainly seems like the client/matter is gone, but is it still in the database, just marked as something else. OR does it get completely removed from the database? Thanks
  • Purge Utility vs SQL Deletion: AR History

    Hello, We are looking to remove some data from the "Customer Maintenance" screen as some customers take roughly 30 seconds to load all of their history. I am specifically talking about records under tab 6 "Invoices", and tab 7 "Transactions". I am…
  • Sage 50 Quantum Purging Caused Database to Grow in Size?

    I am hoping for some insight. We have been experiencing slow downs of epic proportions within Sage 50 lately. We have data going all the way back to 2007 and our database is sitting at about 1.6 GB on a network. I decided to create a new "TEST" company…
  • Remittances - how can this section be cleared up?

    We've only recently begun using this section, but there's an option to print remittances from YEARS ago! I want to clear these from the list so it's tidier and also doesnt take a few minutes to run every time as it's searching all records. I don't…
  • Data purge function in MAS 500

    We are running MAS 500 7.60.5, we are considering to execute the house keeping job with standard purge function in different modules, SO/PO/GL/IM/AR/AP, etc., but seems there has problems in previous version, 5 years ago, refer to sage communities,…
  • Purge & Backup

    It appears to me that the size of my Timeslips backup file remains the same after purging several years of slips, clients and other items. I expected the backup file size to be reduced after purging items from the database. Is my expectation incorrect…
  • inventory items will not purge

    I have 1700+ inventory items that will not purge dating to 2005. I have checked many of them and it is not because there are transactions past the thru-date. I have read through all other related questions here and can confirm that these items DO meet…
  • Can't purge closed PO - MAS says there are receipt of goods pending

    We have a few old PO's that aren't purging. They are closed, but if you access them in PO Entry MAS says "A receipt of goods is currently referencing this purchase order." This message is in error. How do we clear this message, which is appearing in…
  • RE: Remove old accounts from Balance Sheet

    Sounds like you may want to check the purge log to see if the accounts actually purged. Once an account is truly purged, it no longer shows in the program. Any record with balance will not be purged.
  • How to close journal entries so I can purge?

    Hello! When I run purge, I see lots and lots of records under TRANSACTIONS AND MAINTENANCE RECORDS NOT PURGED most or all of these records seem involve some journals: Sales Journal Cash Receipts Journal Quotes Journal ... Some of the Reasons: Reason:…
  • Is it Year End time? Let’s talk about purging your database.

    From the time you started using Sage 50 - U.S. Edition you have been busy inputting new records into the database; from customer invoices and receipts, vendor bills and checks, to time tickets and payroll checks. You may have noticed a decline in the…
  • How to reduce Database size in Quantum?

    We just purged our Sage 50 Quantum database and it is still 1.5 Gigs. The Sage support reps say this is too big. The big records are: Audit Trail 55MB Customer 21 MB Event Log 56 MB Inventory Tag (Costing) 367 MB Journal Header 132 MB Journal…