• 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.
  • 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 using…
  • Forms alignment out after upgrading to from Sage 300 2012 to 2018

    FormerMember
    FormerMember
    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…
  • 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…
  • 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…
  • 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 window…
  • 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…
  • 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…
  • Sage 300 2017.3. Crystal Reports 2011

    Hi, My report opens in Crystal but not in Sage - it tries to open, there is a quick glimpse (flashes on the screen) of it opening and then nothing. No error message. I tried creating reports from different tables - all with the same result. Any…
  • how to modify Crystal Sage 300 AP Ch advise to be similar to the 2 column 36 entryadvise from Sage 50.

    Client wants the cheque advise to have 2 columns on the cheque advise in Sage 300, as Sage 50 gave him 36 items on the remittance stub. (Just Doc # and Amount paid) How do i setup the sub report to do this? Sam
  • Payroll 72A on Sage 300 2014 PU5 CT 72F

    Greetings! If this is the right forum, I have been having a perplexing issue with printing payroll cheques using either CPCHECK4 and CPCHK4A forms - regardless of the Advice Lines per page and MaxDetails field in the Crystal Report Design tab being…
  • Date Format

    I am building a custom crystal report off the AP Invoice Table. When I grab the APIBH.DATEINVC file, it shows 20,110,101.00. I want to convert it to 1/1/2011. I tried using the following formula: date({APIBH.DATEINVC}) but it does not work. Any suggestions…
  • Can you customize canned reports to connect to more that one database?

    We would like to take some of the existing reports in 300 and modify them to run for multiple databases from one company. Is this possible without writing a whole new report? We do have a connector license. Thanks! LeShel Rich
  • Sage 300 ERP 2014 PU 3; Crystal Reports X1 'Load Report Failed'

    Hi, I created a custom report from one table and passed a parameter to it from a sub report (also from one table). Created and run successfully on my machine in Crystal Reports 2011. I get the 'Load Report Failed ' error when I run it on the client…
  • Crystal Report Question - Specifically for Page Header

    Hi all, I am working on a report, somehow got stuck. Here is the simplified yet detailed description of the problem. I created two formula out of OESHIHO table: formula A: if {OESHIHO.OPTFIELD}='A' then {OESHIHO.VALUE} else '' formula B: if…
  • Using the same record twice but with different criteria in Crystal Reports

    I'm trying to use the same record twice in a report but with different criteria. It's on an invoice and in the details section I want the report to ignore a particular item id and it's data, but only show results for that same item id in another spot…
  • Crystal Reports & AUDTTIME

    Hi We are using SAGE 300 and crystal reports 10. I've been strugling with this issue form more than 8 hours now and I really need help. The AUDTTIME field in ICHIST is a decimal(9) field. Now I've got to convert this decimal field to a time. This is…
  • pwFormatDate not working

    I was writing a very simple report that I am trying to format the Sage 300 date for and I get an error. Does anyone know how to fix this or a different more reliable way to format Sage300 date fields. I tried using: pwFormatDate ({CPEMPL.HIREDATE…
  • 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?
  • Linking to a subreport to get an inventory optional field

    I am using SAMINC to test linking a sub report to the picking ticket of an order. My problem is that the OEORDD table uses the full part number, but the IVITEMO drops the special characters. When I attempt to link I get no matches. How can I link the…
  • 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 same…