Changing the View of the Sales Prices Screen

Hi @jinin 

Thank you for your response.

Here is the code.

    [PXFilterable]
        public PXSelectJoin<ARSalesPrice,
            LeftJoin<InventoryItem, On<InventoryItem.inventoryID, Equal<ARSalesPrice.inventoryID>>,
            LeftJoin<INItemClass, On<INItemClass.itemClassID, Equal<ARSalesPrice.itemClassID>>,
            LeftJoin<CR.BAccount, On<CR.BAccount.bAccountID, Equal<ARSalesPrice.customerID>>,
            LeftJoin<INSite, On<ARSalesPrice.siteID, Equal<INSite.siteID>>>>>>,
            Where2<Where<CR.BAccount.bAccountID, IsNull, Or<Match<CR.BAccount, Current<AccessInfo.userName>>>>,
            And2<Where<InventoryItem.inventoryID, IsNull, Or<Match<InventoryItem, Current<AccessInfo.userName>>>>,
            And2<Where<INItemClass.itemClassID, IsNull, Or<Match<INItemClass, Current<AccessInfo.userName>>>>,
            And2<Where<ARSalesPrice.siteID, IsNull, Or<Match<INSite, Current<AccessInfo.userName>>>>,
            And<ARSalesPrice.itemStatus, NotIn3<INItemStatus.inactive, InventoryItemStatus.unknown, INItemStatus.toDelete>,
            And2<Where<ARSalesPrice.isFairValue, NotEqual<True>, Or<FeatureInstalled<FeaturesSet.aSC606>>>,
            And2<Where<Required<ARSalesPriceFilter.priceType>, Equal<PriceTypes.allPrices>, Or<ARSalesPrice.priceType, Equal<Required<ARSalesPriceFilter.priceType>>>>,
            And2<Where<Required<ARSalesPriceFilter.taxCalcMode>, Equal<PriceTaxCalculationMode.allModes>,
                Or<ARSalesPrice.taxCalcMode, Equal<Required<ARSalesPriceFilter.taxCalcMode>>>>,
            And2<Where<ARSalesPrice.customerID, Equal<Required<ARSalesPriceFilter.priceCode>>, Or<ARSalesPrice.custPriceClassID, Equal<Required<ARSalesPriceFilter.priceCode>>, Or<Required<ARSalesPriceFilter.priceCode>, IsNull>>>,
            And2<Where<ARSalesPrice.inventoryID, Equal<Required<ARSalesPriceFilter.inventoryID>>, Or<Required<ARSalesPriceFilter.inventoryID>, IsNull>>,
            And2<Where<ARSalesPrice.siteID, Equal<Required<ARSalesPriceFilter.siteID>>, Or<Required<ARSalesPriceFilter.siteID>, IsNull>>,
            And2<Where2<Where2<Where<ARSalesPrice.effectiveDate, LessEqual<Required<ARSalesPriceFilter.effectiveAsOfDate>>, Or<ARSalesPrice.effectiveDate, IsNull>>,
            And<Where<ARSalesPrice.expirationDate, GreaterEqual<Required<ARSalesPriceFilter.effectiveAsOfDate>>, Or<ARSalesPrice.expirationDate, IsNull>>>>,
            Or<Required<ARSalesPriceFilter.effectiveAsOfDate>, IsNull>>,
            And<Where2<Where<Required<ARSalesPriceFilter.itemClassCD>, IsNull,
                    Or<INItemClass.itemClassCD, Like<Required<ARSalesPriceFilter.itemClassCDWildcard>>>>,
                And2<Where<Required<ARSalesPriceFilter.inventoryPriceClassID>, IsNull,
                    Or<Required<ARSalesPriceFilter.inventoryPriceClassID>, Equal<ARSalesPrice.priceClassID>>>,
                And2<Where<Required<ARSalesPriceFilter.ownerID>, IsNull,
                    Or<Required<ARSalesPriceFilter.ownerID>, Equal<ARSalesPrice.priceManagerID>>>,
                And2<Where<Required<ARSalesPriceFilter.myWorkGroup>, Equal<False>,
                         Or<ARSalesPrice.priceWorkgroupID, IsWorkgroupOfContact<CurrentValue<ARSalesPriceFilter.currentOwnerID>>>>,
                And<Where<Required<ARSalesPriceFilter.workGroupID>, IsNull,
                    Or<Required<ARSalesPriceFilter.workGroupID>, Equal<ARSalesPrice.priceWorkgroupID>>>>>>>>>>>>>>>>>>>>>,
                OrderBy<Asc<ARSalesPrice.inventoryCD,
                        Asc<ARSalesPrice.priceType,
                        Asc<ARSalesPrice.uOM, Asc<ARSalesPrice.breakQty, Asc<ARSalesPrice.effectiveDate>>>>>>> Records;

 Hi, @zfebert56 

Thank you for your assistance to me. It works for me.

Thanks again.