• Creating AR Aging in Sage Intelligence Sage 100 Advanced

    We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…
  • Designer Report

    I am new to designing reports in Sage 100. Is there a good YouTube video or documents on this? I just need something simple for an audit (employee name, job title, gross wages, and overtime wages).
  • Open Sales Order Report - Filter fields

    The Sage 100 Open Sales Order Report has a list of stock criteria fields, and some fields we added using custom office..see attached. Are we able to add additional standard Sage fields to this list eg; CustomerPO?
  • Default Bill Value to Single Level Report

    Hi... I'm trying to find a way to add a value from the bill of materials bill number field in bill of materials maintenance to autopopulate the bill number when you run the Single Level Report from the screen. As it works now, the report will appear…
  • Sage 100- Print Customer type on packing slip

    I am looking to print the customer type on the picking sheet. I added the AR_Customer table to the database, used a left outer join. Added the Customer Type to the crystal form (browsed the data-I could see the customer types) BUT when printing it does…
  • Multi-Part Form Picking Sheets

    We print large batches of picking sheets a couple times a day, when this process is run the printing prints all of the picking sheets form 1 first, then goes back and prints the second form for the picking sheet. The process is run on 20-100 sales orders…
  • 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…
  • Row and Bin by Distance for the Picking Sheet, is this possible?

    We have 170+ rows and they are separated into 4 different groups of rows. First group of rows is 1-54 and behind that one is 108-55 and then 109-138 & 162-139. We could have a order that has an item that's on row 1, row 54 & 108 for example. If they pull…
  • Can you auto-generate comments on Sales Order lines?

    I need my team to be able to see certain information on Sales Orders for a few product lines - is there a way to auto-generate comments on those products? Or would it be easier to implement extended descriptions to SOs instead?
  • Crystal 2020 No Longer Includes MS Access, Excel, or Text Connectors

    There are additional efforts to use Crystal Reports 2020 (@Sage 100 2023) with MS Office or text files. I have Custom Reports that include links to Excel and MS access. Without the native connectors we will have to use downloaded add-ins. Does anyone…
  • Attempting to import multiple POs into the same Receipt - Next isn't working.

    I am trying to import multiple POs into the same Receipt of Goods. I chose Next for the Receipt Number and pointed it to the field I want to use to determine the change, but apparently it ignores that and changes whenever any header field changes, i.e…
  • Pay stubs

    I would like to add the Company name on all employees pay stubs. Is there an easy way to do this?
  • Custom SQL views used in custom reports

    I have created numerous custom SQL views in sage company databases and used them in custom reports, added to custom reports, and module forms. I just did the same for a customer and cannot print/preview the report from the custom report's menu. The error…
  • Custom Reports running so slow on workstation

    I made a custom report with Business Insights. Pretty simple report, shouldn't be a big deal. But every time I try to make a custom report, it will run very fast on the server. As soon as I try to run it on a workstation, it takes forever and ends up…
  • Crystal Report using Access database in MAS menu gets an error

    Hi, I built a report in Crystal that they can input several item codes and it returns who has bought those items. It was added to the MAS menu AR custom reports. I had to build Access databases and custom ODBC to run the report. Its worked for a long…
  • 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…
  • Printing alias item description on sales order form

    I need a formula that will print the customer alias item description ONLY when an alias item exists but NOT print the item description. And when an alias item description does NOT exist, print the item description. I know there is probably some time of…
  • Where is the Primary Vendor Item Number PV*

    We can have several vendors for just one item code and I need my report to show the Primary Vendor Alias Item No only, but it show the first vendor instead of the fourth one. Where do I find PV * ? Ive looked in IM_ItemVendor and IM_AliasItem and dont…
  • Crystal Suppression Shadow Text

    I have a crystal report utilizing the shadow text feature to print our pick tickets along with a packing slip. I am running into a road block on everything thing I've tried, we want to suppress some miscellaneous items on the packing slip, any charge…
  • Link IM Item Table to JC Job Transaction Detail Report Work Table?

    Hello, Has anyone found a way to link IM_Item Table to the JC Job Transaction Detail Report Work Table? We are looking to get an item description included along with a part number on the report when we view for material pricing purpose. I am sure…
  • Invoice Page Footer

    We have a client that has a page footer that is around 3" wide. They oftentimes have invoices that are more than 1 page and don't like all the empty space at the bottom of the page on the pages before the last page. Has anyone else has this complaint…
  • delete

    DELETE
  • Grouping on Crystal Reports

    We have the option under sales order options to print the pick tickets by line number. We also have the group header suppress check box checked off on the crystal report. When one line has a different warehouse the pick ticket is out of order compared…