Small and medium business | Business Central, N...

Jet report works for 1 business unit but not the others

(10) Share

Report

Posted on by Jolie

Hi there! Hoping we can figure out a solution to my NAV/Jet Report problem...

My company uses NAV for accounting & running financial statements. Within NAV, we have several business units (1 for casino, and 1 for food & beverage F&B). We normally run Jet Reports for the Casino business unit, with no problems. When trying to run a Jet Report out of the F&B business unit, we ran into the below problem:

The Jet Report for the F&B business unit is not picking up the specified GL codes in that business unit. I have edited the Jet Report template to reflect the appropriate name of the F&B business unit, and ensured that the revenue/expense GL codes we want to be picked up are accurate. However, when I run the report, the F&B # are not being picked up, and we have no idea what else (within the report; report coding) we can do differently.

Could it be a setting configuration issue of this particular business unit? One thing to note, that I found interesting, is that # from the Casino business unit are being picked up in the report. I'm starting to think that Jet Report failed to realise that we are within a different business unit (F&B), and not the regular business unit where we have no problems running reports in.

Can someone please advise?

Thanks in advance.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

Jolie,

Try submitting your issue here:

support.jetglobal.com/.../115000515588-Jet-Reports

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,681 Super User 2025 Season 2 on at

Like (1)

Report

Hi, I'm sorry, it's hard to tell exactly what the problem is based on what you've provided. But this still looks like a problem with business units taking values. Maybe you should check the filter in the Jet function.

I think you can try the standard template and test if the data is correct.

https://insightsoftware.com/downloads/

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

Like (2)

Report

Re-check the links and filters in the Jet Report.
Most likely You didn't update them everywhere.
Without seeing the data and the excel jet report file, it is hard (almost impossible) to help You out on this.

Best advice is to try to create a new report from scratch, that lists the needed GL account list and see if it works.

One option I can think of, could be that Jet Report is not correctly processing the code because it has the & symbol in it. You can try to test on other code, or re-name the code to FB instead of F&B

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.

Introduction to Jet Reports

Connect Jet Reports to Microsoft Dynamics 365 Business Central in Excel

Best Regards
Gerardo

Was this reply helpful? Yes No
Vayja 8 on at

Like (0)

Report

This sounds less like a template issue and more like a company/business unit context problem

Was this reply helpful? Yes No