Skip to main content
Solved

Missing Group/Sum option in IFS Cloud. Will this be included in a release in the near future?

  • Mar 6, 2024 9:18 PM UTC
  • 16 replies
  • 2620 views
thaelk
Sidekick (Employee)
Forum|alt.badge.img+8

Is Group/Sum option in Advanced Search functionality available in IFS Cloud version? 

There are several topics posted covering this topic. As the below entries were few years old, I was hoping something might have changed in between. Can I know that, will this Group/Sum option included in upcoming cloud version. If it is already available, is there any material on how this is done?

Missing Group/Sum option in IFS Cloud #GSDTECH# | IFS Community

Advanced search (i.e. group, count, sum, etc) | IFS Community

 

One of IFS customers has raised this question again and In App9 & App10 user had the possibility to conduct advanced searches by grouping values and summarizing values in table views. They wants to know whether this will be included in a release in the near future. 

Business Impact: User will have to use longer methods to find information that is required.

 

Thank You & Best Regards,

Best answer by Nikila Dis

Hi @thaelk 

I have further checked this behavior and found these steps which may help you. Assume if we want to get the sum of Reserved Qty;

  1. Open page navigator
  2. Click on Inventory part in stock list
  3. There is separate field called ‘ > Summary’
  4. Now click on + mark and enter a pick value in the summary field > confirm and closed.
  5. Now save it and publish it in the Global Context.
  6. Now you can see the sum of the quantities of the relevant field.

 

 

 

Regards,

Nikila Dissanayake

View original

    16 replies

    Nikila Dis
    Superhero (Employee)
    Forum|alt.badge.img+14
    • Nikila Dis
    • Superhero (Employee)
    • Mar 7, 2024 2:41 AM UTC

    Hi @thaelk,

    As per my understanding due to some technical/ functional difficulties/ challenges the different product areas face, RnD has not decided to implement Group/ Sum/ Order in IFS Cloud. Recently I have checked whether this has been implemented in our latest 23R2 environment and the results were negative. One workaround is that we can export the data into Excel and find the relevant group/sum for respective columns (which may be time-consuming).

    Regards,

    Nikila Dissanayake

    www.linkedin.com/in/nikila-dissanayake-7140891a0
      Nikila Dis
      Superhero (Employee)
      Forum|alt.badge.img+14
      • Nikila Dis
      • Superhero (Employee)
      • Answer
      • Mar 7, 2024 4:32 AM UTC

      Hi @thaelk 

      I have further checked this behavior and found these steps which may help you. Assume if we want to get the sum of Reserved Qty;

      1. Open page navigator
      2. Click on Inventory part in stock list
      3. There is separate field called ‘ > Summary’
      4. Now click on + mark and enter a pick value in the summary field > confirm and closed.
      5. Now save it and publish it in the Global Context.
      6. Now you can see the sum of the quantities of the relevant field.

       

       

       

      Regards,

      Nikila Dissanayake

      www.linkedin.com/in/nikila-dissanayake-7140891a0
        thaelk
        Sidekick (Employee)
        Forum|alt.badge.img+8
        • thaelk
        • Author
        • Sidekick (Employee)
        • Apr 10, 2024 4:00 AM UTC

        Hi @Nikila Dis,

        Thank you very much for the answer. 

         

        Best Regards

        Thakshal

        Superhero (Partner)
        Forum|alt.badge.img+17
        • knepiosko
        • Superhero (Partner)
        • Aug 23, 2024 4:17 PM UTC

        Hi

         

        Does someone noticed performance issues after setting any summaries?

        Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/
          Sidekick (Customer)
          Forum|alt.badge.img+8
          • leadingzeros
          • Sidekick (Customer)
          • Aug 27, 2024 1:17 AM UTC

          Interested in this solution and if folks are noticing a performance hit as a result. 

          Sidekick (Customer)
          Forum|alt.badge.img+8
          • TPLaine
          • Sidekick (Customer)
          • Sep 27, 2024 6:27 AM UTC

          Are there any workarounds or future implementations regarding grouping on lists. Sum helps a bit, but grouping is still an issue.

            Sidekick (Partner)
            Forum|alt.badge.img+3
            • InfMoniPo
            • Sidekick (Partner)
            • Oct 7, 2024 10:14 AM UTC

            Hello, I am interested to know if sum and grouping functionality has been already added in some of the recent releases. 

            Do Gooder (Customer)
            Forum|alt.badge.img+2
            • joelstorm
            • Do Gooder (Customer)
            • Oct 16, 2024 2:42 PM UTC

            Hi! I´m also interesting in a solution closer to the capabilities of APP10. The group/sum was used heavily in our organization before moving to Cloud. 

              ashenfdo
              Sidekick (Customer)
              Forum|alt.badge.img+8
              • ashenfdo
              • Sidekick (Customer)
              • Jan 5, 2025 6:14 PM UTC

              As a workaround you can use the chart View, there you can create a chart and set group by

               

               

                PRODQ
                Superhero (Customer)
                Forum|alt.badge.img+19
                • PRODQ
                • Superhero (Customer)
                • Jun 9, 2025 8:22 AM UTC

                Hi @thaelk 

                I have further checked this behavior and found these steps which may help you. Assume if we want to get the sum of Reserved Qty;

                1. Open page navigator
                2. Click on Inventory part in stock list
                3. There is separate field called ‘ > Summary’
                4. Now click on + mark and enter a pick value in the summary field > confirm and closed.
                5. Now save it and publish it in the Global Context.
                6. Now you can see the sum of the quantities of the relevant field.

                 

                 

                 

                Regards,

                Nikila Dissanayake

                ​@Nikila Dis Could I ask which release this ‘Summary’ is in, please?
                Thanks

                Linda
                Sidekick (Partner)
                Forum|alt.badge.img+6
                • cdcdaniek
                • Sidekick (Partner)
                • Jun 9, 2025 9:15 AM UTC

                Hi,

                it’s fine to have possibility to add summary row but I consider it as a workaround because nobody wants to have page configuration for this purpose and be forced to do rebase for all changed pages in evergreen model.

                Is IFS preparing this functionality for next release as a general setting in Core?

                Daniel 

                  Sidekick (Partner)
                  Forum|alt.badge.img+6
                  • cdcdaniek
                  • Sidekick (Partner)
                  • Aug 4, 2025 9:27 AM UTC

                  Hi,

                  anything new? Can anyone from  ​@IFS Elite Solution Experts ​@IFS Global Consulting Services join a statement? IMHO it’s one of the most painful missing functions on client. Is there any plan to implement it?

                  Trick sent earlier is useful but it’s much more a workaround and it doesn’t solve the need for grouping.

                  Daniel

                    Sidekick (Customer)
                    Forum|alt.badge.img+3
                    • JGHSUSAN
                    • Sidekick (Customer)
                    • Nov 18, 2025 2:49 PM UTC

                    How do we petition IFS to provide a solution for this. No function for group and sum is a major restriction for users in doing daily tasks.

                    PRODQ
                    Superhero (Customer)
                    Forum|alt.badge.img+19
                    • PRODQ
                    • Superhero (Customer)
                    • Nov 18, 2025 3:17 PM UTC

                    How do we petition IFS to provide a solution for this. No function for group and sum is a major restriction for users in doing daily tasks.

                    I don’t know if anyone has raised it previously as an “idea”…
                     

                     

                    Linda
                    matt.watters
                    Ultimate Hero (Partner)
                    Forum|alt.badge.img+26
                    • matt.watters
                    • Ultimate Hero (Partner)
                    • Nov 18, 2025 5:30 PM UTC

                    ​@PRODQ this idea is 3 years old. There are also separate ideas raised for adding this feature in specific pages.

                     

                    If a response resolves your issue, please use "Best Answer" so that the thread can be closed and others can find solutions more easily. Regards - Matt
                    Do Gooder (Customer)
                    Forum|alt.badge.img+1
                    • saikatb
                    • Do Gooder (Customer)
                    • Sep 15, 2026 7:43 PM UTC

                    IFS has provided in some read only pages a functionality of Grouping data, where you can select the fields you want to group by and summarize the numeric columns, like for example in Gl Balance summary. Not exactly same as Advanced search group and sum, but similar. You can extrapolate this functionality in other required pages, if you follow the code.

                    In the editable pages you can have a command to call a read only page which can have this functionality coded.

                     

                    Terms & ConditionsAccessibility statement