Open Order Report By Item
Hello,
I am wanted to see if there was ever a solution to a question asked by gentleman regarding an open order report and the ability to filter by preferred vendor. I am having the exact same issue that he was having two years ago.
The Scenerio:
During the last year we have run into a large number of back orders from various vendors due to the supply chain issues. We would like to be able to pull an open item report showing all the open sales orders and items by Vendor. This would easily allow us to find open orders from a received vendor purchase order by item.
The Problem:
When I choose "Preferred Vendor" from the filter list and then select "Vendor A" from the drop down, the report does not filter the open items/sales order from Vendor A, it acts as if the filter isn't there and reports all open items.
Is there a fix or a work around? I did try to add a customer field to the inventory item by creating a "Product Line" field and filter off that but the same thing happened and the report was generated with no filtered results. Any suggestions would be helpful.
Thank you