Skip to main content
Solved

PXSelector for 24 R2 version

  • March 6, 2025
  • 7 replies
  • 129 views
  • Translate All
Varsity I
Forum|alt.badge.img+1

Hi,

I have problem with PXSelector on acumatica 24 R2, bql query worked fine for previous versions but not on the 24 R2. Now it gives odd message “The method or operation is not implemented”. My query looks like

 

[PXSelector(typeof(Search2<InventoryItem.inventoryID, InnerJoin<POLine, On<InventoryItem.inventoryID,
        Equal<POLine.inventoryID>, And<POLine.orderNbr, Equal<Current<MyDAC.poorderid>>>>>>),
    typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr),
    SubstituteKey = typeof(InventoryItem.inventoryCD),
    DescriptionField = typeof(InventoryItem.inventoryCD))]

 

Best answer by hotdok

Yes [Inventory] attribute works fine but it is not exactly what I need. So finally I figured out. The issue was DAC that had to be inherited from PxBqlTable interface as well as IBqlTable. This is requirement from 24 version

View original

    7 replies

    Captain II
    Forum|alt.badge.img+11
    • aiwan
    • Captain II
    • March 6, 2025

    HI ​@hotdok 

     

    Try this:

    [PXSelector(typeof(SearchFor<InventoryItem.inventoryID>.InnerJoin<POLine>.On<InventoryItem.inventoryID.IsEqual<POLine.inventoryID>.And<POLine.orderNbr.IsEqual<MyDac.poorderid.FromCurrent>>>(Rest Of Your Selector))]

     

    Translate
    Aleks
      Varsity I
      Forum|alt.badge.img

      Hi ​@hotdok ,

      [PXSelector(typeof(Search2<InventoryItem.inventoryID, InnerJoin<POLine, On<POLine.inventoryID, Equal<InventoryItem.inventoryID>>>, Where<POLine.orderNbr, Equal<Current<MyDAC.poorderid>>>>), typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr), SubstituteKey = typeof(InventoryItem.inventoryCD), DescriptionField = typeof(InventoryItem.inventoryCD))]

       

      Can you try this?

      Translate
      Premalatha N
        Varsity I
        Forum|alt.badge.img+1
        • hotdok
        • Author
        • Varsity I
        • March 6, 2025

        HI ​@hotdok 

         

        Try this:

        [PXSelector(typeof(SearchFor<InventoryItem.inventoryID>.InnerJoin<POLine>.On<InventoryItem.inventoryID.IsEqual<POLine.inventoryID>.And<POLine.orderNbr.IsEqual<MyDac.poorderid.FromCurrent>>>(Rest Of Your Selector))]

         

        Thanks but InnerJoin gives error in your BQL.

        Translate
        Varsity I
        Forum|alt.badge.img+1
        • hotdok
        • Author
        • Varsity I
        • March 6, 2025

        Hi ​@hotdok ,

        [PXSelector(typeof(Search2<InventoryItem.inventoryID, InnerJoin<POLine, On<POLine.inventoryID, Equal<InventoryItem.inventoryID>>>, Where<POLine.orderNbr, Equal<Current<MyDAC.poorderid>>>>), typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr), SubstituteKey = typeof(InventoryItem.inventoryCD), DescriptionField = typeof(InventoryItem.inventoryCD))]

         

        Can you try this?

        Thanks,

        But this gives same issue.

        Translate
        Captain II
        Forum|alt.badge.img+11
        • aiwan
        • Captain II
        • March 6, 2025

        Thanks but InnerJoin gives error in your BQL.

        It does, sorry!

         

        Could you try using the [Inventory] attribute, and a PXRestrictor for the PO nbr?

         

        Aleks

        Translate
        Aleks
          Varsity I
          Forum|alt.badge.img+1
          • hotdok
          • Author
          • Varsity I
          • Answer
          • March 6, 2025

          Yes [Inventory] attribute works fine but it is not exactly what I need. So finally I figured out. The issue was DAC that had to be inherited from PxBqlTable interface as well as IBqlTable. This is requirement from 24 version

          Translate
            Chris Hackett
            Community Manager
            Forum|alt.badge.img
            • Chris Hackett
            • Acumatica Community Manager
            • March 7, 2025

            Thank you for sharing your solution with the community ​@hotdok!

            Translate
            Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
            Terms & ConditionsAccessibility statement
            About Acumatica ERP system
            Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
            © 2008 — 2024  Acumatica, Inc. All rights reserved