• 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…
  • 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 ?
  • 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…
  • 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…
  • 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…
  • 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…
  • Crystal Reports: Editing Decimal Places in Invoice Quantity Fields

    Hello, I am trying to reduce the number of decimal places shown in the Quantity ordered, quantity shipped, and quantity backordered fields on my invoice template generated in Crystal Reports (a custom made OEINV.rpt) Each field is currently showing…