Can you duplicate primary key records across organizations?
One of the questions I am frequently asked when I upload data into a new Infor EAM environment is; “Can we use the same part, asset, cost codes if they are in different organizations?”
Let me start out with some basic, but important information. When configuring a fresh EAM Environment, we go through several settings (install parameters and organization options). Then one of the big decisions need to be made about whether we want data to be held in together, in a common org, or separately by activating Multi-Organization settings. Most companies with several facilities will choose to activate multi-org on many items.
But then the question is asked – “I have this asset here but also at a different location, can I use the same asset code?” The initial answer might be, “No, you can’t. This is because EAM does not allow you to duplicate codes at all in the application”. But I would be completely wrong! Even with Multi-Org activated, EAM does allow you to duplicate a handful of key code fields.
These are some key record fields you can duplicate across organizations:
These are some key record fields you cannot duplicate across organizations:
- Cost Codes
- PM Schedules
- Task Plans
Now take a second and ask, “Why is this allowed? What benefit(s) does it offer?”
This allows multiple organizations that may have the same equipment, parts, suppliers, etc. to keep their unique information for that equipment, part, or supplier in EAM. When it comes to the list of fields you cannot duplicate, this is because these are items that should be either unique for each organization or shared between all organizations. In some cases, Parts is kept common between organizations so that all organizations are using the same part numbers but can enter their own unique supplier information.
This is a topic that we discuss thoroughly with customers that will have multiple facilities sharing EAM so we can ensure that EAM is customized and meeting the demands of your specific business. If you have any further questions regarding this topic, please leave a comment or reach out to us by clicking here. We are always happy to help!