• Conditional field suppression in Crystal Reports

    MN has enacted Safe and Sick pay that must show on an employees paystub. I have added this field and label to the DD stub but do not want it to print for employees that are not in MN. The hours are helfd in time off 2. How can I suppress this field from…
  • 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…
  • 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.
  • 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…
  • 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…
  • Sage 100 2019 - Slow Crystal 2016 performance previewing report

    ** Support advised that we should post here too We have about 30 machines (only 5-10 use Sage 2019 concurrently) on our network and upgraded from MAS 200 v4.3 >> Sage 2017 >> Sage 2019. Select users are having an issue where launching PREVIEW of reports…
  • Miscellaneous Items in Designer

    Hello, I am trying to make a custom quote form for the Sales Order module. In particular, I have created three miscellaneous comment codes that I would like to use in the form to act as a type of specialized input for our business' needs. However, when…
  • How to Create a Crystal Report based on a Union Query for SO_InvoiceHeader + SO_InvoiceDetail to AR_InvoiceHistoryHeader + AR_InvoiceHistoryDetail

    I am trying to create a Crystal Report that unites the data from SO_InvoiceHeader + SO_InvoiceDetail to AR_InvoiceHistoryHeader + AR_InvoiceHistoryDetail. I believe the best way is to use a Union Query in Access and so I have created 1 Query for each…