Skip to main content
Solved

Project Quote Not Calculating Total Sales (curyamount)

  • 15 November 2022
  • 4 replies
  • 102 views

NickCerri4
Freshman II
Forum|alt.badge.img

Hey, everyone - It doesn’t appear that the “Total Sales” field is calculating in Project quotes, despite being values in the “Ext. Price” and “Amount” columns.  This doesn’t appear to be an issue with hand-keying items line by line.  However, our estimates are fairly sophisticated and large and our estimating team will be making frequent use of the Load Records from File button and it only seems to be an issue when data is loaded in this way.  Is anyone aware of this happening either specifically or in a related way?  In full disclosure, I did customize fields on the screen but only by changing their display names and requirement status.  If you have any insight please advise.  Thank you!

 

 

Best answer by Julia Lukina

@nickcerriIV, this is already fixed in 2021R219, 2022R115, 2022R205 and later builds. As a workaround on earlier builds you can try to do the following :

  1. import data from excel
  2. add 1 line manually 
  3. check that the system recalculated Total Sales amount and then remove that manual line. 
View original
Did this topic help you find an answer to your question?

4 replies

Julia Lukina
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • 48 replies
  • November 21, 2022

Hello @nickcerriIV, what version do you use?


NickCerri4
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • 17 replies
  • November 21, 2022

Hello @Julia Lukina , we’re running 2021 R2


Julia Lukina
Acumatica Employee
Forum|alt.badge.img+1
  • Acumatica Employee
  • 48 replies
  • Answer
  • November 21, 2022

@nickcerriIV, this is already fixed in 2021R219, 2022R115, 2022R205 and later builds. As a workaround on earlier builds you can try to do the following :

  1. import data from excel
  2. add 1 line manually 
  3. check that the system recalculated Total Sales amount and then remove that manual line. 

NickCerri4
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • 17 replies
  • November 21, 2022

@Julia Lukina Thank you.  I found that the workaround you suggest seems to work IIF I include price and cost information (i.e. ext. price and ext. cost - it can’t just be price).  This seems to “jog” the system into calculating.  Much appreciated!


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