Hello Folks
I would appreciate some ideas about my query below please.
In an environment of BC in the cloud, we will have multiple separate companies. In order to manage uniformity of set-ups and masterfiles, I would like to extract data across them all in a single refreshable view. Having come from a Great Plains environment, we achieved this with SQL Views or Stored Procedures in combiantion with the Excel query functionality. This enabled us to manage multiple companies with a simple 'refresh' click. We then filtered by company database as needed. We had a spreadsheet per table e.g. Customer masterfile, Vat setups or COA, etc
To be clear, I am not expecting to upload data back into BC - I just want to extract data preferably to Excel as it is the most practical tool to work with to manage data like this.
I understand that customisation would be needed to do this for BC in the clould. What I'd like to know is if someone has done this already and how they approached this please.
Your time in replying to this is appreciated.
Thank you
