0

link additional GP table with filters

I created a report using the jet wizard to show most of the data I need from the sales header which created the following

Filter

=NL("Rows=3","Sales Transaction History","SOP Number","+Document Date",$C$2,"Customer Number",$C$3,"SOP Number",$C$4,"SOP Type","3")

First Table
=NL("Rows","Sales Transaction History",,"SOP Number","@@"&$F9,"+Document Date",$C$2,"Customer Number",$C$3)

Now I created the following to link the sales detail:
=NL("rows","Sales Transaction Amounts History",,"SOP Number",$G$8) I know I must refer to the filters or put them in the jfx window, but I am unsure how.

sorry I only do these reports about once a year and i forget how to link multiple tables. Can't wait for that new feature using the wizard and multiple tables.

PS. I know there are suppose to be new views created that already link these tables but i do not have them.

0 comments

Please sign in to leave a comment.