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

(0) Share

Report

Posted on by joshtechsolutions

4,359

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 (1)

Answers (0)

Suggested answer

JAngle 33,159 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