Hello all,
(because of powers beyond MY control, we're between vendors/partners at the moment and I'm reading/getting ambiguous info online so far, I'll post the same question on two other NAV forums).
We have what I call a non-traditional configuration. Originally 2013 CRM and NAV 2014 where both on premise. We moved to D365 CRM and Business Central (v14 Spring release?) on-premise as we have custom code that is/wasn't ready for Business Central online.
Our sales guys (Enterprise Licensed) need a report built that will draw on data (like a stock level) from NAV BC. They won't be updating/writing to the NAV BC instance, just reading levels updated by the Finance team.
Do they (D-CRM-365) require licenses on the NAV BC (or other methods below?) server to access this data in the following methods that I see for building said report:
- Integrated report to D-CRM-365
- Custom PowerApp in the D-CRM-365 Environment
- Power BI (we have Premium Per User and Pro users not integrated with NAV BC, for other offerings already and would rather not have to get sales guys licenses for 1 report)
- SSRS on the On-Premise SQL server used for NAV BC (we have them licensed as SQL users here already)
- Excel (we're M/O365)
- Any other suggested method(s)?
Thanks all.
