Open Orders and Lines report Query not picking up data
The report is not picking the desired data.
Firstly, a number of line items are returning 0 value in the Net Selling Price column but do have values on checking Order Organiser.
Secondly, the only Picking Status now showing is either Staged/Picked Confirmed or blank. This field also used to contain “Backordered” & a couple of other statuses.
I have attached the query for your reference as well.
Kind Regards
Siva Charan