Hello dear F&O Admins,
I was hoping you could confirm (or not) my view on the following situation :
A user wants to select an item (05050505) in Product information management > Products > Released product
Then display the related trade agreements (Trade agreements > View Trade Agreement) with a custom view pinned as default.
On this screen, an initial filter is applied in column Product Code Type :
(((PriceDiscTable.Relation == 4) && ((((PriceDiscTable.ItemCode==0) && (PriceDiscTable.ItemRelation=="05050505")) || (PriceDiscTable.ItemCode==2))))) || (((PriceDiscTable.Relation == 5) && ((((PriceDiscTable.ItemCode==0) && (PriceDiscTable.ItemRelation=="05050505")) || (PriceDiscTable.ItemCode==2))))) || (((PriceDiscTable.Relation == 6) && ((((PriceDiscTable.ItemCode==0) && (PriceDiscTable.ItemRelation=="HF050505")) || (PriceDiscTable.ItemCode==2))))) || (((PriceDiscTable.Relation == 7) && ((((PriceDiscTable.ItemCode==0) && (PriceDiscTable.ItemRelation=="05050505")) || (PriceDiscTable.ItemCode==2)))))
= Select all lines from PriceDiscTable corresponding to article 05050505(or all items if ItemCode = 2) and are Price or Discount type.
BUT, a second wave of filters are added due to the pinned view. The filters are :
Product Code Type is exactly Table
Relation is exactly Price (Sales)
=> It create a mess with the filters : the Relation change to Price (Purchase) and the item change.
The only way to apply the custom view is to go back to the standard view and re-apply the custom view manually.
Unfortunately, this solution wasn't well received by the user.
The way I see it :
The initial filter is mandatory to display the selected item from the previous screen.
I can't amend this filter from the Standard view.
Even if a custom view is pinned as default, the standard needs to be applied to get the right item.
Do I miss anything ?
Thank you
Best Regards
Arnaud