• Why is my custom report using "or" for the selection criteria?

    I have multiple selection criteria for my report but instead of pulling data that fits all selection criteria it is pulling in all data that fits any of them. I know there is a box that says enable or logic but it is not checked and even if I do check…
  • Is there any way to get a Union Benefit Report where I can select which benefit calculations I want under the paygroup?

    Our monthly union benefit payment is split and 9 of the benefit calculations get paid to one place and 3 get paid to another. As far as I can see the Union Reports (for ex. 5-1-7-31) total the benefits by paygroup and unfortunately the report is not modifiable…
  • Yr-to-date Gross Wage Calculation in Sage Contractor 100 Canadian Version

    How can I change the calculation for Yr-to-date Gross Wages on a pay stub to include Calculation Add ons? I've tried a few different calculations & modifications but can't seem to find the correct one, so on our pay stubs it's not reflecting the additional…
  • Sage 100 Contractor Canada Report Modifications

    We have purchased Sage 100 Contractor - Canada about a year ago. it was an upgrade from Sage 50. we had great support setting up Sage 100 and transferring our account information from Sage 50. the person used for this has since retired and we are…
  • reports affected by rptclc^clc in report forms and custom reports

    Custom reports and report forms in Sage 100 Contractor have been "infected" with this "field" rptclc^clc001, 002, etc. I have seen this before but not to this extent. It is massive. Has anyone else seen this before? Or know what causes this…
  • Favorite reports for T&M

    Hello, We've switched to a cost plus billing model and have struggled to find the "perfect" reports to present to clients to show the work completed. For those of you who also do so...what report version are you using for clients and do you show them…
  • Modify Accounts Payable Check Form (Template)

    When there are several check form designs with different bank accounts is there a way to review the check form designs (template) before printing to ensure the template with the correct bank account has been selected? In addition, I would like to…
  • Adding the "Reprint Check Stub" Checkbox to Custom Payroll Stub

    I have created a custom paycheck stub and everything works great except I can't find the reprint check stub checkbox to add the to the report. I started with a copy of the system report and modified it, but this option seems to have disappeared and I…
  • committed cost-developer

    Report 6-1-12-51 Committed Cost-Developer. How does this report for Developer differ from regular reports? There are asterisks after some items, but no description of what the * means.
  • Report Writer-How to Add "Task Name" to a Purchase Order

    Hello, i am trying to figure out how to add the task name to the purchase order. We have our system set up to export P.Os. by task but without the task name on the PO it makes it a bit difficult to determine what it is for. Any suggestions on what to…
  • custom report columns not lining up after update

    Hey Everyone, I updated to version 22.4.44.0 from version 19.8 recently. Everything was going well until I tried to run a custom form/report....My columns are all out of place could anyone give me some guidance please. Thank You!
  • General Ledger

    In December of 2020 two long term liability accounts were added however the store debit activity was not selected in set up. These two accounts are not being included in the balance sheet statement. Is there a way to manually put in the initial debit…
  • Sage Intelligent Reporting vs Liberty Reports

    I am a long time user of Sage 100 Contractor (formerly Master Builder). I need more flexibility in data reporting from the system. I have read that Sage Intelligence Reporting and Liberty Reports are two add-in options. If you have experience with either…
  • error system.OutofMemoryException creating report in Report Writer

    Error: Knowledgebase article says: "Error: Exception of type System.OutOfMemoryException was thrown running the 6-1-2 report (version 19 and earlier) Enhance export to MS Excel engine Exception of type System.OutofMemoryException was thrown Job…
  • Placing form footer on last page of AR Invoices automatically

    We sometimes have multi page AR invoices. Prior to my joining the company, reports for specific number of pages were created so our terms and total print on the last page.I'm making some changes that will result in having different invoices for different…
  • Service Receivables 11-1-2-61 Profitability Report not finding any cost data

    Service Receivables 11-1-2-61 Profitability Report not finding any cost data for material, labor, other, total cost. They all show as blank. Has the srvinv database been changed?
  • Report Writer decimal points

    If I want to change the number of decimals reported in a calculated field, how would I do that?
  • Problem with Update 19.8 and Custom Reports?

    My client has used a custom report for all of 2016, then after updating to v19.8 the report is a mess. Some columns missing. Some Totals are weird. Anyone had this happen yet?
  • RE: Report Writer Help

    (just saw your request) If you still need this, open your printer screen from your report in the 6-11-3-xx menu, click on "modify report", then click on the "define calc fields" button, then click on "select Global Calculations". Inside there…
  • Customer Aging Reports

    Currently Sage 100 Contractor does not offer a customer aging that combines job and service receivables. Has anyone had success at creating a report to accomplish this?
  • RE: Expense vs. Budget Reporting: Does anyone have a custom Income Statement Report with SubAccount Detail Actual/ Budget?

    We have found a consultant who specializes in building custom Sage Reports. We have submitted the request for the report "Income Statement Budget vs Actual with Subaccount Detail." You can contact me directly for more information.
  • Expense vs. Budget Reporting: Does anyone have a custom Income Statement Report with SubAccount Detail Actual/ Budget?

    Hi, We are working with Sage 100 Contractor. We are using Subaccounts in our General Ledger. We want an Income Summary with Subaccount Detail Actual/ Budget report. Currently S100 has an Income Summary with Subaccount detail Actual/ Income, but no option…