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…

We have a client that needs to run a Time Track Report by job number that includes time track entries for a month were some have not been updated along with some that have been moved to the history file. Has anyone come up with a way to combine the two…

I'm looking for the following fields in a file in the V2019 job cost. In legacy, they were included in the JC1 file. I'm hoping I missed them when I attempted to find them in V2019. Can anyone assist? They are not in the new JC_Job file in V2019. PTDActualCost…

Trying to find a way to get a report or create a report in crystal that shows profitability by cost code. It seems every profit type report is by job. I see there's the job cost detail report and you can add the billing amount but it doesn't seem to be…

We have a client that is converting from Sage 2017 to Sage 2020. They do not own the Time Card module, but did have a Union Automation enhancement from Kissinger. They will still use that enhancement in the new version. DO they have to purchase and set…

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…

I have negative time from a time track entry that is not updating and showing on the job transaction detail report, has anyone had this issue and if so can you let me know how to fix?

Trying to convert a Job Cost report from pre-2018 to 2018. The file uses a subreport to get the employee information for a LABOR posting (not done through TimeCard/TimeTracker). The employee information is parsed from the Comment field in the JC Detail…

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…