• Need help with a select statement for adding total sales to job cost journal?

    I'm new to S100C and report modifying so not sure if this is even possible but I am trying to add just a total AR invoice amount to the bottom of the modified job cost journal and it's not working. I have tried many versions of SELECT statements but can…
  • 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…
  • Prelien & unconditional & conditional releases

    Can I send or print Prelien & unconditional & conditional releases directly out of Sage 100C?
  • A/R Invoice numbering

    How do I change the default numbering for the A/R invoicing. I need to change the numbering and then have the next invoice be a sequential (next) number. I cannot find how to make this change.
  • Using SQL queries in a calculated field (report writer)

    Hello - I am struggling with the report writer and need some clarification (a long shot, since there is almost 0 documentation on the subject). I am proficient in T-SQL, so am confident in my ability to write queries, but can't get something very simple…
  • Progress Billing-Line Item Description is too short

    I am in menu 3-7, and am unable to see the complete description of the Line item when the continuation sheet is printed. We have a very particular client that needs everything spelled out and nothing abbreviated and therefore need the entire description…
  • How to remove automated email reports

    Good day, I have a job cost report for several projects that was set up to auto email every week to my email. We have long since completed these jobs and moved on to new jobs. I have two questions: 1. How do I remove the old job automated report emails…
  • 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…
  • Cost codes for GL accounts on Purchase Orders

    Hi there, we have been able to add the job cost code to purchase orders. Is it possible to do this also with overhead costs and have a General ledger account shown on the purchase order?
  • 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…
  • Report Design: Report detail area (gray box) ghosting (duplicating itself) in report

    What caused, or how can I prevent, the gray box (report detail area) in the report form from duplicating itself (ghosting), usually in the bottom right side of the report when the report is run. First thought is there is another gray box, even just a…
  • 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…
  • Modifying default report forms

    My company operates 4 different Sage 100 Contractor companies, with different tax ids and and banks and logos and entity names. I'd like to customize the default system report and landscape report forms to get our branding on them, reduce our color print…
  • can in-list be used with {variable[N]}?

    In Report Writer, Sage 100 Contractor, is there a way to use the selection criteria "in list" with a variable like {variable[N]}? In this case, I am using {Job Number[N]} to select Job Number in SQL statement where job number is not in the Primary Table…
  • Translate internal cost code to client cost code for billing

    Hello All, We are new to Sage and are wondering if anyone here has tried to and successfully implemented converting your Internal Cost codes to the cost codes a client wants for invoicing. I think that it's possible via coding a report to translate…
  • Selecting null values with report criteria

    I'm trying to build a report that will allow me to select job costs for a list of jobs that have no work order assigned. How do I set the criteria to select null values?
  • 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…
  • Sage 100 Contractor Sql in Report Writer

    FormerMember
    FormerMember
    Does anyone know where I could find information for the syntax that Sage 100 Contractor report writer requires with respect to SQL. I am trying to write a report for Committed Costs that is different from the report included with Sage, so I need to write…
  • Shared report not working on other computers

    I created a report (in the 11-1-2 group). It is labeled as a [shared] report. The report runs fine on my computer. But on another computer in the office, the report will run, but the data for each individual work order on the report is coming in blank…
  • Report Writer Percent (%) sign in number format

    Is there a way to add a % sign to a calculated number in the Report Writer? I know how to just add a % to the report as a text field, but that's ugly because the spacing is bad, and I won't want the % to show up when there is no number calculated at all…
  • Report Writer decimal points

    If I want to change the number of decimals reported in a calculated field, how would I do that?
  • 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…
  • Delete report created with Report Writer

    I created a test report using the Report Writer and I can't find a way to delete it. Is there a way? Thanks