Sage 100

 View Only

  • 1.  Need to move a MAS_XXX to another install due to purchase.

    Posted 02-07-2020 11:30
    Hi
    Customer is on 2019.  Customer A owns Sage and company code MAS_xxx.  Customer A is no longer going to be involved in xxx so Customer B bought their own version of Sage and now is trying to move just MAS_XXX to their install.  Getting the Encryption Key is invalid.  I can't migrate as I don't want all Customer A's setup/settings.  
    How do I move MAS_XXX to Customer B's environment?
    Both are on 2019.
    Thanks
    N

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------


  • 2.  RE: Need to move a MAS_XXX to another install due to purchase.

    Posted 02-07-2020 11:46
    I have a theory, but it is completely untested:
    • In the admin console, there is an option to set an encryption key.  Create a copy of the source system's MAS90 folder, log in to the copy and type in a new key.
    • Assuming that doesn't break the source data (?!?), set the same key in the destination system.
    • Copy...

    If that is not what this feature is for, I have no ideas.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Need to move a MAS_XXX to another install due to purchase.

    Posted 02-07-2020 11:54

    Or use the destination key in the source data copy.

     

    Regards,

     

    Bob Sosbee

    Accounting Systems, Inc.

    810 Dutch Square Blvd Ste 103 | Columbia, SC 29210

    Ph: 803.252.6154x245  | Fx: 803.753.9818 | Toll free: 855.383.6154

    E-Mail: bsosbee@asifocus.com

    Web: www.asifocus.com

    Follow Us: Twitter | Facebook | LinkedIn

     

    Confidentiality Notice: This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this email in error, please reply immediately and delete the message.

     



    ------Original Message------

    I have a theory, but it is completely untested:
    • In the admin console, there is an option to set an encryption key.  Create a copy of the source system's MAS90 folder, log in to the copy and type in a new key.
    • Assuming that doesn't break the source data (?!?), set the same key in the destination system.
    • Copy...

    If that is not what this feature is for, I have no ideas.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------


  • 4.  RE: Need to move a MAS_XXX to another install due to purchase.

    Posted 02-07-2020 12:19
    @Bob Sosbee can you elaborate what you mean by 'use destination key in the source' ?

    Nancy's issue is one of the scenarios I have been dreading since this was introduced.

    The portability of Sage 100 and the data has been one of my favorite things about this product... 

    I would love to see a way to restore this portability for things like this (and simply moving demo data around in your own lab!)


    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------

    Original Message


  • 5.  RE: Need to move a MAS_XXX to another install due to purchase.

    Posted 02-07-2020 13:50

    Howdy, Eric!

     

    Sure.

     

    Using DFDM, go into sy_company,  find the AES Encryption key for one of the current companies in the destination system.    I never bother with the "Change encryption keys" program, I just create the new company in the destination system, copy in the data, then grab the encryption key from a good company in and paste it into the AES encryption field of the new company.  Comes right up.

     

    For version 610 (and maybe 600), you will also need to go into the G/L options for a known good company and do the same for data encryption test.  That handles the PII stuff.  I think Payroll is like G/L, but I haven't fiddled with it.

     

    Had to work this out so our consultants can grab customer data for reports and such, or so we can test weird issues customers are reporting.

     

    Regards,

     

    Bob Sosbee

    Accounting Systems, Inc.

    810 Dutch Square Blvd Ste 103 | Columbia, SC 29210

    Ph: 803.252.6154x245  | Fx: 803.753.9818 | Toll free: 855.383.6154

    E-Mail: bsosbee@asifocus.com

    Web: www.asifocus.com

    Follow Us: Twitter | Facebook | LinkedIn

     

    Confidentiality Notice: This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this email in error, please reply immediately and delete the message.

     



    ------Original Message------

    @Bob Sosbee can you elaborate what you mean by 'use destination key in the source' ?

    Nancy's issue is one of the scenarios I have been dreading since this was introduced.

    The portability of Sage 100 and the data has been one of my favorite things about this product... 

    I would love to see a way to restore this portability for things like this (and simply moving demo data around in your own lab!)


    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------


  • 6.  RE: Need to move a MAS_XXX to another install due to purchase.

    Posted 02-07-2020 15:40
    Awesome. Thanks Bob!

    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------

    Original Message


  • 7.  RE: Need to move a MAS_XXX to another install due to purchase.

    Posted 02-07-2020 15:52
    Thanks Bob, I'll give this a shot!
    You guys all rock!
    N​

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------

    Original Message


  • 8.  RE: Need to move a MAS_XXX to another install due to purchase.

    Posted 02-07-2020 16:28
    This is excellent to know.  Thanks for sharing the insights Bob!

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content