We recently moved one of our Product lines to its own company in on Prem Epicor. we had an external datasource owned by the original company that connects to our PLM via SQL connection to get BOM data. While in the new company and I perform a Test connection it works fine. I dont see an option like in BAQs and BPMs for sharing, does that mean its shared across both companies?
We are getting some errors in the function so Im trying to rule out some things.
System.NullReferenceException: Object reference not set to an instance of an object.
Did some quick testing and it looks like External Datasource Types and External Datasources are, by default, shared across companies. but they are only editable is the ‘owning company’ which is a visible field on those screens. I can see both entities from all of my companies and access them accordingly.
External BAQs have the ‘share’ features, but also look to be company specific in their usage of External Datasources. I’ve only got one set of datasources and queries (in one company) but in another company, one query works without specifying a local datasource, but another query does not work. This may or may not be part of the issue.
However, you then mention ‘function’ - those are different. the library has to have the appropriate company level access and might need to be written for multi-company (company aware code rather than assuming the default/single company it was before).
yeah we duplicated the function with a new name and pointed it to a new UD table to keep everything separate. So each company has its own function. Seems like I may need to duplicate the external datasource too.
we are using the external datasource to pull the BOM data from our PLM system, it writes to a UD table then another function process the data into epicor Part Rev and ECO.
So it appears the datasource is shared, but the BAQ was pointing to the wrong table in the PLM Sql server. So I just had to copy the external BAQ and point to the correct table. Both using the same External Data source for the connection.