Administration, Core Financials, and Project Accounting

[trodman]

The "Open Work Order Material Items" preview in the Inventory explorer view is showing all work orders instead of only the open ones.  Looking at the "Maintain Business Insights View / Context Menus" screen, it looks like a filter was intended.  However, the "Filter Column" column is missing a value.  I can't modify the filter because everything is grayed-out, probably because this is an out-of-the-box explorer view.

Does anyone know how I can edit this explorer view?

[JohnHanrahan]

You could export it out and then import it under a new name.  I believe then it will allow you to change it.  As you change it trace the process and it should show you the backend change required (or live with your new one).

J

[trodman]

Good idea John.  I found it.  I was able to fix it by running the following:

UPDATE tsmEntityPreview SET FilterColumn='WorkOrderComplete', FilterOperator=2
WHERE Caption='Open Work Order Material Items'

 Maybe Sage can fix this in their code.

[MCarlise]

Thanks for the work Tim. I'll write it up so we can fix the code.

Also for those who don't know SQL, the front end work around (sort of) is when you previewthe Work Order Step (at the bottom of the screen, right click and Explore Work Order Step. In there delete all the filters and add a new one with WO Complete is equal to NO and save that as the default settings for that view. The closed work orders will still show up on the Open Work Order Material Steps, but at least when you drill into it, it will filter out the closed work order. Not the best work around.