Sage 100

MAS 200 4.3.18 - history invoices (AR) taking several minutes to pull up. Not the lookup, but once you select an invoice from the lookup or from within customer maintenance. It is not all invoices, but some of them, and is repeatable for the invoices where it is a problem. Keys & sorts have been rebuilt, drive defragged. A recent virus outbreak (now cleaned up) appears to have aggravated the problem, but it still exists on the data from 2 months ago in a separate test environment. Any ideas??

Additional detail: has DSD multicurrency and IIG commission by customer

Is the client using Kaspersky AV by any chance? I have seen this with clients using Kaspersky.

Have you run the script to replace embedded IO's? It won't hurt. Search Sage KB with: 500846.html or How to replace embedded io.

Thank you for the suggestions. Unfortunately: Embedded ios script no effect. Turning off AV no effect.

I would also check to see if there are renamed .M4T files in the company data set or another installation of MAS90 directory seen in the shared path. Files should be renamed by changing the extension value (m4t -> old) and there should not be any other instances of MAS within the shared path. If found remove them, run the Embedded IO replacement script and then rebuild sorts. After that it's a direct review of the history data file records for short records and/or corrupt field(s). Always make sure that there is a valid and recent backup before running any of the repair utilities -i.e. Rebuild Key Files.

Copied the data over to a new company code and the delay is gone...

So, are you going to copy it back? :)

That is one of the ways support tests for corruption. If you copy it back without generating new data files you are likely to still see the issue while if you remove the company AR data, deactivate AR, Accept the change,and then reactivate the AR module the system should create new data files to copy back in to. This significantly reduces (eliminate) chances on issue reocurring. (that's my 5 cents worth, raised the value do to increase in lving costs):)

I totally agree, I wouldn't just copy it back either :) That does bring up a question I don't have the answer for. When you copy a company, does the code copy files or does it copy records into existing files? What prompted the silly question was dealing with corrupt Custom Financials in the 80s and 90s.

Copies the file content. I don't know if that applies to Custom Financials or versions lower than 3.71. My experience is limited in those areas.

Appears to be a Paperless broken link for Invoices - turn off Paperless and everything works. This was in 4.3. I didn't get the long-delay on un-linked 5.0.2 drill-downs. Don't know why the invoice drill-down would be accessing paperless.

Also - when you copy a company - the system doesn't copy the lock-files, and those had to be cleared manually also.