Summary
Where do the amounts come from on the 6-1-7-21 Over/Under Billing report in Sage 100 Contractor?
Resolution
Costs
The total of all open 6-3 Job Costs records. This number matches the 6-1-2-21 Job Cost Journal report.
Budget
The 6-2 Budget amounts, plus all 6-4-1 Change Orders on the Budget and Sub Change Details tab.
- A Status of 1-Approved appears in the header.
- A date appears in the Approved box.
NOTE: If the Budget and Sub Change Details lines relate to a subcontract change, set the Status column in that row to 1-Approved.
- The Budget is the actual costs when costs exceed the budget.
- % - The percentage determined by dividing the Costs value by the Budget value.
Contract
The value found in the 3-5 Job window's Contract box, plus all 6-4-1 Change Orders on the Prime Change Details tab.
- A Status of 1-Approved in the header.
- The date in the Approved box.
- A value in the Approved column.
Earned
The percentage in the % column multiplied by the amount in the Contract column.
Billed
The total amount of all 3-2 Receivable Invoices/Credits assigned to an Invoice Type of 1-Contract, minus any sales tax amounts.
Over/Under
Subtract the amount in the Billed column from the Earned column.