Hiding cost total amounts in 9-5 Takeoffs
This functionality is only available if you have purchased the Estimating Add-On Module.
In business situations where certain amounts and totals must be hidden from view, Sage 100 Contractor provides the functionality to make sure that your company profit and margin information is kept private. Pressing the F7 key when your cursor is in almost any text box, list, check box, grid cell, or column opens the Field Properties window. Using the Field Properties window, a supervisor can set up the security in the 9-5 Takeoffs window to hide or reveal cost total amounts.
Important! The supervisor user may want to hide some of these items and reveal others, but to be able to view 9-5 Takeoffs from a cost-only perspective, all the items should be hidden.
Important! If a report contains a field that is restricted for a user, then that report is unavailable to that user.
To hide cost total amounts:
|
1
|
In the 9-5 Takeoffs window, click the Takeoff Details tab and do the following: |
|
a
|
In the grid, select the Ext Cost column, press F7, and set the security. |
|
b
|
Select the Cost column and press F7. |
|
c
|
Select the Formula column and press F7. |
|
d
|
Select the Sales Tax column and press F7. |
|
e
|
Select the O/H Rate column and press F7. |
|
f
|
Select the Overhead column and press F7. |
|
g
|
Select the Profit Rate column and press F7. |
|
h
|
Select the Profit column and press F7. |
|
2
|
Click the Insurance/Tax/Bonding tab and do the following: |
|
a
|
Under Liability Insurance, click in the Subcontract Amount cell, press F7, and set the security. |
|
b
|
Under Liability Insurance, click in the Payroll Amount cell, press F7, and set the security. |
|
3
|
Click the Bid Summary tab, click in the Gross Margin Override cell, press F7, and set the security. |
|
4
|
On the menu bar, point to Update, then Grid (or Takeoff), then Overhead/Profit by Cost Type. |
|
5
|
In the Overhead/Profit by Cost Type window, click in each cell in the Overhead % and Profit % columns, press F7, and set the security. |
|
6
|
Close the Overhead/Profit by Cost Type window. Do not update. |
|
7
|
In the Bid Items window grid, do the following: |
|
a
|
Click the Takeoff Details tab. |
|
b
|
Next to the Bid Items cell, click the detail button. |
|
c
|
Select the Overhead and Profit columns, press F7, and set the security. |
More resources
For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.
For additional training on Sage products, visit Sage University.