Browse By Tags

  • Webinar - Company Archives - Recording available

    Learn all about archives, including what they are, how to create one, and once accessed how you can use it. This webinar has now taken place but you can catch up with a recording:
  • Autoentry retain document links after Year End

    Which function of Year End clears all the Autoentry Document Links? During last years end processing all of the AE Links were removed when we archived the data set. This year we would like to retain them within the year archive. Thank you.
  • About attachment folder when archiving records to archive folder

    Let's take an example, in SEED folder, I have a Purchase Request record dated 2018. This purchase request record has two attachment in ATT folder of the SEED endpoint. I will run an archive procedure for Purchase Request with shelf life of 2 years now…
  • Free - Live Webinar - Company Archives - Recording available

    Learn about archives, how to take one and how to access and use them. This session has now taken place, but you can watch a recording:
  • Accessing Archive Data

    Good morning, I have created a Company Archive in Sage50 Accounts but the software closes each time I try to open it. Please can you help? Thanks
  • Does Sage X3 support cold storage?

    As per title, I have received an order to prepare a cold storage purely for long-term archival purpose. I am interested in how everyone deals with cold storage order. As far as I know, Sage X3 have Archive/Purge folder (which I labbed here: https…
  • Free Webinar - Company archive - Recording available

    In this session you'll learn about company archives. We'll cover what an archive is, how and when they're created, how to access one and how they can be used. Join us for a live demonstration with a chance to ask a Sage expert your questions. We've…
  • 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…
  • Transaction not viewable in Customer Ledger

    I am trying to view transaction in a customer ledger going back several years. But I am only able to see the latest transaction from 2020. There are invoices/credits posted to their account dating to previous years but on the ledger they are not visible…
  • Does archiving data at year end remove data from the live company?

    When you run your year end, it's a good idea to create an archive of your data. This makes it easy to report on previous year data, without current year postings getting in the way. A common question we're asked is whether creating an archive removes…
  • Moving a Sage X3 "Folders" file system location (update 2)

    In todays virtualised world, it should not be very often that you will run out of disk space for your Sage X3 file system, however it could be that you have your Sage X3 "Folders" directory stored on a disk volume that cannot be extended for some reason…
  • Sage X3 Support: Need to copy a X3 folder that has an archive folder ?

    Welcome to the new UK Blogs channel on Sage City. In this post, I will run through copying an X3 folder that has an associated archive folder to a new server. I had some fun working this out for a customer who was implementing a test server for the…
  • How to Archive/Delete history

    When you want to Archive/Delete history On the below field indicate the number of years after which employee history may be deleted from the system Navigate to Company Management > Company
  • Archive Login for new Users

    I have some current users that login to Sage 50 Accounts who cannot login to archives due to data being locked when archived. I have been told they can login with manager, but because of different access rights for each user this is not helpful and therefore…
  • Inactive stock records

    Hi We have a number of inactive stock records which relate to items early in the company history such as "Screw" which is now separated into different sizes ie "screw-set1/4BSFx1" I have marked all the early records that are not required as inactive…
  • I think that accounts production needs an automated back up and archive process.

    Archiving old year ends means each year end has to be manually backed up, and then deleted. This takes a long time. If Sage provided an automated system, then all of the old year ends could be backed up quickly using a small amount of people time. This…
  • Does Sage 500 have a mechanism to archive historic data that is no longer used

    Over the years of use and lots of data imported from our various sales channels, our database has grown to about 80gb in size. Maintenance on a database that big can be cumbersome when rebuilding indexes, doing backups, dbcc checks, et al . Is it…
  • ODBC Error when attempting DELETE query

    I am trying to automate archiving of the Log files generated by sage. We generate an average of 15,000 log entries a day and the LogViewer in sage is so slow it is nearly unusable after a month. I am querying the data older than seven days and then inserting…
  • Error while creation Archive Folder in V7 Patch8

    We are using SAGE X3 Version V7 and Patch 8, With in this environment i am trying to creating the Archive folder with using existing production folder. i navigate to SAGE X3 function 'CREHISTO' to create Archive folder and provided the appropriate…
  • Sage 100 Data clean up best practices

    Hello everyone, We have been using Sage 100 and it's earlier incarnations for over 20 years. Our data sets are quite large, especially sales and invoice history and inventory. What is the best practice, or what do you all do to maintain your data sets…
  • RE: Error 47 in Program POWUBC at line 2330

    After you are logged into the Support Portal (support.na.sage.com), click the following link to find your resolution in the Archive Knowledgebase: Error 47 POWUBC 2330 or Error 47 POWUBC 3020