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

  • 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 $   221.00 MED02 $   96.00
  • 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 Timberline…

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

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

  • Crystal Reports in Sage 300 14.1 - Print Setup - choosing 'current page' does not print actual current page if changed

    We have a large JC report that shows the different jobs on the left which correspond to different pages in the report.

    In the old Sage 300 13.1 you could choose print preview and choose "current page" and the print the current page selected.…

  • How is the Subcontractor Contact List generated?

    I need to know where is the information pulled to create the Subcontractor Contact List in Project Management? {PM -> Reports -> Job Contact Lists -> Subcontractor List} I have found that even if the vendors/subcontractors are listed when the job is set…

  • RE: Retrieving audit trail info on employee record changes (Crystal Reports)


    Unfortunately, in this case, the log will only show that a user went into the employee setup. It will not return that a direct deposit id was added or that a routing number / account number was changed.

    For a report,  if you use prenotes, you…

  • Retrieving audit trail info on employee record changes (Crystal Reports)

    For security purposes I am setting up reports that will show employees hired in the last week and direct deposits that were changed in the last week.

    I have a few questions:

    1.  Is the identity of the user who added an employee available?

    2.  Is the identity…

  • RE: MyAssistant - attached Crystal Report fails to deliver


    There is a knowledgebase article, ID: 20321, Troubleshoot Crystal attachments missing from emails. I would say the most common causes that I see are #1 the ISDAdminSenderService needs to logon as a specific Windows user and #4 file locations…

  • MyAssistant - attached Crystal Report fails to deliver

    I am setting up MyAssistant with a new Send a Report task.

    I can attach a PDF, Text, or other document to the Email portion and the email sends successfully.

    However, when I attach a simple two-parameter Crystal Report and manually run the task, an email…

  • Total Billings

    Does anyone know the Formula that Timberline uses for its Total Billings and Total Billings YTD field?

  • AR To GL Link

    Can anyone tell me what the relationship is between the GL Current Transaction and the ART Current Transaction?