Subcontractor Change Orders
Agave Sync allows you to export Autodesk Build Subcontract Change Orders to Sage 300 CRE JC Commitment Change Orders.
Visual Mapping
Common Errors
Unit Cost Mismatch
You may encounter an error like "Unit cost mismatch between contract line item 139200 and change order line item -8000.0000" when attempting to sync a Subcontract Change Order to Sage 300 CRE.
For context, Sage 300 CRE has two types of Commitments (i.e. Subcontracts or Purchase Orders):
- Lump Sum:
- Only amount fields exist on the Line Item. In other words, "unit cost" and "quantity" are not set.
- Subcontracts are typically Lump Sum Commitments.
- Unit Price:
- The amount is determined based on the "unit cost" multiplied by "quantity".
- Purchase Orders are typically Unit Price Commitments.
For Unit Price Commitments, Sage 300 CRE prohibits modifying the unit cost of an existing Subcontractor Change Order line item. Therefore, Agave Sync returns the "unit cost mismatch" error when you attempt to modify the unit cost for a Unit Price Commitment.
To resolve this error, you will either need to:
- Keep the same unit cost as the original Subcontract or Purchase Order and modify the quantity to match the amount, or
- Change the Subcontract or Purchase Order to be of type "Lump Sum" (so you can just modify the amount)