AR Invoice History Inquiry Launched from Customer Maintenance Slow

Question

Using 2019 Premium Product Update 2. Can't seem to find a pattern, but sometimes when drilling down to a historical invoice from Customer Maintenance, it takes a considerable amount of time for the historical invoice to appear. I've replicated the issue on both client workstations and Sage application server. Just curious if anyone else has experienced and/or found a resolution to it? (KB article 38605, which I believe references the same issue, can only offer 'Pause before opening another invoice' as a resolution, but that doesn't seem to work 100% either)

b.mauck · Accepted Answer

Hey guys, so through some testing we were able to figure out that it was only happening with invoices that were printed in our previous version of Sage. The links to the paperless office forms for those invoices were broken, and it was taking Sage a long time to, I guess, search for them. We were able to repair those links by going to Link Maintenance Utility in Library Master. Select the module (we use S/O for our billing), hit refresh, and allow it time to populate all of the documents. It will list all broken links in red. Highlight the section that you want to relink to your new paperless folder by copying and pasting the new file path. 
 Justin, hopefully this is the same issue you're having so you can fix it! If you haven't changed where your paperless forms are stored, then this might not be the solution for you. 
 Just tested some of the invoices and they are now opening immediately.

David Speck · Answer

Any chance you have some records in the AR History tables that have blank values in any of the key fields? 
 I think i recall seeing other posts where having some bad records in the primary table causes a considerable delay when using the record navigation buttons or the lookups.

Sage 100

AR Invoice History Inquiry Launched from Customer Maintenance Slow

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING