Skip to main content
Solved

PXFormula not updating when relevant fields are updated in Modern UI

  • July 22, 2026
  • 3 replies
  • 44 views
D
Captain II
Forum|alt.badge.img+8

I have a dozen fields on a form that have cascading PXFormulas to calculate other field values automatically. For example:

Base Price

Commission Rate

Commission Value (PXFormula of [Base Price] times [Commission Rate]

House Comm. Split Rate

House Commission (PXFormula of [Base Price] times [House Comm. Split Rate])

Everything calculates correctly when the record is saved but Classic UI updates these fields right away.

The post below also talks about this but the solution there was to change all of the PXFormulas to  PXDBScalars but I’m not sure that this is appropriate as I’m storing all of these values.

Is there something I need to write in the .ts file to trigger the PXFormulas or do I need to make each field use PXFieldState<PXFieldOptions.CommitChanges> and write out all of the formulas in Updated events?

Best answer by darylbowman

Have you tried just making the dependent fields commit changes?

3 replies

darylbowman
Captain II
Forum|alt.badge.img+17

Have you tried just making the dependent fields commit changes?

Daryl ⚡Freelance developer 🛒Check out my products 👉🏻deftstrokesdev.com/index.php/products ⏩linkedin.com/in/darylbowman
    T
    Varsity I
    Forum|alt.badge.img

    Hii ​@Django , the happens when the commit changes = True is missing while configuring the ts and html for modern UI.

    So when the commit changes happens the request goes to the server and the expected field which need to be update will update successfully,

    Plzz try this and let me know

      D
      Captain II
      Forum|alt.badge.img+8
      • Django
      • Author
      • Captain II
      • July 22, 2026

      Thank you both ​@darylbowman and ​@tareshpatil51 - it looks like adding PXFieldOptions.CommitChanges in the .ts file to all of the fields references in the PXFormulas has solved it.

        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