Browse By Tags

Crystal Reports 2016 is no longer available from the knowledgebase (that I can find), and Crystal Reports 2020 does not have a connection to the HRMS database. I have clients with new workstations that need Crystal installed, but it has to be a working…

Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…

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…

Can we create a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting?

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…

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} >=…

Is there any documentation on best practices for upgrading Crystal Reports to a newer version? I can't find anything especially helpful in KnowledgeBase or elsewhere.

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…

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…

SAP Crystal Reports 2016 entered the end of mainstream support at the end of December 2022 and enters support end life on 31/12/2024. In preparation for this, we are no longer distributing 2016 license keys, and from now we will only distribute SAP Crystal…

I am trying to print an invoice, in retail POS, but I am getting the error above.

About 4 days ago (11/17/22) , suddenly the customer viewable notes on our purchase orders stopped appearing. The "Customer Viewable" box is *definitely checked. Has anyone else experienced this or found the solution? Thanks

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…

Using MyAssistant, I am trying to create an excel doc that contains the "Current Month" in the top row. If I go into JC and select File > Company Settings > JC Settings, I can see in the Accounting Date section the Current Month is "September" (even though…

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…

I have just upgraded my client's live Sage 100c advanced 2019 PU 4 to Sage 100c 2022 PU 1. Everything migrated to new server properly and the data for the live company was converted fine too. I am experiencing an issue with the ODBC both for User and…

Hi everyone, A customer change its PC - we have all programs ate server and we run workstation setup - and suddenly a custom crystal report we create from scratch doesn't work !!!! Error...."The remaining text doesn't not appear to be part of formula…

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.

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…

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…

OK. My lack of knowledge is really going to show here. For reference, we use Sage 100 2019 Manufacturing . I have a highly customized Picking Ticket created in Crystal Reports. We are a manufacturer, and when a customer orders from us, the Picking Ticket…

Created a report comparing Revised Estimated Cost to Actual Cost. The "sum" of the Revised Estimated Cost is giving me problems. When I try to "Sum" that field, it totals by the number of times the cost code is used...therefore the "sum" becomes overstated…

Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…

Hi all, I have a client purchased a Crystal Server 2020 license due to its support of QR code generation over the normal Crystal Reports 2020 which required third-party additions which the client is uncomfortable about purchasing additional third-party…

I am trying to add the extended item description to the inventory labels. I am at a loss. I've added the CI_ExtendedDescription in the Database Expert and added the field to the report - but when I try to print the labels, they are blank. I'm not that…