Amounts on the 6-1-7-21 Over/Under Billing report

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.

 

 




Related Solutions

Where does the contract amount on the 6-1-7 Over/Under Billings report come from?
Where do the numbers in the 6-1-7 31 Over/Under Billing report come from (extended version)

Solution Properties

Solution ID
223924350033371
Last Modified Date
Fri Aug 26 15:34:24 UTC 2022
Attributes
Product Details
Integrated Product: Chatbot
Views
0