x Want to participate? Join the group to interact
Options
  • State Not Answered
  • +1 person also asked this people also asked this
  • Replies 8 replies
  • Subscribers 121 subscribers
  • Views 479 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
47
topics
95
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
965
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
Kenny98

AR Invoice History file size limits or performance hits

Posted By

Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit.

We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually they'll be CM), which could have 3-50 detailed lines.  Or approximately 47,000 line details per month on average, based on history, which could double by end of this year.  Currently our AR Invoice History header file is about 304MB and Detail file is about 390MB in size.  I have history purged back as far as I can, 10 years.  I'll have to create several new UDF's for the detail information they want to capture, so it won't just be the standard fields in the AR Invoice History Detail file.

So my question is...What file size has anyone dealt with as far as these 2 AR history files go?  When has anyone seen a performance hit with either simple data entry, opening screens, running standard reports, running customize crystal reports, in AR, SO, IM, etc?

I don't want to say 'Yes' we can import all this detail just to hit a brick wall by year's end.

We are on Sage 100 Advanced v2022.

Thanks for anyone's input and any advice.

Parents
  • 0

    The devil is always in the details and the salesmen know how to make it sizzle.  Just ask a MAS 90 user I am working with who was convinced that Netsuite was the way forward.  18 months later and $100K down the drain, he is rethinking that decision and is seriously looking simply upgrading Sage 100.  Upgrading to Sage 100 Premium is as Kevin says, getting Premium licenses (usually NC) and migrating to the SQL database.  Your users will hardly notice the change and your original issues noted above will be resolved.  

    Now you bring up Scanco OM issues.  My first thought is does your reseller EXCEL at OM?  If not, perhaps you should find a quality OM specialist to sort through your concerns.  A good specialist makes all the difference in OM.

    Just my .02.  It will be well worth your while before throwing the baby out with the bathwater.

Reply
  • 0

    The devil is always in the details and the salesmen know how to make it sizzle.  Just ask a MAS 90 user I am working with who was convinced that Netsuite was the way forward.  18 months later and $100K down the drain, he is rethinking that decision and is seriously looking simply upgrading Sage 100.  Upgrading to Sage 100 Premium is as Kevin says, getting Premium licenses (usually NC) and migrating to the SQL database.  Your users will hardly notice the change and your original issues noted above will be resolved.  

    Now you bring up Scanco OM issues.  My first thought is does your reseller EXCEL at OM?  If not, perhaps you should find a quality OM specialist to sort through your concerns.  A good specialist makes all the difference in OM.

    Just my .02.  It will be well worth your while before throwing the baby out with the bathwater.

Children
No Data

*Community Hub is the new name for Sage City