Sage 100

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…

I'm converting some old Crystal reports from Sage 100 v2017 to v2019. The reports from v2017 use the tables: PR_22PerpetChkHistoryHeader and PR_23PerptHistoryDetail These tables don't exist in v2019. What table(s) should I use in their place? I tried…

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…

Deductions are automatically calculated but at times when an employee is on vacation, deductions are not calculated for that week for that employee. They are entered manually next pay period in addition to the automatically calculated deductions. What…