Hi, I am quite new to Jet Reporting but have worked my way through a number of reports but have hit a stumbling block on the below.
I am trying to get to actual order quantities and values v actual invoiced quantities and values by Item and Customer, so in short a discrepancy report for ordered and invoiced.
I started with 'Sales Line Archive' to give me the products and linked 'Sales Header Archives' to bring in 'Posted Orders'. I have several filters already in place on 'Sales Line Archives' but need to add a filter to 'Posted Orders' to bring back 'True', this is the filter I am struggling with