Browse By Tags

  • Crystal Report Windows Forms Viewer. The remaining text does not appear to be part of the formula. Details. errorKind


    A customer has a custom report we create from scratch for AP transactions a long time ago. After they update workstations to Windows 10 in some of them that custom report doesn't work but in others its OK. So not sure what's the issue to fix. They…

  • UDF Field Not always showing for reporting

    I have added a UDF to our Sage 100 SO_SalesOrderHeader table. I added it to the screen and set it up to print on the packing slip (uses the same table). When I try to add it to a report (which again has the same table) its not on the list to select from…

  • Order Total Showing up on Last 2 Pages of Purchase Order Form

    When printing a Purchase Order with multiple pages, it will print the order total (which is in page footer b) for the last 2 pages. It usually only happens when there is 1 line item or part of a line item on the second page.

    Right now 

    under Suppress …

  • IC Reorder Report using Preferred Vendor

    Has anyone changed the Reorder report to use the Preferred vendor instead of the report just using Vendor Type 1.  I realize the report is using a DataPipe and the prevendty isn't given under ICITEM for this report so it looks like I will have to build…

  • Download Report with file name as Document Number

    When doing a preview type print on objects such as Orders & Invoices, instead of the downloaded file name being the crystal report code, for example SBONFAC.pdf, it would be more beneficial to have file name as the document number.

  • Parámetros necesarios para obtener el sql que genera un report de X3 en crystal reports

    En ocasiones tenemos problemas al imprimir un documento de X3. ¿Cuántas veces os dicen es que sale en blanco una factura, por ejemplo?

    Para ello intentamos crear una vista preliminar usando directamente Crystal Reports  y ver cual de los…

  • Looking for description data for Payment Terms, Carrier, Delivery Mode

    Hello community, 

    I am trying to add some description data to a customer facing crystal report and noticed I am only pulling the ID/ Code of the certain fields but need to show the full description of what that id/code is. Trying to add the descriptions…

  • Add a condition formula to the table of Crystal Reports in Development > Script Dictionary > Reports to activate/deactivate printing of one or group of Linked report!

    When a Report code attached to Function is a Linked report (a collection of some Crystal reports to be printed at once), it would be highly beneficial to be able to set a condition formula if they need to be printed or not. 



  • Memory error on PDF printing V12

    Good day Everyone

    We are experiencing issues when printing Sales Invoices to PDF through X3. This is due to a limit on Crystal 32-bit.

    Are there any other option on Sage printing to overcome this type of issue?

    Note that the customer needs to produce…

  • Error while opening crystal report

    Getting the below error while opening any report. What could be the cause

  • Creating Crystal Reports Interactive Dashboards for Sage 100

    I have several reports in Crystal 2016. Has anyone created interactive dashboards using crystal reports? The Business Insight Dashboard is canned and not really customizable. Sage Intelligence isn't all that friendly. Your still trapped in a little box…

  • How to change Detail Width in crystal reports

    Hi Sage X3 Community!

    Hope everyones doing well.

    I have an interesting scenario...  I have a label that I'm trying to get to print to 4x6, which is working.. however it keeps printing an extra blank page, and I believe its because the details section…

  • 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

  • Informes utilizando stored procedure

    Hola !! como están

    Necesito generar un informe en Sage X3 utilizando un stored procedure que resuelva cierta lógica y los resultados los almacene en una tabla "temporal" que se debe poblar con cada ejecución del stored procedure…

  • JrnlRow payrollfieldnumber

    How does the jrnlrow payrollfieldnumber relate to the DefaultPayrollField table and the PayType table. Is the PayType table a new table in 2021?

  • Financial Reports Formula to get a total from multiple range in a single line

    Hi, refer to the below, row 193 is the total from row 194 & 195 What formula should I put in cell A193 if I want to sum the range as show in row 194 & 195 and it will not show or print when it is Zero? Same goes to A203.  Any advice?

  • No reports work on Sage 2020 PU2 Virtual machine. Other workstations work

    We have a Sage 300 2020 PU2 installation that works on most workstations, but one virtual machine running windows 10 Pro 64bit does not work. 

    The issue is that when we print a report - any report, it runs the database record select and then stops before…

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

  • Macro printing Report still prompt for Connection Auth & Parameter

    Hi All,

    I have problem with printing report from macro. 

    this is my code in macro

    this is my parameter in the Crystal Report and this is the only parameter.

    But it still prompt for connection authentication and parameter

    Is there any other thing…

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

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

    Footer A for Standing Billing
    Footer B for Tenant Billing

    Below is the formula from the existing sage invoice…

  • Commitment Count - Total & Unique

    Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time?

    We're trying to determine:

    1) How many commitments were…

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

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

  • Alter Report Sort in Crystal

    My customer wants to alter the Accounts Receivable Aged Invoice Report to sort on the Salesperson number listed in the AR_CUSTOMER (name sp?) table rather than the salesperson number in the AR_AgedInvoiceRportWrk table which is the same number that is…