Skip to main content
Solved

Problem "refresh" (recalculating field) of grid

  • October 19, 2021
  • 5 replies
  • 834 views
E
Varsity I

Hi, Good night.

 

I want to recalculate the field (% Above Winner) when a new row is inserted/updated/deleted. I did the method (and it works) but when i put this method in a event of the same grid i got an error/debuggin visual studio warning. But if i put the method in other field (other tab etc, no in the same grid) it works.

Can you helpme please? i paste some images to explain me better.

 

 

1.- this is the grid. I need to recalculate the column “%  AboveWinner “(for all rows) for Add,Update, Delete action.
2.- when i put the method “getAboveWinners” in the update field event of this grid i got an “error”
This is the error.
When i put the method in other button/tab etc (not in the same grid) it works!
    public void getAboveWinners()
    {
      int countLowestValue=0;
      decimal? lowestValue=0;
      //we get the lowest value;
      foreach (CEEstimateBidWinner soLine in this.viewCEEstimateBidWinner.Select())
      {
           if(lowestValue==0)
           {
                lowestValue=soLine.TotalBid;
           }
           else if(lowestValue>=soLine.TotalBid)
          {
              lowestValue=soLine.TotalBid;
          }
      }

      foreach (CEEstimateBidWinner soLine in this.viewCEEstimateBidWinner.Select())
      {
          decimal? resultado=((soLine.TotalBid/lowestValue)-1)*100;
          soLine.PercentageAboveWinner=resultado;
          viewCEEstimateBidWinner.Update(soLine);
      }
    }

 

Can you help me please, thanks!

Best answer by Naveen Boga

Hi @eddiedaco  Since the problem is related to refreshing the grid. You can add the below at last of your code and verify.

Graph.ViewName.View.RequestRefresh();

 

Hope this helps!!

View original
Did this topic help you find an answer to your question?

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3417 replies
  • Answer
  • October 19, 2021

Hi @eddiedaco  Since the problem is related to refreshing the grid. You can add the below at last of your code and verify.

Graph.ViewName.View.RequestRefresh();

 

Hope this helps!!

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
E
Chris Hackett
2 people like this
  • E
    eddiedaco
  • Chris Hackett
    Chris Hackett
E
Varsity I
  • eddiedaco
  • Author
  • Varsity I
  • 32 replies
  • October 26, 2021

Hi @Naveen B  

Graph.ViewName.View.RequestRefresh(); “works” (visually) but when i save the information. Its saves the “old” information not the new.

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3417 replies
  • October 27, 2021

Which means cache values are NOT persisting to Save the values in database.

Did you debug and check did cache holds the updated values?

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
E
Chris Hackett
2 people like this
  • E
    eddiedaco
  • Chris Hackett
    Chris Hackett
Dioris Aguilar
Jr Varsity I
Forum|alt.badge.img+2

@eddiedaco When putting the getAboveWinners method in the fieldUpdated event, make sure the other rows have status Updated, otherwise the cache will ignore them and will not be saved:

foreach (CEEstimateBidWinner soLine in this.viewCEEstimateBidWinner.Select())
{
   decimal? resultado=((soLine.TotalBid/lowestValue)-1)*100; 
   soLine.PercentageAboveWinner=resultado; 
   viewCEEstimateBidWinner.Update(soLine); 
   if(this.viewCEEstimateBidWinner.Cache.GetStatus(soLine) != PXEntryStatus.Inserted)
       this.viewCEEstimateBidWinner.Cache.SetStatus(soLine, PXEntryStatus.Updated);
}

 

E
Chris Hackett
2 people like this
  • E
    eddiedaco
  • Chris Hackett
    Chris Hackett
E
Varsity I
  • eddiedaco
  • Author
  • Varsity I
  • 32 replies
  • February 1, 2022

The problem was the “update” of yourview.Update. for every iteration the “.update” show error. The solution was change .update for yourview.Cache.SetValue<yourDAC.yourField>
                (soLine, yourvalue)

Chris Hackett
Dioris Aguilar
2 people like this
  • Chris Hackett
    Chris Hackett
  • Dioris Aguilar
    Dioris Aguilar

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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