• 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: Adding a UDF for each Item Number on a Picking Ticket.

    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…

  • Job cost revised estimate in a crystal report

    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…

  • Invetory Labels - Extended Description

    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…

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

  • Supressed Entries leave large blank spaces on Picking Sheets after Sage 2021 update

    Ever since we update to Sage 2021, the suppression in on our forms doesn't work correctly. It will leave large blank areas for al the supressed values. Supress blank sections is already selected in the group and details. It was working perfectly before…

  • Sage 100 PM WT Traveler Crystal Report - Steps Repeat

    Hi,

    Hoping someone knows how to get the details sections of a crystal report to not repeat the same values as I can not have step instructions and signoff information repeat

    I moved things around in the PM WT Traveler report that came with the install…

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

  • Order Total Showing up on Last 2 Pages of Purchase Order Form

    When printing a Purchase Order with multiple pages, it will print the order total (which is in page footer b) for the last 2 pages. It usually only happens when there is 1 line item or part of a line item on the second page.

    Right now 

    under Suppress …

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

  • Sage 2021 PU2, PR 2.21.3 Upgrade - Have to re-add Payroll Custom Reports with PII Wrk table from 2018/2019?

    Howdy - I have had 3 separate upgrades where the client is upgrading from 2018/2019 with fairly recent Payroll updates (2.21.1 and greater) to Sage 2021 PU2 with PR 2.21.3, and after data conversion, if they have any Payroll custom reports from the previous…

  • Bug re default forms if perpetual - Any movement on this?

    Solution ID: 111860 dated 8/24 - would love to see a hot fix on this SOON......

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

  • Looking to Customize Customer Statements Sage 100 2019

    I am looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…

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

  • When trying to link item memo with purchase order wrk as soon as I link the tables and try to run the report i get The database login failed.

    I am on Sage 100, 2020, Premium (SQL) version 6.20.0.1

    I have customized the Purchase Order report and it works fine from purchase order printing until in crysal reports I link the inventory memo table to the purchase order wrks table.  As soon as I do…

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

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

  • Adding Form Codes to Picking Sheet Printing

    I am modifying our picking sheet and want to save a "test" version. When I am in Crystal Reports and I go to "Save As", I create a new folder in the "SO_PICKINGSHEETPRINTING" Folder. It doesn't show up as a form code when we go to print a picking sheet…

  • 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}="1" THEN …