[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,971

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!

I have the same question (1)

All responses (1)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

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

Was this reply helpful? Yes No