web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Jet Reports - NL NF NP...

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

Suggested Answer

Jet Reports - NL NF NP GL functions

(1) Share

Report

Report

Posted on by DinB

4,085

In Jet Reports, what is the full form of the letters in the functions NL, NF, NP and GL?

Their documentation describes the function, but it does not say what the letters stand for in each name.

https://docs.jet.insightsoftware.com/hc/en-us/articles/16814468626957-NL-Function-Reference

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

VC-29041637-0 114 Moderator on at

Like (2)

Report
Copy link

Link copied!

As per Jet Reports, other than the GL function, the other 3 don't stand for anything. When they created them they tried to find functions that were available to be used in all languages in excel.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, hope the following helps as well.

https://ksdconsultancy.blog/2015/09/26/creating-report-in-jet-using-nl-nf-np-gl-excel-formulas/

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

OussamaSabbouh 2,344 Super User 2026 Season 1

#2

YUN ZHU 1,742 Super User 2026 Season 1

#3

AndrewThomas81 1,231

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans