Sage 100

We use Sage 100 Contractor and bill Cost plus (T&M). We have always charged a "profit" percentage on Cost Type 2 - Labor, which is easily done in 3-10-1. But now, we want to remove the "profit" percentage on some of our labor, but not all, based on…

I want an account to start requiring job numbers when paying per-diem. Can I not change an established general ledger account to start requiring that?

I needed a comment in Time Track Entry for work performed. I added a UDF and was able to post that through to the Job Transaction file in Job Cost. How can I get this to pull into Job Cost billing so it can print on the invoice? I can't find any way to…

I would like to see the Job Name, in addition to the Job Number, for each invoice, on my AR Aging Report. Using UDF links and customize the Crystal AR Aging Report.

Is it possible to move tab 6 (invoices) in customer maintenance over to its own tab in Job Maintenance? Where to start with accomplishing this? Users are just tired of needing to open 5 or 6 modules every morning and keep them up all day, so we're looking…

Is there anyone out there that has turned on calculating and maintaining retention in Job Cost and AR? Crediting IN invoices that are total retention and creating a RT invoice. Just getting started. I was looking for any help...trying to be pro…

Hello! Hopefully someone can help with this. We have a client who wants to use Estimates in the Job Cost module. We have created some UDF's on the Estimate Detail table to allow them to add in needed informaiton that they will be prinitng on their paperwork…

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 would like to use Job Cost Retention in Sage 100 Premium 2021, but currently Sage does not support the Bill-To/Sold-To (BT/ST) feature within Job Cost (which we need because all our jobs requiring Retention bill to a GC or third party). Adding Job…

I received this error in Accounts Receivable module and I cannot seem to find any knowledgebase article that directs me on how to remedy this. Anyone else had this issue? In this instance, all batches are closed and none are outstanding in the Invoice…

We received a $ refund from a deposit we made on a water meter. We originally coded the full cost of the meter to a job. How do I record the cash refund we received back to our checking account & also credit the job cost the amount of the refund? Thank…

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…

With different frequency, but frequent enough to be a nuisance, especially when involving millions of dollars, the Original and Revised contract amounts get out of balance. Since it cannot be tracked easily, I'm wondering whether anyone has run into this…

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…

We have a couple of jobs in our job cost module that will not purge to history when we period end. We did our job close out report which changed the status to closed. They then however, will not purge to history when we period end process at month end…

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…

On the new version of Sage 100 2020 with Payroll, They are purchasing Job cost too. We will be enabling Time Track. Do I need to also purchase Time Card?

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…

So there seems to be no way to actually integrate Sales Order using inventory with Job Cost and end up with all costs on the job. You can either integrate inventory (so you see what is required for Sales Orders) OR you can post costs to Job Cost, but…

I'm creating a Crystal report and wanting only Job Billing History for a specific year. Currently using the selection {JC_Job.LastBillDate} in Date (2020, 01, 01) to Date (2020, 12, 31), but it is still including 2019 and earlier invoices?

Had a Crystal report using the JTDActualCosts and JTDInvoiceBilled fields from the JC1 data file. Recently upgraded to 2018 and the JC data file no longer has these fields. Where can I find them?

I am very new to Sage 100 and I do not really have someone to train me on how to use this software efficiently. My question is on job costing for payroll. Is there a setting that will allow the employees to have access to enter their time sheets without…

We recently switched from Sage 50 to Sage 100. Job Billing Data Entry is supposed to be pulling in the material cost and adding our Markup but it doesn't pull the correct cost. On one job our Material Cost was $38.00 and it pulled in $88.00. Any idea…

End user need Vendor Code on invoice need to look in JC_JobTransactionDetail. Where can if find a list of what is in that file?

We have a client that wants to revise some of their Cost Codes in Job Cost to make the numbering consistent. Anyone know of a way to 'renumber' Cost Codes? Any suggested work around or 3rd Party utility? We can't find any way to change existing Cost Codes…