We are currently running 2021 R2 Construction Edition.
I was writing some Generic Inquiries to report on open Opportunities. Inspecting the “Total” field on the Opportunities CR304000 screen I found CROpportunity.TotalAmount as the value I wanted to report. The results looked erroneous and upon investigating I found the value being returned in the GI for CROpportunity.TotalAmount was NOT the value displayed in the Total field on the screen.
After further investigation I found the “Standard” (without Construction enabled) has CROpportunity.CuryProductsAmount in the Total field. Rewriting the GI I found this to be the value displayed on the Construction Edition screen as well.
Ran a quick GI to compare the values of TotalAmount and CuryProductsAmount and found many in disagreement, though the majority were the same. In all cases the CuryProductsAmount was confirmed correct while the TotalAmount could not be obviously derived from the supporting data.
What is supposed to differentiate these two totals?
Can I confidently use CuryProductsAmount for my reporting?
If not, is there a means to recalculate and correct the TotalAmount?