Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

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

Posted on by 4,241

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.

pastedimage1647391612521v2.png

Thank you!

Categories:
  • Suggested answer
    JAngle Profile Picture
    JAngle 33,155 on at
    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

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans