Business Reporter - how to fetch only data from Purchase Orders with status not planned?

Hi Simon,
In the ‘Light items’ section of the Information source, you can see the display item called ‘Status’. You can use it as a report book/sheet/column/row/cell level filter to filter out the data you want. Kindly let us know your feedback if you wanted something else.

Best Regards,
Nisansala

Hi @Nisansala , 

Thank you for your reply. The item ‘Status’ which you mention is the status of the purchase order line, not the purchase order header. The ‘begin’ status of the line is always Released,. When the Purchase Order header status is Planned or Released, the line status will always be Released. And I want to exclude the lines which are connected to a Purchase Order with header status Planned. So the item which you mention is no use for what I want to achieve. 

Do you have any other suggestions? Kind regards,

Simon

Hi @Nisansala, 

I followed your instructions and managed to display the Order Status in Business Reporter. This was exactly what I was looking for. I did not know that it was possible to add new items to the information source, so I learned something new. Many thanks for your help! 

Kind regards,

Simon