Skip to main content

Notifications

Microsoft Dynamics NAV forum
Answered

Jet Basic - filtering for a specific value in a linked table

Posted on by 85

Hello,

I had a question - I am trying to build a report where I can get my sales numbers in the sales unit of measure, which is different from the base unit of measure. I am using the Jet sales basic report Item sales and Profit as a starting point

The table function is as follows 

=@NL("Table","27 Item",$E$11:$AA$11,"Headers=",$E$10:$AA$10,"TableName=","Item","Filters=",$C$5:$D$7,"InclusiveLink=27 Item",$F$9,"IncludeDuplicates=","True")

The link is here 

=@NL("Link","5404 Item Unit of Measure",,"1 Item No.","=1 No.")

and the field I am displaying is 

=@NL("LinkField","5404 Item Unit of Measure","3 Qty. per Unit of Measure.")

What my goal is is to ensure that the linkfield is pulling the number from CODE = CASE from the item unit of measure field. I have tried putting a filter in a bunch of places, but admittedly am a bit of a beginner at this and might just be getting a syntax error or am missing something else. 

If someone could assist me I would really appreciate it.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Jet Basic - filtering for a specific value in a linked table

    Hello,

    Try this link to the Jet Report website Community assistance: help.insightsoftware.com/.../jet

    Hope this helps.

    Thanks,

    Steve

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans