Use these references to understand how Spectrum change order values are imported into Trimble Pay.
AP subcontract change orders
| Spectrum field | Trimble Pay use |
|---|---|
Description | Change order description and change order item description |
Amount | Accounting line amount and change order item scheduled value |
Quantity | Unit quantity |
Amount and Quantity | Unit price, calculated as Amount รท Quantity and rounded to two decimal places when quantity is not zero |
Change_Request_Number | Change order item cost code and part of the integration identifier |
Company_Code, Job_Number, Subcontractor_Code, Subcontract_Number, Phase_Code, Cost_Type, Bid_Item_Code, Customer_Code, and Change_Request_Number | Combined integration identifier used to match the Spectrum record to the Trimble Pay change order and accounting line |
Note: If
Description is blank on an accounting line, Trimble Pay uses No Description Provided. If Amount is blank, the integration uses 0. A blank or zero Quantity does not produce a calculated unit price.Import Triggers
Trimble Pay takes action once the change order status in Spectrum is changed from and set to certain statuses.
| Status Change Event in Spectrum | Result in Trimble Pay |
|---|---|
Not Set Proposed | Nothing occurs. |
Not Set Executed | Change order is automatically imported into Trimble Pay. |
Proposed Executed | Change order is automatically imported if it doesn't already exist in Trimble Pay. |
Rejected Executed | |
Executed Proposed |
Trimble Pay's action depends on whether the already-imported change order has been billed against.
|
Executed Rejected | |
Proposed Rejected | Nothing occurs. |
Rejected Proposed |
Proposed