Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Created a report comparing Revised Estimated Cost to Actual Cost. The "sum" of the Revised Estimated Cost is giving me problems. When I try to "Sum" that field, it totals by the number of times the cost code is used...therefore the "sum" becomes overstated…
Hi there,
Trying to recreate a report from legacy job cost with new job cost and not able to duplicate a formula.
Old Legacy formula: if Sum ({JC1_JobMaster.JTDInvoiceBilled})=0 then 0 else (Sum ({@JTD Gross Profit})/Sum ({JC1_JobMaster.JTDInvoiceBilled…
We have been looking for a report that will show the total job cost including labor cost at the marked up rate and contractor's fee for bid and time & materials jobs. Is there a report that will show those numbers? The only ones I have been able to find…
