Here at MADIC dynamics we will be presenting a Knowledge Hub Webinar at 1400 UK time on Tuesday next week.
Learn how to use Jet Reports to create a multicompany report from Microsoft Dynamics 365 Business Central. This session will cover the steps to consolidate data from multiple companies into a single report.
The webinar is open to everyone who wants to sign up and join:
|
No sep-2024 events found. |
While implementing Microsoft Dynamics 365 Business Central recently for a client, we also implemented Jet Reports. After installing the extension in Business Central, I created a data source and tried to log in, but received this error message:
Jet reports
Sorry, but we're having trouble with signing you in.
AADSTS90099: The application '~~~~~~~' (Jet Reports) has not been authorised in the tenant '~~~~~~~'. Applications must be authorised to access the customer tenant before partner delegated administrators can use them.
It’s actually an obvious one which I should have remembered; the first sign into the data source is the one which grants permissions to sign in and so needs to be done by a Microsoft 365 administrator for the Business Central tenant.
As the Business Central partner, this was not me. After co-ordinating with the client and their Microsoft 365 partner, we got an administrator to sign into the data source for the first time, granting permissions as they did so, after which I was able to confirm the data source worked and giving users at the client access.
I have a new book available now called Jet Reports with Microsoft Dynamics 365 Business Central; this book is aimed at end-users or consultants looking to use Jet Reports with Microsoft Dynamics 365 Business Central for financial and/or operational reporting.
The book covers the basics of installing and configuring Jet Reports as well as how to design and build reports using the Excel Add-in, before moving on to step-by-step guides on creating six different types of report and closing with a look at the report building tools, Jet Hub and report distribution.
The book is available as an eBook direct from my azurecurve Publishing site (always with a discount of $5, but with an additional discount of 20% until end of April using voucher code EASTER2024) or from Amazon:
The book is structured into these chapters:
If you buy this or any other ebook from me directly, the coupon code EASTER2024 will get you 20% off (until the end of April 2024).
I have a new book available now called Jet Reports with Microsoft Dynamics GP; this book is aimed at end-users or consultants looking to use Jet Reports with Microsoft Dynamics GP for financial and/or operational reporting.
The book covers the basics of installing and configuring Jet Reports as well as how to design and build reports using the Excel Add-in, before moving on to step-by-step guides on creating six different types of report and closing with a look at the report building tools and Jet Hub.
The book is available as an eBook direct from my azurecurve Publishing site or from Amazon (for $5 more):
If you buy this or any other ebook from me directly, the coupon code EASTER2024 will get you 20% off the price.
Every month, on the third Tuesday, at MADIC dynamics we will be presenting a Knowledge Hub Webinar on Microsoft Dynamics 365 Business Central and related products; I will be presenting some of the webinars, but other consultants will be getting involved as well, so there will be a variety of presenters through time.
We aim to have the next three monthly Knowledge Hub Webinars scheduled and details of them available. The next three webinars, starting next month, are:
|
No april-2024 events found. |
|
No may-2024 events found. |
|
No june-2024 events found. |
While working on a Jet Report for a client recently, working with data from Microsoft Dynamics 365 Business Central, I had need to return the output of an NL Filter into another function which required a string rather than a list, which meant that I couldn’t use the NL Filter directly.
Fortunately, there is a What in the NP Jet function which allows you to exactly this.
My NL Filter was in cell D4 which I can reference in the Array field of the NP function; the third field to set is the Join String which is the character which will separate the joined items from the list; you need to place the double quotes around the join string yourself:
Continue reading “Function in Jet Reports to Get List into a String”
I’ve recently been creating some reports for a client using Jet Reports and data pulled from Microsoft Dynamics 365 Business Central. One of the requirements was to have a report which pulled out Intrastat related information in a specific format. As well as pulling out the standard information, they also wanted a calculation of the net weight for a sales order line, which mean linking from the Purch. Inv. Line (123) to the Item (27) table and multiplying the quantity by the net weight.
I initially tried to do this using a calculated field in the Excel PivotTable which was added on top of the data returned by Jet Reports, but quickly realised that the result wasn’t correct. This [prompted me to go back to the source data and see if I could perform the calculation using Jet Reports as it got the data rather than afterwards.
The report was being built using the Table Builder tool of Jet Reports; to add a calculated field in Table Builder, click the Add Formula button in the bottom left:
Continue reading “Create a Calculated Field in the Jet Reports Table Builder”
Clients often think that I know more Excel than I do, because I know how to use some functions such as IF, CONCAT and more, but my knowledge of Excel is quite limited when it comes to charts, graphs and PivotTables. I was recently writing a report for a client using Jet Reports to pull Intrastat information from Microsoft Dynamics 365 Business Central (both Jet and Business Central are irrelevant as far as the detail fo this post are concerned).
One of the things I wanted to do was create a summary of the data pulled from Business Central, which meant using a standard Excel PivotTable, something with which I have almost no experience. I managed to get most of the PivotTable configured without issue, but I needed to perform a calculation within the PivotTable and it took me a while to work out.
This is done by adding a calculated field through the PivotTable Analyze tab on the action bar; click the Fields, Items & Sets » Calculated Field button:
Continue reading “Add Calculated Field to PivotTable in Microsoft Excel”
Every month, on the third Tuesday, at MADIC dynamics we will be presenting a Knowledge Hub Webinar on Microsoft Dynamics 365 Business Central and related products; I will be presenting the first few webinars, but in future other consultants will be getting involved, so there will be a variety of presenters through time.
We aim to have the next three monthly Knowledge Hub Webinars scheduled and details of them available. The next three webinars, starting next month, are:
|
No march-2024 events found. |
|
No april-2024 events found. |
|
No may-2024 events found. |
In our most recent webinar here at MADIC dynamics, we took a look at Reporting with Business Central.
If you want to catch up on this webinar, you can do so here.
In this webinar we took an introductory look at the reporting tools which come with Microsoft Dynamics 365 Business Central as standard, such as list pages, standard reports and financial reporting, as well as then taking a look at the commonly used third-party reporting tools which include Jet Reports and Power BI.
Continue reading “MADIC dynamics Knowledge Hub Webinars: Reporting with Business Central”