I have read a lot on creating reports in the past few weeks and I felt ready to start with my first report; A picking list that would show the sales line where the line type is = to 0. This way we can use the description field to add comments.
Unfortunalty after less than 5 minutes[:^)]
The standard NAV report 10153 Picking List by Order uses DataItemTableView to filter all items with outstanding quantity <> 0. This is okay, but it also prevents any sales line of Type 0 from showing.
I have tried the lines below, but it filters everthing regardless of the line Type
IF “Sales Line”.Type = Type::Item THEN
“Sales Line”.SETFILTER(“Outstanding Quantity”, ‘<>0’);