• Job post to COGS when invoiced and not to WIP

    When issuing an invoice to a customer with an inventory item it is coming out of inventory and into COGS. Then when the project is closed out, the same dollar amount is coming out of WIP and into COGS. This makes my WIP account negative, and my COGS duplicated…
  • NO profit on SOME labor

    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…
  • General Ledger Accounts

    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?
  • UDF in Time Track that can get to Job Cost billing

    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…
  • Pass a Job Name to AR Aging Wrk using UDF?

    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.
  • Copy tab 6 from customer maintenance to Job Maintenance panel in its own tab

    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…
  • switching to calculating retention on jobs in mid-stream

    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…
  • The Cost Code is required mesage when editing UDF's on Estimate Lines

    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…
  • Job cost revised estimate in a crystal report

    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…
  • Job Cost Retention Invoicing while using BT/ST

    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…
  • "This option cannot be changed while A/R Invoice Entry is in process"

    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…
  • How do we enter/record Cash Deposit to checking account & credit job cost/cost code? (Sage 100)

    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…
  • Time Track Report Combining Current and History

    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…
  • Original/Revised Contract Amount Discrepancy

    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…
  • JC1_JobMasterfile fields in legacy versus JC_Job in updated 4.0 Standard (reviewing in V2019)

    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…
  • Jobs not closing in Job Cost

    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…
  • Cost Code Profitability report

    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…
  • Do I need to include Time Card Module when purchasing new version sage 100 2020 if they are buying Complete bundle plus Job Cost? They want to use Time Track.

    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?
  • Certified Payroll Report - Time Track and Payroll

    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…
  • Integrating with Sales Order

    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…
  • Job Cost billing history

    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?
  • Job Cost JTD data fields

    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?
  • Payroll

    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…
  • Job Billing not pulling the correct Material Cost

    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…
  • Where can i find details for what is in JC_job Transaction Detail?

    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?