• Error Message with a Crystal Report

    We have attempted to add an optional field from ORORDDO to the picking ticket. If we run on the server, the report runs fine, but when we run on a workstation we get this error: Failed to retrieve data from the database. Has anyone seen this issue and…
  • Error printing custom report: Culture not supported

    We're printing a custom report (PJC) built using Crystal Report 16 and running Sage300 Premium v7.0 2023 How can we resolve the error below?
  • Sage 300 check customization

    Hi Team Is possible to create a QRCode with (check number, date, customer name and amount) information to make it easy to index and store in a document management system? Any idea ? Melvin
  • sales tax issue - Double counting items as two different classes

    2020 year's sales tax was easy. I just ran the tax tracking report for the relevant fiscal periods and sort by tax class, which for us is 1 for taxable items and 2 for non-taxable. But this year, the same report for both this year and last double counts…
  • F/S by department

    Hi there, What FR function should I use in order to create a report showing department side by side? Also, is there a way to combine two departments? Thanks, Zia
  • Sage 300 financial reporter

    Hi there, Can someone help me out an FR function here. I am new to the FR designer. I am using a report template that was created before me, function is below, but it returns the date format like 5/31/2021 =FR("PERIOD")&" Months Ended "&FR("END…
  • Error Web UI, Sage 300

    I get an error message when opening the COA report using the Web UI, can anyone help me?
  • Crystal Reports "Unspecified Error"

    This is not a question, just information: Recently, Crystal Reports started giving message "Unspecified Error" on certain reports, after working fine for many years. I have determined that there is suddenly an issue between Sage 300 desktop and Crystal…
  • custom report for web screens

    Hi, we have a customized order confirmation form. i added to the webscreens reports. it prints fine but the parameter prompt does not allow you to search or select options such as check delivery method. values must be entered. any help resolving this…
  • Am getting an error when am printing customized crystal reports on web (Sage 300 2020 PU3)

  • Report Designer - custom date formula

    Hi there, This is my first post in Sage 300 online Community, woohoo. I find myself in uncharted waters. I am putting together a custom date formula, where the date has DDD field, which means 3 digits for "day in year". Example would be that today…
  • Formula to Suppress the footer option

    I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…
  • Sage 300 with SSRS

    Hi All, I was trying to print the SSRS report from sage. If anyone have tried this please help me with this.
  • How to create customer aging report in custom crystal report?

    I am new in crystal report. I want to create a crystal report of customer aging report. I want in column only (docdate,docnum, balance due, but not incoming payment of customer, days in the form of (duedate to getdate shows in days e.g. 90 days)
  • modify original

    HI I new in the Crystal report area and I would like to modify some standard reports that came out the box and when I do this, as soon I run the parameters input change complete, How I can maintain the same format. for example: this is the original report…
  • TsRange and SQL based reporting with Crystal reports

    Is there an alternate method to get the same functionality as TsRange when using Crystal reports against the SQL replicator? I was thinking I could use a from-to command but not exactly sure of the syntax.
  • Print Report - Error on running connectcomaddin in macro

    Client has been running fine and this just this week we have been getting errors trying to use Financial reporter. I suspect a microsoft update but they are saying none applied. (I know don't belive them ) either way I need to know what one it was …
  • Misc Costs totaling 3 times on invoice

    I am attempted to show the total of the misc costs on an invoice. I have created a calculated field for the misc costs that is equal to the extinvmisc only when the linetype is <> 1. This does calculated correctly, but when I use a sum formula it is three…
  • Budget Macro

    Good Morning; I have a client that is using the Budget Macro, to populate the budget for the current year. It seems to skip a few accounts. Any ideas?
  • Formulas to pull out First name & Middle Initial separately

    I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report. Any & all help is greatly…
  • All reports crash (SAGE Workstation)

    Hi Guys, Would a kind soul please help me ? Here is the case: I installed SAGE 300 2017 Workstation on a new PC running Windows 10 Pro. The only but about the installation was a warning message as follows: “There was a problem registering the…
  • Forms alignment out after upgrading to from Sage 300 2012 to 2018

    FormerMember
    FormerMember
    Before upgrade: Sage 300 v.2012; 2 pc with 2 printer (same model), User share the same OE invoice & cn/dn Pre-printed forms on dot matrix, no problem with alignment.. After upgrade to V.2018 – Alignment is wrong for both pc. I changed the alignment…
  • Customer & Supplier Transactions Reports

    Hi Sage family I have done some simple customization and format in the existing Sage 300 Reports of Vendor Transactions Report (apvtrn01) and Customer Transactions Report (arvtrn01) and it works well. But I have an important information that i also…
  • Sage 2017c web screen printing

    We have Sage 300c installed and the Web Screens are accessible. However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…
  • SQL Password Prompts in -some- custom reports and intermittently Sage Inteligence

    Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…