• Edit Reports with full version of Crystal Reports

    I already own Crystal Reports. Is there a way to edit the Crystal Reports from Sage with my existing license and not purchasing the Sage version of Crystal Reports?
  • Sage 300 CRE GL system has a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting

    Can we create a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting?
  • Customer viewable notes not appearing in purchase orders / Service Management

    About 4 days ago (11/17/22) , suddenly the customer viewable notes on our purchase orders stopped appearing. The "Customer Viewable" box is *definitely checked. Has anyone else experienced this or found the solution? Thanks
  • Can you use Crystal Reports to change the value of fields in Sage 300 CRE...?

    If this is not possible what would the best way to accomplish this? I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not. Thanks V
  • Bank account created in CM is not showing in AP when trying to generate crystal reports.

    We have created a new bank account in CM module and the transactions are correct going but when trying to generate crystal report in AP module the particular bank name is not listed.The CM and AP module details and not sync. In order to generate crystal…
  • Crystal Report Design

    Hello Community, We are looking to contract someone for assistance with Crystal Rport Design. Specifically we have a template that wer would like to add an additional column. Please respond if interested. Best,
  • What table in the DB has all the Job Setup Change Management information

    What table in the DB has all the Job Setup Change Management information - looking for the table that has the markup grid
  • Failed to retrieve data from database error coming when try to generate a report

    Dear team , When trying to generate a payment voucher using crystal report ,following error obtained.
  • Cheque printer changed

    Dear team, We are recently change the printer for cheques to a latest printer . We were using HP Laserjet P1102 and we purchased a new Laerjet 107 W . But when we print the cheque , each time i have to edit the report according to values in the…
  • When I bill on my AIA form and print my numbers are NOT transferring down. Still showing up on the balance to finish.

    I was on the phone with sage for an hour and half....IF anyone has an idea let me know. 20210219154500546.pdf .
  • Crystal Report Formulas

    Employee Emp Name Per Begin Date Period End Date Fringe ID Amount Deduction ID Amount 1001 Jackson, One 1/4/2021 1/10/2021 MEDEMP $ 220.00 MED01 $ 95.00 1003 Jackson, Three 1/4/2021 1/10/2021 MEDEMP…
  • Custom Crystal Report printing differently

    We use a custom crystal report for our AIA type billing. Previously the items in the ITEM NO. column printed in the order that they appear in the Contract (which is correct). Recently certain items are printing seemingly randomly out of order. We did…
  • Attached crystal report on a MyAssistant task, on the email tab, does not deliver the same results as when running the crystal report on its own.

    I attached a crystal report in MyAssistant on the email tab so I could use the Report Options to send it as an Excel file to a saved location for an outside vendor. There is a formula in the Crystal report to only pull for active jobs. However, the report…
  • PJ Field Reports Labor Table Fields using ODBC

    I'm trying to pull records from the PJ Field Reports Labor Table in Crystal but I'm unable to figure out how the employee is being linked. Does anyone know what table is being used to link the employee to the PJ Field Reports Labor table?
  • Dashboard/Crystal Reports Commercial Contractor

    I am in need of some assistance. I am trying to pull reports from Crystal. I am able to pull a payables report and can pull job cost detail report. The problem I am having is that I can not pull any report with the arm. file as we do not have the AR module…
  • Crystal Report for Quick Bill Invoice with Subtotals

    I use a crystal report for our quick bill invoices. I need to add subtotals to the invoice. There will usually be 4-5 subtotals throughout the invoice. In quick bill, I have inserted the subtotals. However, in crystal reports, I can't get the total invoice…
  • Customer Crystal Report Date Parameter Wrong on 1/4 computer

    I have a custom Crystal Report that I created and when entering the same date parameter on 4 computers, one will show the wrong information. Example: 09/01/2019 - 09/20/2019 (September 1, 2019 - September 20, 2019) 3 computers bring up the same correct…
  • Crystal Reports - Linking tables from Timberline SM Data to Timberline Data Source - one table has a prefix while other does not

    I am trying to create a crystal report which will allow me to reprint a batch of open/unpaid SM invoices using information from two different tables, one from the Timberline SM Data and the other from the Timberline Data Source. I have one table in…
  • Crystal Reports

    How do I get Crystal Reports? Is it an added software/cost?
  • Non Sage DB Report within Sage 300 CRE

    I have created a data warehouse database within the Sage 300 CRE SQL replicated databases to merge some of the data from both Timberline and Timberscan for reporting. I have been able to write the Crystal Report and have it work when previewing from with…
  • Issue with Running a Crystal Report -- Error Message

    I am having an issue with a Crystal Report that I have pulling the data from the SQL replicated data. The data pulls when I run the report in both Crystal Reports and also when I run from within Sage from any of our companies. Upon having a user try and…
  • Using tsRange function to pull Commitment numbers

    Is there a way to use the tsRange function in Crystal to pull Commitment Numbers like we do Job Number. I can easily pull Job range - I tried similar setup trying to get commitment but could not make it work. Anyone ever done this?
  • Crystal Reports

    FormerMember
    FormerMember
    We are looking to implement Crystal Reports with Sage 100 Contractor. We are running on MS SQL V2016 SP1. Which version have you found that will best connect?
  • Where are formulas being used

    I am trying to find out if there is a PSQL query or a report that I can run that will show me where formulas are being used - or if they are. So, if a formula is being used, is it used in another formula, report, etc. I have 100's of formulas & reports…
  • Cash flow statement based on budget

    I am looking for a cash flow statement that can be ran based off budget numbers entered into Sage 100C. I realize that this would be a custom report and would need criteria entered, ie AR & AP turnover, etc. Looking for ideas, a report writer, or utility…