Sage 100

MAS90 4.40.0.7. Trying to reinitialize AP_CheckDetail but it hangs and never finishes and I have to kill the task. Same thing when trying to manually reinitialize, it creates the table but doesn't finish. I can take the table to my side and it is successful. I can put one of mine on client side and still hangs/never finishes. No customizations, vanilla system. Other files reinitialize just fine (AP_CheckHeader). Tried creating a UDF on AP_CheckDetail to force DD to compile but didn't help. How can I fix this issue?

Can you rename AP_CheckDetail and then manually reinitialize it?

I did that, it creates the new table but the process doesn't finish (coming back to a cleared screen waiting for the next file to manually reinitialize) and I have to kill the task.

Can you copy a AP_CheckDetail file from another company where you know the file is empty?

I can do that workaround, but would rather resolve the issue so it doesn't come back to haunt me in the future.

Verified Full Control permissions?

I can reinitialize other files so permissions aren't an issue.

Why don't you put a clean AP_CheckDetail out there and try to reinitialize it. I had something similar happen with Inventory Transaction Details and this resolved it. Don't know why deleting and manually reinitializing wouldn't work but it just wouldn't. So this is what I did.

Did that too, brought one from my side and put it in on client side, still hung. Brought their file to my side and was able to successfully reinitialize it so it has to be something with the process rather than the file.

Reinitialize on AP_CheckDetail as a secondary routine clears the PaidToday flag in AP_OpenInvoice so either it's taking a long to scan through AP_OpenInvoice or you need to rebuild that methinks.

The AmountAppliedToday flag from AP_JobDistributionDetail as well if J/C is involved

Did the user reboot the WS? I had issues with PO trying to manually reinitialize one file, and was able to reinitialize others once they rebooted I was able to manually reinitialize the file.

Alnoor, you win and you are my hero tonight! Thank you very much for responding and all the other responses too. I really appreciate them. AP_OpenInvoice had 272,000 records, JC is involved too. Rebuilt both files and just let the reinitialize sit and it finally finished after 20 mn. Now doing it in the live company. Thanks again!