x Want to participate? Join the group to interact

  • Crystal and special tsar functions

    In the users guide there are these functions for AR but it does not tell us exactly what they are doing and how it is determining it. In the AR Statement (CR) uses these functions, but i am getting some strange answers. I believe it has to do with the…

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

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

*Community Hub is the new name for Sage City