• 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…
  • A/R Payments

    Hi Folks, I am trying to add payment information to my A/R invoices. My test company has a formula field called "Payment" with the following formula "formula = {@NetInvoice} + {AR_InvoiceWrk.FreightAmt} + {AR_InvoiceWrk.SalesTaxAmt}" that does not seem…
  • All Standard Crystal Forms and Report are not populating data in Sage 100 2022 PU1...ODBC Issue

    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…
  • 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…
  • 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…
  • 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 displayed…
  • 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…
  • Can I combine data from SAGE 100 Job Cost's JobTransactionDetail table and data from Job Cost's JobHistory TransDetail table on the same Crystal Report?

    I would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report. I need to create a summary report that includes data from both tables. I'm hoping that someone has…
  • Crystal Reports - Sales Order Picking Sheet - Adding User Name Generates Blank Pick Sheet

    Hello, I'm trying to modify my picking sheet so it shows which Sage user created the sales order. I'm using Sage 100 ERP 2013 and Crystal Reports 2011. I have "SO_SalesOrderDefaults" added in Crystal Reports under Database Fields, but when I add …
  • Removing Extra Space on Form

    We're editing our picking form, but now when there is a comment on an item it will add a line of space before the next line item. Is there a way to get rid of this space? Is there a way to get rid of the extra space created when an item doesn't have a…
  • Crystal Graph Sales History by Period

    I am working on a Crystal Report that shows a grid with sales history and would like to graph the history by sales period. For instance showing each period in 2018 as blue, 2019 as red, 2020 as green. So you will see each year clearly in each period.…
  • Sage FAS upgrade affects Sage 100 2016?

    FormerMember
    FormerMember
    We recently upgrade Sage fixed Assets from 2016.1 to 2019.1, today a users reported issues generating reports from Sage 100 2016, that's all the relevant changes that we have made recently. May Sage could be affected because of this?
  • Editing Paperless office printing output via Script

    Hello, I am having some issues with making a script to change the output setting for paperless office inside of sales order printing. I have some code below that I found searching the forum. The way it is now I do not get an error message and nothing…
  • Crystal 2016: GS1-128 Symbology: FNC1

    Hello, I'm working on creating a barcode that needs to meet USPS requirements. Currently the formula I am using is: BarcodeUCC128("420" & "56901" & "92" & mid({SO_InvoiceHeader.UDF_TC_USER_8},3,24)) The font for the barcode Code128. …
  • 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…
  • Upgraded Sage 100 2015 to 100 2018 Advanced

    FormerMember
    FormerMember
    Hi Super Heroes, 1. we used TCP 9500 as the port id, and it is working fine after we disabled the firewall for domain users. What other ports do we need to open other than the 9500, because after i opened 9500 inbound and outbound, server pop up with…
  • SYWFCU returns "no custom reports found"

    In the process of upgrading from 4.50 to 2018. My custom reports migrated to my 2018 installation and are in MAS90\MAS_XXX\Reports. However, when I run SYWFCU and specify this directory, I receive the following message "There are no custom reports found…
  • Crystal Reports: Beyond the Basics

    Are you ready to take your crystal reports to the next level? Sign up on SageU for Crystal Reports - Beyond the Basics. It will be held on July 28 & 29.
  • Inventory Sales History Report

    I'm trying to get a report that is similar to the Inventory Sales History Report, but also to include the price per unit. This report sorts by item code which is what I want, and also lists quantity sold and quantity returned which I need. I just need…
  • Gathering info for Vendors

    I am new to Crystal Reports and I am trying to figure out how to put some vendor information into my report. I have their number, name, address in it and now I need how much they have purchased. I used InvoiceAmt and even NetInvoiceAmt in the report but…
  • Adding User Names to Crystal Reports

    I am trying to figure out how to add Sage User names to custom Crystal Reports that the users run in Sage.
  • How to get Crystal Reports to Pull Data from 2 Unrelated Tables and Summarize Them

    I have a crystal report that is pulling data from our posted AR_InvoiceHistoryHeader and AR_InvoiceHistoryDetail files and I have the exact same report pulling data from our un-posted SO_InvoiceHeader and SO_InvoiceDetail tables. I want to have the two…
  • Custom forms development with Crystal Reports for Sage 100 ERP - Who does this?

    Hello, We are looking for a company that can develop Invoice and Packing slip forms for us using the Crystal Reports 2011 that comes with the Sage ERP 100 Does anyone know of a good company to help with this? Thank you
  • Multiple connections to SOTAMAS90 in Crystal Report

    This is occurring in Crystal Reports XI R2 with Sage 100 ERP 4.5. Client has created a custom report pulling data from AR_InvoiceHistoryHeader, AR_Salesperson, and AR_Customer. Link to AR_Customer from AR_InvoiceHistoryHeader is a left outer join connecting…
  • RE: Mas-System folder showing a reports folder underneath

    Shelby, the reports under MAS_SYSTEM are customized reports created for ALL COMPANIES. Company Specific reports still take precedence if they exist for said company over what is in MAS_SYSTEM.