• Crystal Report Balance Calculation Error

    Hello, In our current table " AR_AgedInvoiceReportWrk" has a field called balance however, it is not calculating the customer balance properly. If I create a formula the properly calculate the balance would it be: if {AR_AgedInvoiceReportWrk.Balance…
  • Crystal Report Formula

    Hello, I am hoping someone could assist me with a formula I'm trying to create. The UDF field I created for our users displays in numbers but I want to create a form that if the number displayed is x then it should display y. For example, "If {SO_OpenOrdersWrk…
  • 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…
  • Crystal Report Field Edited Date

    I have two udf’s that are populated on the SO_SoDetail table, they are also printing on our pick ticket. How can I capture a date time stamp value for when that udf is edited (it’s a numerical value) and display it on the crystal report for the pick sheet…
  • Crystal Custom Reports not able to edit run time parameters

    Hi... When running custom Crystal Reports from the Sage menu or even in Crystal Reports, the run time parameter is not letting you edit the field or add new data to the field. Even the calendar widget for date parameters will not access. Is this something…
  • Is this possible for Select Expert?

    I have this in Select Expert and I need to also include a value that has no VendorNo {AR_InvoiceHistoryHeader.InvoiceDate} = {?Date Range} and {AR_InvoiceHistoryDetail.VendorNo} like ["0000833", "001????", "002????", "003????"] and {@Total Sale} >=…
  • Database login failed into Crystal KnowledgeSync

    Trying not to duplicate a question that has already been asked. I have a crystal report that can be run from Sage and interactively that does not use any work tables, but when attempting to run it from a KnowledeSync report in 10.5 version I get a Database…
  • Adding Weights of a Repeat Item

    Hey All, I am customizing our Bill of Lading (Picking Ticket) so that it will calculate and print the Net and Gross weight of each item on the ticket. I have just about everything worked out. Where I'm stuck is when there is an item that is repeated…
  • Created by User Code - Work Ticket WIP Reconciliation Report - Operations Management

    I am adding the Creator (2 or 3 initials of our team) of a Sales Order/Work Ticket on the WIP Report. It only comes up on part of the Work Tickets listed. I have tried to compare of what has hours applied, what has parts, etc. Is there utility I should…
  • Can you add a url to products so the crystal reports will export hyperlinks to our website?

    We'd like our quotes to display the product codes hyperlinked to their associated webpage on our website. Is there a way to do this with sage 100 and crystal reports? Seems like a very basic thing that should be doable.
  • Business Insights Invoice Number Repeating

    I created a sales history report in Business Insights Report Wizard using Invoice History. Objective is a total invoice amount including invoice number, customer number, customer name, invoice date, transaction date. However, the report repeats invoice…
  • Data File Structures class? Crystal Reports classes? Where did they go?

    When I started with Sage, I took several classes online - Data File Structures, Crystal Reports, etc. I can't find any resellers that offer these programs anymore and Sage seems to only offer X3 classes. Yes, I see the YouTube offerings but I am looking…
  • Crystal Reports QuantityDecimal formula for 2 decimal places

    What formula would be used in QuantityDecimal to set the number of decimals to 2? We need 4 decimals for qty for BOMS only, so would like all forms to only display 2 decimals. Thanks.
  • Crystal custom rpts after upgrade to 2021

    Getting database connection error on all custom payroll rpts after upgrade to 2021. Other custom rpts fine.
  • How can I add 'applies to invoice #' in Crystal Reports for customer credits?

    We had our system put in about a month ago(Sage 100 2021). When I go to make a customer credit in the Sales Order module, I can apply it to a specific invoice. But once I go to send the customer the credit, nowhere on the form is there a 'applies to invoice…
  • Schedule Crystal report

    Scheduled regular sage 100 rpts work well in task scheduler. Is there a documented way to schedule a custom crystal report. Posts I see are many years old so hoping there's an easier solution now. Have a involved rpt that takes a while to run while…
  • Custom Report removed in Report Manager still showing up as optional Report Setting

    I've been tweaking our AR Aged Invoice Report in Crystal Reports and have ended up with a few versions that I now need to delete. They are showing up as options in the Report Setting List. I've deleted them in the Reports Manager, but that had no affect…
  • Add a job cost related field to AR report in Crystal Reports

    I am trying to add the "JobDesc" field to our AR Aged Invoice Report so that we can see what job name corresponds with the invoice on the report. I'm a beginner in Crystal Reports, but here is what I've tried: In Crystal Reports designer, I created…
  • create new Sales Order form where lines print in correct order

    I need to create a sales order form for KnowledgeSync. I can't get the lines to print in the correct order. The standard sales order form created from the sales order work table has a "Group" that I'm assuming is what gets order lines to print as displayed…
  • 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…
  • How to obtain Quantity of Items Sold and Issued with Custom Date Range

    I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…
  • Surpress Blank Space when inserting images using OLE objects onto Picking Sheets

    I figured out how to add images to our picking sheets, but not all items have images and those that don't leave a huge blank space where the image is supposed to be. Is there a way to "collapse" this space if there is no image associated with the product…
  • Need some help adding 2 fields together

    Hi all, I need to add the Sum of 3% Parts ( which seems to be a sum at the Group 2 level) and 3% Freight but I cant seem to get them to add correctly. Any help is greatly appreciated. --- Parts Extension IF {AR_InvoiceHistoryDetail.ItemType}=…
  • Is an "Enforced Both Inner Join" type supported by the SOTAMAS90 ODBC DSN?

    I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…