Skip to main content
Solved

Can an attribute field be mapped to a GI and auto updated with the GI field changes?


dougmcbride79
Semi-Pro I
Forum|alt.badge.img

Can an attribute field be mapped to a GI and auto updated with the GI field changes?  We want to use “calculating columns” in a GI and then have the calculated amount auto-updated to an attribute field.  Is this possible? 

Best answer by Brian Stevens

Like Naveen, I’m not sure if this is possible or a preferred method.  User Defined Fields (a relatively recent low code/no code enhancement) leverages attributes to add a field to certain screens, which would be available to all records presented by the screen.  More traditional attributes, i.e. those attached to various classes, are subject to change by class and therefore a little messy to maintain for all possible classes of an object such as items or vendors.

I don’t know if you are a developer or have access to a developer resource, but you might define a custom field (i.e. UsrXXMyCustomCalc) and use a PXForumla attribute to populate it.  In some use cases, you might be able to get by with an unbound (not in the database) field, but some use cases require a bound field so the underlying SQL statement generated by Acumatica can retrieve the value in cases where business logic is not yet applied.

An old but good post showing some possibilities with PXFormula can be found asiablog.acumatica.com.  You also can find help on PXFormula by searching help for PXFormula or Calculation of Field Values.

 

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

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • July 26, 2021

@dougmcbride79   I don’t think it is possible in standard Acumatica GI.


Forum|alt.badge.img+4

Like Naveen, I’m not sure if this is possible or a preferred method.  User Defined Fields (a relatively recent low code/no code enhancement) leverages attributes to add a field to certain screens, which would be available to all records presented by the screen.  More traditional attributes, i.e. those attached to various classes, are subject to change by class and therefore a little messy to maintain for all possible classes of an object such as items or vendors.

I don’t know if you are a developer or have access to a developer resource, but you might define a custom field (i.e. UsrXXMyCustomCalc) and use a PXForumla attribute to populate it.  In some use cases, you might be able to get by with an unbound (not in the database) field, but some use cases require a bound field so the underlying SQL statement generated by Acumatica can retrieve the value in cases where business logic is not yet applied.

An old but good post showing some possibilities with PXFormula can be found asiablog.acumatica.com.  You also can find help on PXFormula by searching help for PXFormula or Calculation of Field Values.

 


dougmcbride79
Semi-Pro I
Forum|alt.badge.img
  • Author
  • Semi-Pro I
  • 194 replies
  • July 26, 2021

Thank you.  I greatly appreciate your help. 


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