Browse By Tags

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