Browse By Tags

  • INFO: Sage can now supply Crystal Reports designer 2020 for Sage X3

    You can now conveniently download the latest Crystal Reports Designer 2020 for Sage X3 directly from our Sage X3 UK FTP Site. Previously this would need to be downloaded directly from the SAP website. For any licensing inquiries or questions, please…
  • Sage X3: Novo Crystal Reports Designer 2020 para X3

    Já se encontra disponível para download no portal mySage o Crystal Reports Designer 2020:
  • Crystal Reports Error - Saved data will be discarded/failed to compile

    Wondering if anyone can help me. Since the last upgrade I have been having this error anytime I open a Sage/Timberline CR Report "The saved data will be discarded since one of more formulas failed to compile I can create new reports without issue…
  • 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…
  • PTO shown on paystubs

    I would like to edit our current paystub to include available PTO hours, is there a way to make that happen? Thank you!
  • Change Company name on reports Sage 300 CRE Accounting 20.0.1

    Hello, Recently we have moved from a publicly listed company to a limited liability one and looking to change the name on sage reports .
  • Estimating reports into Power BI

    Hello, I’m new to Sage and looking to access estimates through Power BI. I’ve connected through ODBC, but I do not see how to get estimate information, only Database information. any ideas?
  • Crystal Report Hanging after Parameters have been entered

    Hi guys, so I am trying to add a crystal report to Sage 300 ERP however whenever I add same and run the report after entering the date range parameters, the report just freeze, wont load and also wont close when I try to close it. I've unchecked the…
  • How might you troubleshoot a report that returns an ERR 504?

    When you print a report in Sage Enterprise Management, you may be greeted with an ERR 504. Perhaps also related to a message "The system cannot find the path specified." The problem is that this is a very generic error and does not tell us what is really…
  • How can I preview a Sage Enterprise Management report inside of SAP Crystal Reports?

    Previewing a report to ensure proper formatting and correct results is smart. The ability for a report writer to preview a report within Crystal Reports designer can be a real time saver. In support, we are occasionally asked how to preview without…
  • How do I know what parameters are being passed to my Crystal report?

    If you are going to preview your report design inside of Crystal reports, you likely need to know what parameters you need to use during your preview. Not all parameter values come from user entry, some values are automatically sent by the supervisor…
  • How do I create or modify a Crystal report?

    I want to create or modify a Crystal report in Sage Business Cloud Enterprise Management (X3). This functionality changed as of Product Update 9. Be sure to review the Online help for Local Crystal Report development and for more specific details…
  • Total Billings

    Does anyone know the Formula that Timberline uses for its Total Billings and Total Billings YTD field?
  • RE: Crystal Formula for Purchase Orders

    FLAKj92, What do you mean by "doesn't work." This appears to work for me: if {podetail.poline} >1 and {podetail.job}<>{poheader.job} then "See Below" else {poheader.job} In my test, I did notice that Crystal makes an assumption on how the tables…
  • Report speed - do reports run on the server or locally?

    I am working on one Crystal and one RD report for Sage CRE. These are Job Cost reports using JC Transactions. The reports are very very slow to return information. The computer I am using is an older Windows XP model. Does the speed of the user…
  • RE: ODBC for Crystal

    Teresa, It could be the 32-bit ODBC Adminstrator. You can run it from C:\Windows\SysWOW64\odbcad32.exe. You may also want to review the knowledgebase article: Error: The setup routine for the Timberline Data ODBC driver could not be loaded due to…
  • RE: Crystal Reports - how to set up parameters in Sage CRE?

    SAP is the current ownder of Crystal reports. Sage 300 CRE used Crystal Reports XI. There are many resources available online. I did find the the user's guide which you may find helpful. Chapter 23 is parameter fields and prompts. http://help.sap…
  • Crystal Reports - how to set up parameters in Sage CRE?

    I have created a custom Crystal Report. It has three parameters related to dates and job status. The report runs in the Crystal application and I would like to make it available via the Sage CRE report list. I have added the new report with the filename…
  • Crystal Reports vs Report Designer

    I have several years of experience with Crystal Reports. I opened Report Designer today and it is totally alien to me. The first report I am working on is RD report. I made a copy and was surprised to find no undo function. Ordinarily I would think…
  • Report Designer - Design Formula does not show up in Conditions

    Greetings, I am following the instructions of KB186526 to create a Date Prompt on a JC report. I am able to create the prompt fields. I can make the design formula (using Accounting Date [JC Transaction] instead of Accounting Date [GL Transaction…
  • RE: Sage CRE My Assistant, Multiple Conditions with a Crystal Report

    Katie, I am glad that was helpful. It is tough to troubleshoot a report without seeing it and fully understanding what the report is designed to do. I am not sure what you mean by “breaks down again.” Troubleshooting report designs are beyond our typical…
  • RE: Sage CRE My Assistant, Multiple Conditions with a Crystal Report

    Katie, It helps me to think of the Sage MyAssistant condition and running the attached report as two completely different processes. The Sage MyAssistant condition does generate a set of results, but these results generated basically tell Sage MyAssistant…
  • Sage CRE My Assistant, Multiple Conditions with a Crystal Report

    I just began using My Assistant and it looks incredible. I am trying to set up a task that runs and emails a job costing Crystal Report. However, I want multiple conditions set. I've set them up in My Assistant and the test works exactly how it…