When using the Copy feature in Company Maintenance, what exactly does Business Insights copy? It takes FOREVER for several of our clients. (Forever can mean hours.) Can we uncheck that module? If so, what do we lose?
Thanks
Sue
I have unchecked it and it has still taken FOREVER to copy the company.
This is a problem for me, too. Running version 6.10 this takes an hour.
-Andy
I run into this sometimes with some clients, even when running the copy directly on the server. As a test you can manually copy the MAS_xxx company folder via Windows File Explorer to see if that’s slow as well.
It appears the number of credit cards on-file may be the cause. I actually just copied a company (in v2014) that had 2,803 on-file. Took hours!
Copy Company Feature hangs or takes longer than normal after upgrade to a 5.x version |
Products |
Sage 100 |
Description |
Cause |
Credit Cards being committed to the vault for the Copy company
Resolution |
When a company is copied in Version 5.0 and above, the Credit cards for that company (in AR_CustomerCreditCard.M4T) must be committed to the vault for the new company. The process to encrypt the cards can take 5-10 seconds per card. This means for a company that for a company with 500 cards, it could take 60-80 minutes complete the Company Copy
Possible Resolution:
Need help?
|
Related resources |
How to Use the Clear Credit Card Information Utility
ID:69139Last modified:6-5-2020
Just did a copy test with that same company with 2,800 cc's but not including A/R or S/O; took 10 minutes.
We have a customer, v2016, where it's taking upwards of 25-30 minutes or longer to copy a company with only 500 credit cards. Yes, the company copy process does appear to get stalled on Business Insights, or even some other module, but it's not actually stuck on that process. As Zip mentions, it's Sage is actually in the process of copying company credit cards to the new company. I don't think I'm going to say this correctly, but there's an issue with the Sage code that doesn't switch the task from Business Insights, or the module it appears to be stuck on, to the "Copying Credit Cards" task. it just hangs there until the copy is completed and disappears.
With the customer, I have even run the clear CC Info utility up until the month prior to the current month and it still took a considerable amount of time. I zipped up their MAS90 folder and brought it to my own workstation, thinking internet speeds may be the issue (it wasn't). I tried installing the latest update for 2016, tried a few other things. The final test I made was to test upgrade their data to v2019. I installed v2019.3, migrated the data, and started the company copy process. What was taking anywhere between 25-30 min at a minimum on v2016 now took 10 minutes on v2019.
The customer first reported this slowness back in December 2018. My theory is that this may have been around the time Paya bought SPS and some of the switches were being made from SPS to Paya. Is it possible that the older versions of Sage, say 2013-2016/2017 have code that look to SPS "links" in order to process/store CC info, and because of that, has Paya put in redirects on those links, which of course can cause the process to take extra time? Since Paya took over native CC processing within Sage, has Sage put in a direct route/link to Paya's vault that speeds up the process? Again, just my theory, and have no idea how I could prove that. it's also possible that newer versions of Sage have other related improvements to the company copy process. I'm sure a developer could look into this and provide more input given they have the free time to do so.
If you are just copying a test company, uninstall Paya before you do the copy. There will be an error, but it might work otherwise... then reinstall Paya for normal use.
The only thing I don’t like, Kevin with that error is that I feel like the copy may not have completed properly. So I’ve actually made it a habit of installing Paya on the server before making copies. But I suppose it should be somewhat easy to confirm what actually copied, plus to decrease the copying time dramatically would be nice.
I agree that errors make me wary, but for a test company it shouldn't matter much.
*Community Hub is the new name for Sage City