Our company is primarily project based and thus there is a need for the different project managers to view their expenses in an easy way for each project. We have build some Excel-files that pull data via OData-connection and makes it presentable for the project managers in table form - one row for each entry. The file works really well, although OData-updating is not always working properly. A great improvement to these files would be, if it would be possible to include links in the data-tables, that open the respective entries in Business Central. I'm referring to the link that can be copied, if an entry is to be shared (/copy link/). Hope that makes sense. Any chance that this is possible, i.e. to find a data table with a link for each Business Central entry? I've looked through many data tables in web services but haven't been able to find it - primarily because the IT-terms that are used are confusing to a person without an IT-background.
Example: Lets say I pulled a table with 100 rows, each row representing an entry (expense/income) in Business Central. There are various columns with information like /Amount/, /Date of entry/, /VAT/, /Name of customer/ etc. I would like to have another row with the direct link/URL that opens the specific entry in Business Central, so that our project managers just need to click on the link to open the respective entry in Business Central
Thanks for your help