Browse By Tags

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

  • 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

  • Rapidez Impresión Sage EM V11

    Buenas tardes,

    ¿Existe alguna documentación técnica para mejorar la rapidez en la impresión de documentos con Sage EM V11?

    Muchas Gracias!

  • Crystal Report traducción artículos

    Buenos dias,

    Desde sagex3 he empezado a traducir la descripción de los artículos en varios idiomas y sage dependiendo del idioma del cliente en la descripción del programa vuestra uno o otro, el principal si no existe español.…

  • Crystal Report Hanging after Parameters have been entered

    Hi guys, so I am trying to add a crystal report to Sage 300 ERP however whenever I add same and run the report after entering the date range parameters, the report just freeze, wont load and also wont close when I try to close it. 

    I've unchecked the option…

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

  • VB/.Net (BOI syntax) to VBScript (UDS) syntax for calling Custom Report

    Hi everyone, 

    I see many examples of processing a report in BOI, like this one.  But all of them are VB/.NET or C#.  Could someone please help me translate the syntax to UDS work with Events like Column_PostValidate?  Below is Bret's example of Previewing…

  • Goods Received incorrectly reflected in wrong Warehouse.

    Hi All,

    I had an issue with my receipt of goods entry...

    Basically the Goods entered as Received in Warehouse 008 but its balances is reflected in warehouse 001 in Inventory valuation report.

    What causes this and how do i rectified it?

  • Sage 300 2012 invoice giving error while printing

    Getting the following error message while printing the invoice report from Sage 300 2012, product update 1 on the client machine:

    Faulting application name: A4WCONTAINERXP.EXE, version: 6.1.0.0, time stamp: 0x503da4ab
    Faulting module name: ntdll.dll, version…

  • Crystal report preview issue - SAGE 300 2019

    Hi,

    One of the workstation, the print preview of any reports, the screen is printing at the center in a very small pages. Attachment is here. 

    Thanks in advance.

  • How can i convert number to Text in crystal repport SAP

    i used  this function:

    ProperCase( ToWords(10000, 0) ) //Dix Mille

    but how can i convert in two language french and english
  • 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…

  • How to add a new crystal report to SAGE X3 V11

    Hello everybody

    I want the steps to add a report to Sage x3 V11 please.

  • Forms alignment out after upgrading to from Sage 300 2012 to 2018

    Before upgrade: Sage 300 v.2012; 2 pc with 2 printer (same model), User share the same OE invoice & cn/dn Pre-printed forms on dot matrix, no problem with alignment..

    After upgrade to V.2018 – Alignment is wrong for both pc. I changed the alignment…

  • stock crystal report form

    Where do I find stock crystal report forms? I'm using 300 v2017 and looking for the most up to date version of oeinv.rpt

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

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

  • Sage 2017c web screen printing

    We have Sage 300c installed and the Web Screens are accessible.

    However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this?…

  • Sage 300 standard reports won't export on one w/s only

    Customer has a new Win7 laptop and their IT folks installed the Sage 300 client 'as usual'.  

    Users normally preview reports then prints or sends to PDF if a copy is needed.  When they choose 'export' option from the preview, instead of getting the…

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

  • MODIFIED SALES INVOICE RPT NOT SHOWING EDITED FIELD (CRYSTAL REPORT)


    Am working from the DEMO folder


    I modified the file SBONFAC.rpt in crystal report 2013 to include a field from a table in sage x3.

    the original file is located at :

    Since sales invoice RPT files are in :
    C:\ProgramData\Sage\Safe X3 Client\V1\Data\X3_X3SERVER_1806…

  • Crystal Report DATABASE CONNECT

    How do I connect to the same database set: This is what I need to connect to.

    When I click on the left list. It is bringing in the table from different set.

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