Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Business Central updates!Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features.
Download overview guide | Watch Business Central video
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
If anyone had experience with Jet Reports with connection to MS dynamics 365 BC or Navision:
Can Jet Reports which is connected to Nav or BC extract all information from the system - for example, can Jet reports extract data from BC/ Nav which is not stored in tables in the system but is in objects?
Thank you a lot,
I do not have much experience in Jet reports but I know that Jet reports can extract and use data from NAV/BC using different ways i.e. through DB(SQL) if On-Prem, Web Services etc. All of the information is stored in tables.
I do not understand other part of query, which data you want to extract other than table data.
It works best with data from tables. It does have a function where it can use a codeunit which may send back more arbitrary information. If you require the ability to access system/virtual tables then Jet Reports is not the appropriate choice.
Do you have an idea of what you want to extract object wise?
Dear Josh, Thank you so much for your answer.
To be more specific, my questions are:
-Is it possible to use OData url (page from BC) as a source for the reports?
- Is it possible to run functions from BC (that are stored inside of BC objects, like Codeunit) with some parameters and use the result, that might be returned, in report building?
Dear Bilal, thank you for responding))
I am using Jet reports with regards to financial data - honestly I'm currently new to Jet. Started with report builder tool, but not all tables are there so i thought if there is any other way to extract data which are not stored in template tables or are stored for example as codeunits?
Given BC uses web services for Jet Reports (if SaaS) further pages or queries aren’t needed. The wizard based report creations methods are ok but you need to learn the long hand method to get the real benefit from the product. I would start by getting the example reports from the website. Seeing how the reports have been built helps but no substitute for the training to do it yourself.
This link mentions a possible use case for the codeunit function: support.jetglobal.com/.../115008505868-NP-Codeunit-
Dear Josh, thank you so much. Much appreciated!
I work with the Jet team at insightsoftware and wanted to add a quick note on top of the great feedback you've already got from the community. As Josh said, you'll want to use the NP function to extract that detail out of BC/NAV. Here are a couple articles on that:
The Report wizard and table builder functions are good for quick extracts and ad-hoc, but there are other functions like the NL and NP that will give you more granularity in how you want to pull data and structure your reports.
Hope this helps,
Dear Aaron, thank you so much for your advices and all provided sources. Much appreciated!
Business Applications communities