Copy Company - Business Insights

SUGGESTED

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

  • 0

    I have unchecked it and it has still taken FOREVER to copy the company.

  • 0

    This is a problem for me, too.  Running version 6.10 this takes an hour.

    -Andy

  • 0

    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. 

  • 0
    SUGGESTED

    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!

    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=69139&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=5281&cmd=displayKC&dialogID=212309&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl&openedFromSearchResults=true

    Copy Company Feature hangs or takes longer than normal after upgrade to a 5.x version

    Products
    Sage 100

    Description
    • Copy Company Feature hangs or takes longer than normal after upgrade to a 5.x version
    • Copy Company feature slow
    • It takes a long time to make a copy company
    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:

    • Use 'Clear Credit Card Information Utility' to delete expired Credit Cards (see Related Resources section below)



    Need help?
    Chat with support

    Related resources

    How to Use the Clear Credit Card Information Utility


    ID:69139 Last modified:6-5-2020  

  • 0

    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.

  • 0

    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.

  • +1 in reply to zip
    SUGGESTED

    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.

  • 0 in reply to Kevin M

    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. 

  • 0 in reply to zip

    I agree that errors make me wary, but for a test company it shouldn't matter much.