Solved

Updating custom header when all the rows get changed by an action

1 month ago
February 17, 2025
7 replies
76 views

u662
Freshman II
8 replies

I have two custom fields Absolute Variance Quantity for rows and Total Absolute Variance Quantity in the header. I can get these fields to update via PI Review and Scan and Count just fine, but when I do an action such as Set Not Entered To Zero, the custom header field won’t update.

Here, the only value that got send to the custom header field was the first line (21), but the header field should be close to 101,772

Here is my code for the field definitions and this screen:

INPIHeaderExt.usrTotalAbsVarQty

[PXDBQuantity]
[PXDefault(TypeCode.Decimal, "0.00")]
[PXUIField(DisplayName = "Total Absolute Variance Qty.", Visibility = PXUIVisibility.SelectorVisible, Enabled = false)]

INPIDetailExt.usrAbsVarQty

[PXDBQuantity()]
[PXUIField(DisplayName="Absolute Variance Quantity", Enabled = false)]
[PXFormula(null, typeof(SumCalc<INPIHeaderExt.usrTotalAbsVarQty>) )]

Code Editor: INPIReview (Physical Inventory Review)

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using PX.Common;
using PX.Data;
using PX.Data.BQL;
using PX.Data.BQL.Fluent;
using PX.Objects.CM;
using PX.Objects.Common.Extensions;
using PX.Objects.CS;
using PX.Objects.IN.PhysicalInventory;
using PX.Data.WorkflowAPI;
using PX.Objects;
using PX.Objects.IN;

namespace PX.Objects.IN
{
  //this is for the PI Review screen, where data can be entered manually line by line
  public class INPIReview_Extension : PXGraphExtension<PX.Objects.IN.INPIReview>
  {
    protected void _(Events.FieldUpdated<INPIDetail, INPIDetail.physicalQty> e)
    {
      var row = (INPIDetail)e.Row;

      if (row == null) return;

      //INPIDetail details = (INPIDetail)Base.Tools.Current;
      //var inpiDetail = PXCache<INPIDetail>.GetExtension<INPIDetailExt>(details);
      //INPIDetailExt inpiDetailExtVar = Base.Document.Current.GetExtension<INPIDetailExt>();

      decimal varianceQuantityVariable = (decimal)0.00;

      if(row.PhysicalQty != null && row.BookQty != null){
        varianceQuantityVariable = (decimal)(row.VarQty);//how variance quantity is initially calculated
      }

      decimal absoluteVarianceQuantity = Math.Abs(varianceQuantityVariable);

      e.Cache.SetValueExt<INPIDetailExt.usrAbsVarQty>(row, absoluteVarianceQuantity);

      //save this changed cache to the form
      Base.Actions.PressSave();

      //Refresh the header
      Base.PIHeader.View.RequestRefresh();

      return;

    }

  }
}

I’ve tried changing the field in the event handler to INPIDetail.varQty but it resulted in the custom detail field not updating at all. Changing the event handler to RowUpdated also didn’t work, and it only changed the header field after the next row got changed, so it was always one row behind.

Best answer by u662

Django wrote:

That looks about right. (Note, Minus is depreciated, use Subtract in the future).

So what that will do is:

Populate UsrAbsVarQty with the results of that first formula (the Switch). I know you said that you’re already populating this field properly - you won’t need to do that in code since you’re doing it by using the declaration.
It will update the header usrTotalAbsVarQty field with the net change of the UsrAbsVarQty field.

@Django In combination with a method override of RecalcTotals(), this worked.

Here is my final code:

INPIDetailExt.usrAbsVarQty

[PXDBQuantity()]
[PXUIField(DisplayName="Absolute Variance Quantity", Enabled = false)]
[PXFormula( typeof(Switch<Case<Where<INPIDetail.varQty, Less<decimal0>>, Minus<INPIDetail.varQty>>, INPIDetail.varQty>), typeof(SumCalc<INPIHeaderExt.usrTotalAbsVarQty>) )]

Code Editor: INPIReview (Physical Inventory Review)

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using PX.Common;
using PX.Data;
using PX.Data.BQL;
using PX.Data.BQL.Fluent;
using PX.Objects.CM;
using PX.Objects.Common.Extensions;
using PX.Objects.CS;
using PX.Objects.IN.PhysicalInventory;
using PX.Data.WorkflowAPI;
using PX.Objects;
using PX.Objects.IN;

namespace PX.Objects.IN
{
  //this is for the PI Review screen, where data can be entered manually line by line

  public class INPIReview_Extension : PXGraphExtension<PX.Objects.IN.INPIReview>
  {

    protected void _(Events.FieldUpdated<INPIDetail, INPIDetail.physicalQty> e)
    {
      var row = (INPIDetail)e.Row;

      if (row == null) return;

      decimal varianceQuantityVariable = (decimal)0.00;

      if(row.PhysicalQty != null && row.BookQty != null){
        varianceQuantityVariable = (decimal)(row.VarQty);//how variance quantity is initially determined
      }

      decimal absoluteVarianceQuantity = Math.Abs(varianceQuantityVariable);

      e.Cache.SetValueExt<INPIDetailExt.usrAbsVarQty>(row, absoluteVarianceQuantity);

      return;

    }

    #region Views
    [PXFilterable]
    [PXImport(typeof(INPIHeader))]
    public
      SelectFrom<INPIDetail>.
      Where<INPIDetail.FK.PIHeader.SameAsCurrent>.
      View PIDetailPure;
    #endregion

    public delegate void RecalcTotalsDelegate();
    [PXOverride]
    public void RecalcTotals(RecalcTotalsDelegate baseMethod)
    {
      baseMethod();

      INPIHeaderExt inpiHeaderExtVar = Base.PIHeaderInfo.Current.GetExtension<INPIHeaderExt>();
      decimal runningAbsVarianceTotal = 0m;

      foreach (INPIDetail detail in PIDetailPure.Select())
      {
        if (detail == null || detail.Status == INPIDetStatus.Skipped)
          continue;

        runningAbsVarianceTotal += Math.Abs(detail.VarQty ?? 0m);
      }

      var header = (INPIHeader)Base.PIHeader.Cache.Current;
      if (header != null)
      {
        inpiHeaderExtVar.UsrTotalAbsVarQty = runningAbsVarianceTotal;
        Base.PIHeader.Update(header);
      }
    }

  }
}

View original

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

Django
Captain II
570 replies
1 month ago
February 19, 2025

In your INPIDetailExt.usrAbsVarQty field declaration for PXFormula you can use a switch formula to simulate the ABS function on the VarQty field value. And by having the VarQty listed in the PXFormula, it will be added to the fields checked for updates. Meaning, when VarQty is changed, your PXFormula will be (re)calculated. The first part of the formula will update the UsrAbsVarQty field and then the second part will update the header value.

Your header value really shouldn’t be one update behind at all so I’m not sure what’s happening there.

One thing to look at is if the grid is set to hold on to its updates (batch mode?)

Note that this process will only update the header field with the net change that each record introduces but I think that will be exactly what you want anyway.

u662
Author
Freshman II
8 replies
1 month ago
February 19, 2025

Django wrote:

Your header value really shouldn’t be one update behind at all so I’m not sure what’s happening there.

One thing to look at is if the grid is set to hold on to its updates (batch mode?)

Note that this process will only update the header field with the net change that each record introduces but I think that will be exactly what you want anyway.

@Django Would the use of Minus<INPIDetail.varQty> (if it’s less than zero) be applicable here?

Django
Captain II
570 replies
1 month ago
February 19, 2025

It would be Subtract<>.

But maybe I missed something but don’t you want your header total to be the sum of the absolute value of the varQty field value? Or just of the negative varQty field values?

u662
Author
Freshman II
8 replies
1 month ago
February 19, 2025

Django wrote:

It would be Subtract<>.

But maybe I missed something but don’t you want your header total to be the sum of the absolute value of the varQty field value? Or just of the negative varQty field values?

@Django The custom header will be the total for the custom absolute variance detail columns as defined by typeof(SumCalc<INPIHeaderExt.usrTotalAbsVarQty>). The custom detail field is currently populated by correctly code.

You are correct, the custom header total should be the sum of the absolute value of the varQty field values.

If I’m following correctly, the code for the custom detail field’s PXFormula (INPIDetailExt.usrAbsVarQty), as you initially suggested, should be something like:

Switch<INPIDetail.varQty

Case<INPIDetail.varQty, Less<decimal0>,

Minus<INPIDetail.varQty>,

INPIDetail.varQty>

Or am I missing something else?

Edit: I just validated this code’s syntax

[PXFormula( typeof(Switch<Case<Where<INPIDetail.varQty, Less<decimal0>>, Minus<INPIDetail.varQty>>, INPIDetail.varQty>), typeof(SumCalc<INPIHeaderExt.usrTotalAbsVarQty>) )]

Django
Captain II
570 replies
1 month ago
February 19, 2025

That looks about right. (Note, Minus is depreciated, use Subtract in the future).

So what that will do is:

Populate UsrAbsVarQty with the results of that first formula (the Switch). I know you said that you’re already populating this field properly - you won’t need to do that in code since you’re doing it by using the declaration.
It will update the header usrTotalAbsVarQty field with the net change of the UsrAbsVarQty field.

u662
Author
Freshman II
8 replies
Answer
1 month ago
February 20, 2025

Django wrote:

That looks about right. (Note, Minus is depreciated, use Subtract in the future).

So what that will do is:

Populate UsrAbsVarQty with the results of that first formula (the Switch). I know you said that you’re already populating this field properly - you won’t need to do that in code since you’re doing it by using the declaration.
It will update the header usrTotalAbsVarQty field with the net change of the UsrAbsVarQty field.

@Django In combination with a method override of RecalcTotals(), this worked.

Here is my final code:

INPIDetailExt.usrAbsVarQty

[PXDBQuantity()]
[PXUIField(DisplayName="Absolute Variance Quantity", Enabled = false)]
[PXFormula( typeof(Switch<Case<Where<INPIDetail.varQty, Less<decimal0>>, Minus<INPIDetail.varQty>>, INPIDetail.varQty>), typeof(SumCalc<INPIHeaderExt.usrTotalAbsVarQty>) )]

Code Editor: INPIReview (Physical Inventory Review)

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using PX.Common;
using PX.Data;
using PX.Data.BQL;
using PX.Data.BQL.Fluent;
using PX.Objects.CM;
using PX.Objects.Common.Extensions;
using PX.Objects.CS;
using PX.Objects.IN.PhysicalInventory;
using PX.Data.WorkflowAPI;
using PX.Objects;
using PX.Objects.IN;

namespace PX.Objects.IN
{
  //this is for the PI Review screen, where data can be entered manually line by line

  public class INPIReview_Extension : PXGraphExtension<PX.Objects.IN.INPIReview>
  {

    protected void _(Events.FieldUpdated<INPIDetail, INPIDetail.physicalQty> e)
    {
      var row = (INPIDetail)e.Row;

      if (row == null) return;

      decimal varianceQuantityVariable = (decimal)0.00;

      if(row.PhysicalQty != null && row.BookQty != null){
        varianceQuantityVariable = (decimal)(row.VarQty);//how variance quantity is initially determined
      }

      decimal absoluteVarianceQuantity = Math.Abs(varianceQuantityVariable);

      e.Cache.SetValueExt<INPIDetailExt.usrAbsVarQty>(row, absoluteVarianceQuantity);

      return;

    }

    #region Views
    [PXFilterable]
    [PXImport(typeof(INPIHeader))]
    public
      SelectFrom<INPIDetail>.
      Where<INPIDetail.FK.PIHeader.SameAsCurrent>.
      View PIDetailPure;
    #endregion

    public delegate void RecalcTotalsDelegate();
    [PXOverride]
    public void RecalcTotals(RecalcTotalsDelegate baseMethod)
    {
      baseMethod();

      INPIHeaderExt inpiHeaderExtVar = Base.PIHeaderInfo.Current.GetExtension<INPIHeaderExt>();
      decimal runningAbsVarianceTotal = 0m;

      foreach (INPIDetail detail in PIDetailPure.Select())
      {
        if (detail == null || detail.Status == INPIDetStatus.Skipped)
          continue;

        runningAbsVarianceTotal += Math.Abs(detail.VarQty ?? 0m);
      }

      var header = (INPIHeader)Base.PIHeader.Cache.Current;
      if (header != null)
      {
        inpiHeaderExtVar.UsrTotalAbsVarQty = runningAbsVarianceTotal;
        Base.PIHeader.Update(header);
      }
    }

  }
}

Chris Hackett
Acumatica Community Manager
2771 replies
1 month ago
February 20, 2025

Thank you for sharing your solution with the community @u662!

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*.

Reply

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

We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.

Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos

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.

Reply

Related topics

Email/notification for new build releasesicon

New! Acumatica Patches and Service Packs - No More Update Releases Starting 2025 R1

What you may have missed in the Acumatica Community! June, 2022

Management Eventicon

Ask a Question, Get an Answer - March 18 - March 22, 2024 - Need extra help this week!

Most helpful members this week

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings