x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 5 replies
  • Subscribers 240 subscribers
  • Views 2920 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
443
replies
Ronnie22

Add unit cost & cost per columns to the Cost Spreadsheet (by Date) in Report Designer

SOLVED
Posted By

I have a question about Sage 300 Construction and Real Estate.  I'm trying add columns for unit cost and cost per unit to the Cost Spreadsheet (by Date Range) from Job Cost inside of Report Designer.  Does anyone know what the formulas would be for these 2 columns?  I will need to add these 2 columns for each of the categories listed which are {Total Est, Total Cost} & {Labor Est., Labor Cost} & {Material Est., Material Cost} & {Equipment Est, Equipment Cost} & so on.  If someone can help me out with the formulas for one of the categories that will get me started and maybe I can use those to come up with the rest of them. Thanks in advance!

Parents
  • 0
    verified answer

    For the Labor Estimate:  Copy the existing design formula named "Total Labor Estimate" and name the copy "Total Labor Est Units" as the new formula.  Change the new design formula "Total Labor Est Units" by changing Amount (JC Transactions) to Units (JC Transactions) =this is at the end of the formula.  Then create a new formula named "Unit Cost per Est" which will be Total Labor Estimate (design formula) / Total Labor Est Units (design formula).  I think this will work for each category such that copying existing formula and changing the "amount" to "units" in JC Transactions and then dividing the 'amount formula' by the new 'units formula' you will have the unit cost and/or cost per unit.  

  • 0 in reply to Rhonda V

    Thanks so much! This seems to work great!  

    Can you help me with the other issue we are having?

    We estimate labor for each item based on the unit description cost (ex. Square Yard, Acre, etc.) NOT per hour.  However, we pay employees per hour NOT "Square Yard".  How can I make the conversion from "hours" to "Square Yard" / etc.?

  • 0 in reply to Ronnie22

    Glad you got this fixed up !

    I'd recommend starting another post for your next question. That way other users see it as a pending post rather than nested within this one as answered.

    Thanks!

Reply Children
No Data

*Community Hub is the new name for Sage City