Skip to Main Content
Sage 200 UKI Ideas Portal
Status Idea Accepted - Gauging Support
Categories Project Accounting
Created by Richard Cunningham
Created on Sep 11, 2018

Create separate database tables for archived Projects.

I have a customer who has an issue displaying all of their 100K+ Projects in the list view. They spent some considerable time archiving them so that only 1000 of them remain. However, the issue still occurs. This is logged as an issue with Sage. However, I found that when archiving a project in Project Accounting, the project doesn't get moved off to an archive table. Therefore, the 100K+ records still exist in the live projects item table. To help with system performance etc., I'd like it be considered that separate tables are introduced to home archived projects.

  • +1