• Service Receivables 11 - 2 Work Order Costs

    I have a query written to show all work orders still in work order status (7). This is used to help us see what still needs to be billed. What I am wondering is if there is a way to get the cost incurred to pull into the query/report. If we go to each…
  • How to Use Query Input in a Calculated Field

    I want to show the beginning balance based on a starting date of a check date range in the report query. How would the value from the query field be used? Example: I want to show a running total of accrued vacation hours from each pay period. I need…
  • I need help creating a report that shows a user's activity for a given day.

    Good morning all! There are two users of our software, Me and Notme. Me is off on Tuesdays and has been finding errors in transactions that Notme has made in Me's absence. Currently, the only way for Me to find these goofs is to pull up a specific…
  • Custom Developer REferral for Sage 100 Contractor

    Can anyone refer me to a competent custom developer for Sage 100 Contractor? Sage referred us to "Zoom Geeks" to create a script to migrate our transactions from our old COA into our new COA with new departments. It's been almost 7 months and we don…
  • Bid vs actual

    We work with budgets, under over, and more, but what we really want is a way to compare a bid to the actual costs (after the job has closed). The objective: help our estimators see where they bid high or low on a particular item. I'm happy to write a…
  • Add the vendor name in the in A/P Invoices page.

    From 3-5, when you click on A/P Invoices, is does not have a column that list the vendor. Show hid has all the columns open. Is there a way to add the vendor name to this page. This helpful when going back to look up a payment from the job record.
  • Estimating - Assembly Formula with Operator?

    Is it possible to use an operator within an assembly formula? For example, I am building an assembly and for one part I would like to be able to use an "IF()Then()Else()" operator/statement. However, when I try that and calculate it in my takeoff it sees…