Browse By Tags

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

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

  • Sage 300 2019 Report unable to use View Table as Data Source

    Hi All,

    Problems found when we had started doing new forms/reports for Sage 300 2019.

    Recently we found out that when using View Table as Data Source, the reports are unable to generate any results in Sage 300 2019, while Sage 300 2018 or earlier version…

  • report in Crystal which runs from crystal but generates nothing from reports Menu

    Sage 300.  I have written a report in Crystal which runs great from crystal  but generates nothing when I add it to the reports Menu in SAGE. I get a bit of an hourglass but no output.  It is setup for preview..  Any tips on how to troubleshoot this?

  • GL report - opening balances

    Trying to do up a Crystal report that will give the opening and closing balances for 4 GL accounts so that an employee (who I don't want to give Financial Reporter or GL access to) can run a report monthly to determine some tax payments. We are not…

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

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

  • Crystal report datapipe connector fix from years ago does not work for Sage 300 2016

    Crystal report datapipe connector fix from years ago does not work for Sage 300 2016.  Will Sage release another fix?

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

  • ..\a4wdp.c

    Datapipe report runs well in Crystal Reports preview, but when placed on desktop this error is received "..\a4wdp.c line 372".

    Copied datapipe.ini file for ICSLOW and commented out stock report and entered my report name and parameter.

    Copied…

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

  • Error message when trying to edit Sage 300 Certified Payroll report

    I am using Crystal Reports 2008 to edit the Sage 300 Certified Payroll report (UP71A/ENG/upcprj1.rpt).  When I open the file in Crystal, it first gives the error message, "The saved data will be discarded since one or more formulas failed to compile."…

  • Order Entry Form

    I am trying to figure out if there is a way to print Order Entry Forms twice.

    1. The first time it would print, it will print normally.

    2. The second time, it would print the form without any prices.

    Is this possible to do using the crystal reports designer…

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

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

  • How to add company address on AP check

    Hi,

    I am trying to add the company address from the Company Profile in Common Services module on the AP checks.

    How could I link this tab to the crystal AP form? Is there another a better way of doing this?

    Thanks

  • Crystal Reports 2013

    Does Sage 300 ERP 2014 support Crystal Reports 2013?

  • Custom Reports Not Opening Sometimes

    A client running 2012 with PU 3 installed is reporting an issue whereby remote users (terminal services) click on the report icon deployed on the 300 desktop for all users and sometimes the report will not open. They see in the lower left corner of the…