• Crystal Reports 2016 error in custom report after Sage 100 2021.6 update

    First time in 12 years that the report I maintain is getting an error. Failed to retrieve data from the database. Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…
  • how to filter the date range on AR statement printing

    Hi, My client wants to filter the transaction date range within a specific statement date on AR Statement Printing Report. I tried to filter the date range using 'select expert' which set the between from to transaction parameter. If I press F5…
  • Pass a Job Name to AR Aging Wrk using UDF?

    I would like to see the Job Name, in addition to the Job Number, for each invoice, on my AR Aging Report. Using UDF links and customize the Crystal AR Aging Report.
  • Exporting from Crystal with 'text' formatting

    Has anyone had success in exporting a report from Crystal to Excel - Data Only format and have Excel format columns with string values as 'TEXT' and not 'GENERAL'? I can't seem to come up with a way to do this in Crystal. Thought I would check here before…
  • Print Copies of Picking List According to Item Quantity Per Order

    Hello everyone, I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…
  • Sage 2018 and Fixed Assets 2023

    Just upgraded Fixed Assets to 2023 for a client and they are still using Sage 2018 (in the process of upgrading to 2023 just waiting for a new server) and now they cannot print in Sage or in Fixed Assets. Getting this error. Report file C: ProgramData…
  • SalesOrder Picking Sheet Denied Access

    Hello Everyone, Our CS dept have been reporting to use that they are receiving a popup message in SAGE when try to print a pick sheet from the Sales Order module. Please see below. I can't figure out what could be causing this. I have checked permissions…
  • User Defined Fields Data

    We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…
  • Crystal Report Page Layout not previewing any width greater than 8.5"

    I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
  • Business Insights List Query

    Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…
  • Can I combine data from SAGE 100 Job Cost's JobTransactionDetail table and data from Job Cost's JobHistory TransDetail table on the same Crystal Report?

    I would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report. I need to create a summary report that includes data from both tables. I'm hoping that someone has…
  • Business Insights Explore

    In Business Insights Explore, is there a way for me to have the Data Field information and the Preview Field information on the same report? I've got all my fields the way I want them, but I don't want to just see the Invoice History, I want to see the…
  • printing UDF

    Hello, I'm curious to know if I can create user defined fields in Sales Order Entry and the same fields in Invoice Data Entry? The fields are populated in the Sales Order Entry window, and then transfer to the invoice. The fields are in be added to…
  • SO Picking Sheet Formula Syntax to display {SO_PickingSheetWrk.QuantityBackOrdered}

    Been awhile since I've worked with Crystal and have what should be a simple formula. The Qty BO Column on the SO Picking Sheet just prints an Underscore. I'm trying to get it to print the Qty BO if not equal zero and a blank if equal zero. Keep…
  • Print SO Line Number on Packing Slip & Invoices on crystarl report

    Hello Everyone, Looking for a little help on how to print the sales order line number on Packing Slips & Invoices. We are finding every time a partial order is shipped the line numbers are renumbered starting at one based on the remaining lines…
  • Installing F9 Install on Sage 2019

    Has anyone installed the F9 software version 4.5 with Sage 2019? We currently have 2016 and it works fine but we are about to upgrade and before we make a change I thought I would check.
  • How to add the Dollar Symbol to fields in custom Crystal Report

    I would like to add the $ to the beginning of sales numbers in a custom Crystal Report, however I can't seem to locate a place to add it when in Cyrstal Reports.
  • Modify report name on AR Custom Reports menu

    Is it possible to modify the name of a report that was added to our AR Custom Reports menu?
  • string together for printing 3 different sales order forms

    Is there a way with Crystal Reports to string together 3 different sales order form codes to print at once? either for a single order of for multiple orders?
  • Custom Check History Payroll Report

    Can anyone tell me where I can find step by step directions on creating a custom check history payroll report? We have 3 departments and within the departments employee work within department numbers. I can print the payroll check history report and break…
  • SAGE 100 Job Cost Report with Both open and close dates showing using Crystal Reports

    FormerMember
    FormerMember
    Hello New to Sage. Creating a Job Cost report. I want to key the listing on JC_JobBillingHistory to pull all the open and closed records. Using JC_Job for Open and JC_JobBilling for Closed. I can't get both of the tables to link to key table. It will…
  • sage time format / Crystal Report

    Hello, i am trying to create a report, and want to supply the TimeUpdated String(8) field from the IM_PriceCode table. can i create a formula field to convert that Field to a 12 hour time field? if so.. how? Thanks for reading. Peter
  • AR Statements - Add "Days Delinquent"

    I really like the presentation of "Days Delinquent" on the AR Aged Invoice Report and would like to do the same on the AR Statements. My problem is trying to find a good field that equals the "Statement Date" (with cut-off ability). What I've done so…
  • Item Usage Report By Customer

    I have been trying to figure out the best way to get a report that would describe something like Item “Usage” by Customer. The trick with the report is that not only do we have to recognize items that are SOLD to specific customers, but we must contemplate…
  • Dynamically pass new connection string for different SQL database to Crystal Report with a script

    Using Sage 100 Premium 2017 Using Crystal Reports 2011 I have six production SQL databases, all structured identically (for regional purposes). I have created a Crystal Report using a Connection based on OLEDB using one of the 6 databases. It uses…