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