Browse By Tags

  • Connecting via ODBC

    Hello everyone, we are looking to connect to Sage 50 data as a third party for enhanced reporting. Our goal is to use the ODBC capabilities to access the data. We are trying to access the data from over the internet via ODBC and report through Microsoft…

  • Error de impresión - No se ha seleccionado ningún documento.

    Al intentar imprimir un nuevo report añadido por nosotros salta este mensaje y no inicia el proceso de impresión. El report está OK. Hemos comprobado la Vista Previa en Crystal Reports y muestra/Carga correctamente la información. En Sage tenemos…

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

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

  • Cambiar el nombre de un informe cuando se descarga en cliente

    Buenos días, ¿Alguien sabe si es posible cambiar el nombre de un informe cuando se descarga desde la impresora > Ficha en SageX3 V12? Por defecto descarga el fichero con el nombre del informe pero necesitábamos cambiarlo para que corresponda con…

  • Sage 300 2023 (7.0) Report

    Hi I have a client who recently upgraded to Sage 300 2023 PU1 and have a problem that some of the standard form prompt for the parameters to enter twice. How can I go about fixing this problem?

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

  • Print Codes - Adding a report to BP Supplier Invoice Print List

    I'm having trouble adding a new report I've created to the AP/AR Accounting>BP Supplier Invoice record print list. I've looked all over the Setup>Destination>Print Codes list and cannot find a place I can add this report in order for it to show up as…

  • Antregrate Custom made piped Crystal Report / existincg Exe in Sage 300 Web Screen

    Anyone Please share the process to Integrate Custom made filter Based Crystal Report / exe in Sage 300 Web Screen.

  • Sage300 PO Y/N optional field. Value not changing.

    Hey Everyone, I am new to Sage 300 and crystal reports but have a decent handle on both. We recently implemented a yes/no optional field for PO line details, everything tested fine for a few days but now it seems like the value remains as 1 no matter…

  • Crystal Report Feeding DM2 Returning Blank

    Hello, I am trying to write a crystal report formula that does the following: If an amended PO number exists in the UDF_AMENDED_PO field, then return UDF_AMENDED_PO, if not, return CustomerPONo When I test this, when UDF_PO_NO is NULL, it returns…

  • Renomer les états crystal report par numero de la piece

    Bonjour, je cherche la possibilté de renomer les états edités au lieu de garder le nom par défaut de cryctal report (Boncde2, Bonfactt2....),par nom de la piece ou le document (BL-xxx-yyy-aa) Merci

  • Tamaño de fuente en impresión

    Buenos días, Cuando imprimo un documento directamente desde impresora la fuente es de un tamaño diferente a si primero genero un PDF. No encuentro información en la web y la configuración de la impresora es correcta. Gracias.

  • Need to update a crystal reports invoice with a specific field

    Hi - how do I find this in crystal reports to add it in: So, where do I find that "Item" in the field explorer in crystal reports so I can map it to the invoice Thanks! Dan

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

    Hi, 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 parámetros…

  • 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. Re, Victor

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

  • Error while opening crystal report

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

*Community Hub is the new name for Sage City