web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Jet report works for 1...
Small and medium business | Business Central, N...
Suggested Answer

Jet report works for 1 business unit but not the others

(13) ShareShare
ReportReport
Posted on by Jolie 27

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)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Jolie,

    Try submitting your issue here:  

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

    Thanks,

    Steve

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 101,995 Super User 2026 Season 1 on at

    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/

    pastedimage1643067362735v1.png

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,840 Super User 2026 Season 1 on at
    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
  • Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 27,280 Most Valuable Professional on at

    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

  • ElSteiner Profile Picture
    ElSteiner 8 on at
    This sounds less like a report template issue and more like how Jet is resolving the company context. Even if the name is updated, Jet can still default to the last active company unless it’s explicitly set in the NL formulas. Also check whether F&B uses different dimensions or posting groups. I’ve seen similar multi-entity quirks discussed in unrelated accounting threads while researching other platforms, for example when comparing systems mentioned alongside sites like https://cardmates.co.uk/poker-sites/best-poker-apps. Refreshing metadata and confirming company permissions often helps too.
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 22,792 Super User 2026 Season 1 on at
    Question was posted in 2022, and most likely the user has already found a solution or an alternative approach
  • CU25051427-0 Profile Picture
    CU25051427-0 on at
    Most likely, your NP("Company") query has a static value set, which critically limits the dynamic updating of data in the report. To fix this error, you need to carefully check the syntax of the formula in Excel and make sure that the appropriate cell references are used instead of a fixed text value.
    The bicho 77 service is often used to verify parameters and work with information flows, which, thanks to its stable operation and clear interface, allows you to effectively interact with data. Correctly setting up cell connections together with reliable verification tools will ensure automation of calculations and help avoid discrepancies in the final indicators.
  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    Grigorios Mavrogeorgis 2,554 Super User 2026 Season 1 on at
    Hi,
    first thing I'd do is forget Jet for a second and check the same filter straight in NAV. Open the Chart of Accounts, put the F&B business unit / dimension filter on it, and see if the F&B numbers actually show. If they don't show in NAV either, then it's not the report — it's the data or the filter value.
    Most common one I see, the filter is on the Code but you typed the Name. Business units and dimension values both have a separate Code and a Name, and the filter wants the Code — if Casino's happens to match and F&B's doesn't, you get exactly this, casino pulls, F&B comes blank. Also worth checking the F&B postings really carry that dimension, and aren't sitting on different GL accounts than you think.

    The Jet function side itself is third-party, so for the formula syntax better ask Jet support. Is F&B a dimension, a separate company, or a consolidation business unit?
     
    Glad to help - follow up if anything is unclear.  
    â–º  If this solved it, marking it verified helps others too.      
    Regards,
    Grigorios Mavrogeorgis
    Business Central Consultant & AL Developer
    Work: Gmsoft Limited
    Blog:  insidebusinesscentral
    LinkedIn: linkedin.com/in/gregorymavrogeorgis
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,960 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,299 Super User 2026 Season 1

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 1,131 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans