Hello,
I am actually working on creating dashboards using Power BI and the data from LS Retail,
on the CRONUS database I am looking for pages containing compony names : CRONUS Retail East, CRONUS Retail North, CRONUS Retail South ..
Do you know where to find it ?
Thank you
*This post is locked for comments
The company names are stored in a table called Company. Once you connect to your SQL Server database then you can use a simple query like:
SELECT *
FROM Company
The company names are also used as prefixes for the table names. One database can have many NAV companies. The different companies in the same database will share some tables, however they will have their own set of tables too for their own data where the name of each table has the company name prefixed in the tablename - such as:
[companyname1$Sales Invoice Header]
[companyname2$Sales Invoice Header]
[companyname3$Sales Invoice Header]
I am not aware of a page with the company names, but they do exist in the "Company" table.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
