Skip to main content
Solved

Will updating the extended price/cost calculate the unit price/cost?

  • Apr 21, 2023 7:32 PM UTC
  • 5 replies
  • 509 views
  • Translate All
Jr Varsity II
Forum|alt.badge.img

Hi all,

I was wondering if there is a way to get the system to calculate the unit price/cost by updating the ext price/cost

Updating the Unit Price to $700 calculated the Ext. Price to $4,200
However, updating the Ext. Price did not automatically update the Unit Price

Is it possible for this to happen?

Thanks

Best answer by jinin

Hi @aidenwills15 ,

By default, Acumatica does not support the feature of updating the unit price while updating the ext price. Therefore, we need to do a small customization to support this functionality.

 

View original

    5 replies

    jinin
    Pro I
    Forum|alt.badge.img+12
    • jinin
    • Pro I
    • Answer
    • Apr 24, 2023 4:41 AM UTC

    Hi @aidenwills15 ,

    By default, Acumatica does not support the feature of updating the unit price while updating the ext price. Therefore, we need to do a small customization to support this functionality.

     

    Translate
    Jini N
      aaghaei
      Captain II
      Forum|alt.badge.img+11
      • aaghaei
      • Captain II
      • Apr 24, 2023 5:47 AM UTC

      @aidenwills15 If you do not want to proceed with Customization, the alternative option will be setting the View Only permission (Select) for Extended Cost. This way the users always have to enter Qty and Unit Price and the Ext Cost will be calculated accordingly. Of course, @jinin suggestion also is another option if you require a back calc of the unit rate from Ext cost. 

      Translate
      Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
        Jr Varsity II
        Forum|alt.badge.img
        • aidenwills15
        • Author
        • Jr Varsity II
        • Apr 24, 2023 1:12 PM UTC

        @jinin @aaghaei I see, thank you both for the answer.

        Translate
          dgodsill97
          Varsity II
          Forum|alt.badge.img+6
          • dgodsill97
          • Varsity II
          • Jun 19, 2024 3:45 PM UTC

          This is bug because you can create a disparity between the Ext. Cost and Unit Cost.

           

          Translate
            kgartly09
            Jr Varsity III
            Forum|alt.badge.img+1
            • kgartly09
            • Jr Varsity III
            • Jul 31, 2025 5:45 PM UTC

            I am with Dennis on this - it is a bug that should be fixed.  Either do not allow the Ext. Price to be changed, or if you do, then back calculate the unit price when changed.  The current behavior makes no sense.

            Translate
              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