News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... [Jet Report] How do I ...

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

Answered

[Jet Report] How do I prevent duplicates of the posting groups in Jet report when I pull out from Navision?

(0) Share

Report

Report

Posted on by joshtechsolutions

4,855

Hi Community,

I'm trying to pull out Customer and Inventory Posting Groups, however, I notice that when I click Run in Jet report, the posting groups will duplicate.

May I know the codes to prevent the duplicates?

Currently, my codes is like this:

=@NL("Rows","Customer Posting Group","Code","Company=",Options!$C$2)

Where Options is the another tab which tells Jet report from which company I'm pulling out from.

Thank you!

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

JAngle 95 on at

Like (0)

Report

RE: [Jet Report] How do I prevent duplicates of the posting groups in Jet report when I pull out from Navision?

Put the formulas in the same column for nl(“rows”). It has a repeater built in to it. Have the caption for whether it is customer/vendor/inventory at row level instead of column

Helpful resources

Quick Links

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

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans