• (REPORTING) How to link invoice line items to GL Detail Posting?

    Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…
  • Crystal Reports 2020 Database connection Error

    Have a client that upgraded from Sage 100 2019 to Sage 100c Advanced 2023 PU1. They run several reports outside of Sage using Crystal Reports Writer version 2020. They can run these reports with no issues some of the time, but then later in the afternoon…
  • 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…
  • 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…
  • Crystal Reports 3" X 1" shelf tag label template

    Would anyone have a label template for a shelf tag that can be used in a Zebra label printer, continuous? I would like to be able to modify a label that would print Item code, description, bin location and sell price. I am also willing to pay for any…
  • Information on fields from Wrk tables? Needed for Knowledge Sync.

    Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…
  • 1.Instructions on how to create a label (4x6) in sage 100?

    Instructions on how to create a label (4x6) The two modules we could start to use this feature is in: Sales Order\Main\Shipping Label Printing Purchase Order\Main\Receipt of Goods Entry
  • Repeating Pages on Crystal Reports for Label Printing

    I am attempting to move some of our label printing to crystal reports. I can successfully print labels but, is there a way in Crystal Reports to have a group section repeat X amount of times based on an equation? For example, lets say I have 1 line item…