Dynamics Community Forum Thread Details

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

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.

Categories:

Financial Management

Management Reporter

Sales

Quick Links

Leaderboard