• 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?
  • VB.Net report printing is not happy with a sage 300 session created by the program

    I have a Sage 300 program, developed in VB.Net, that generates crystal report PDFs. When I run the program from the Sage 300 desktop on my client's server, it works just fine by passing the session token as a parameter. It also works fine running…
  • Using Crystal Reports to customize Ardinvo, how do I add database tables and fields from those tables?

    I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name. Now I want to add some fields to it that are not in the set of data tables already in the report. In the "Field Explorer" I right…
  • Crystal Report Error

    I made a report with crystal report on my local, it all went well but when running on the client pc the following message appears
  • AccpacPrintSetup crashing after upgrading to SAGE 2020 PU2

    In previous version, SAGE 2017. This code works fine. But after upgrading, it crashes. Dim oRpt As AccpacCOMAPI.AccpacReport oRpt = oSession.ReportSelect("APWMSSOFTRMT[APWMSSOFTRMT.RPT]", " ", " ") Dim oRptPrintSetup As AccpacCOMAPI.AccpacPrintSetup…
  • 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…
  • I will build custom report AR aging with addtional descripstion and project in crystal report. what table will be used ?

    [sage300erp 2018] I will build custom report AR aging with addtional descripstion and project in crystal report. what table will be used ?
  • Issue printing customized Crystal Reports when parameters

    Hi, I'm running Sage 300 V2020- Running on a VM accessed by RDP and with SQL 2017 databases running on Azure. I redirected the Custom Reports to the new Azure server with the SQL sa user name and passw and it's working fine inside the SAP Crystal…
  • Formula for miscellaneous cost in invoice form

    I am trying to insert miscellaneous costs in invoice totals but my formula is not working. I am using OEINVD table and my formula is: IF {OEINVD.MISCCHARGE} = "UPS" THEN {OEINVD.EXTINVMISC} Any help is highly appreciated
  • Contract Billing Report Customization in Crystal

    I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…
  • Customizing OE Invoice to include a Segment Value Description for the item

    Our inventory Items have a structure "Style" (8 char)-"Colour" (5 Char)-"Size"-(3 Char) We want to separately show the segment description in a field on the invoice for the style and the colour. I have tried a little sub report for style connected…
  • Issue with Crystal reports prompting for SQL sa password.

    We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…
  • 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…
  • HELP! I have no idea how to build a report in Crystal and utilize it in Sage

    I am a complete newbie to Crystal Reporting and have watched several tutorials, but they are all for stand alone spreadsheets. I have no clue how to use information within Sage to create a custom Crystal report and how to connect the two of them.
  • 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…
  • Automatically run Crystal Report & email. Sage 300 2018.1 on Windows Server 2012 R2

    Hi, The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates. Is this possible using Windows Task Scheduler or is there…
  • Sage 300 2017.3. Crystal Reports 2011

    Hi, My report opens in Crystal but not in Sage - it tries to open, there is a quick glimpse (flashes on the screen) of it opening and then nothing. No error message. I tried creating reports from different tables - all with the same result. Any…
  • how to modify Crystal Sage 300 AP Ch advise to be similar to the 2 column 36 entryadvise from Sage 50.

    Client wants the cheque advise to have 2 columns on the cheque advise in Sage 300, as Sage 50 gave him 36 items on the remittance stub. (Just Doc # and Amount paid) How do i setup the sub report to do this? Sam
  • Sage 300 ERP 2014 PU 3; Crystal Reports X1 'Load Report Failed'

    Hi, I created a custom report from one table and passed a parameter to it from a sub report (also from one table). Created and run successfully on my machine in Crystal Reports 2011. I get the 'Load Report Failed ' error when I run it on the client…
  • Reprinting Order Confirmation

    Dear All, I would like to reprint order confirmation with different completed status in OEORDH & OEORDD. So I edited the selection formula in crystal report (oeconf01) like that. ( ({OEORDH.COMPLETE} = 1 or {OEORDH.COMPLETE} = 2) or // order header is…
  • Bin/Shelf labels

    Greetings, I created a custom label report in Crystal using the Mailing Label and Report Wizard and it works well in Crystal. I saved it and am trying to open it from within Sage 300 2014 PU3 and I am getting the Error:LoadLibrary message. Has anyone…
  • Item Valuation Report

    We are trying to customize an "Item Valuation Report" for a client, as the stock report(s) dont fit their layout needs. Almost everything we need is in ICILOC table, except: we need to be able to run it by "cut off dates", so quantity information would…
  • Can I add the user name who is printing the form on the form?

    Hi, Can I add the user name who is printing the form on the form? Thank you!
  • Invoice Template - Reduce Unit Price decimals

    Hello, I am trying to reduce the number of decimal places shown in the Unit Price field on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) The field is currently showing six decimal places on items related to labour (i.e…