How to calculate original Subcontract amount?

​@Harry This AI generated answer hope its helpful

In Acumatica, the original subcontract amount can typically be found in one of the following ways:

1. Check the Commitments Module (Original Contract Amount)
Navigate to Projects → Transactions → Commitments (PM306000).
Locate the subcontract and look for the Original Commitment Amount.
The Revised Amount field will reflect any changes, while the original remains unchanged.
2. Review the Change Orders (If Applicable)
If the subcontract amount has been modified, check Project Change Orders (PM308000).
The Change Order History will show adjustments made to the subcontract.
3. Check the Vendor Contract (If Used)
If your company manages vendor contracts through AP Subcontracts, navigate to:
Accounts Payable → Vendor Contracts (AP305000)
Look for the original contract amount.
4. SQL Query to Retrieve the Original Ext Cost
If you have database access, run the following query:

sql
Copy
Edit
SELECT CommitmentID, OriginalAmount, RevisedAmount, ExtCost
FROM PMCommitment
WHERE CommitmentType = 'Subcontract'
AND CommitmentID = 'Your_Subcontract_ID';
This will return:

OriginalAmount (Initial agreed cost)
RevisedAmount (Modified total cost after changes)
ExtCost (Current dynamic value)

Thank you ​@Harry , for guidance.!!

Is there any sort of relationship between PMCommitment and the PO Tables? I built a general inquiry to report on Subcontracts and I can’t seem to figure out how to calculate the original subcontract amount. I think the only way is to subtract the change orders from the current amount? I just started working with Acumatica and building dashboards but have extensive experience with other construction ERPs and it seems really odd that the database doesn’t store the original subcontract amount in the Subcontract (PO Tables).