• Sage Alerts trigger question

    Does anyone know whether it is possible to trigger a Sage Alerts event by running a Windows batch file? We're on Sage 100 Premium (SQL) and I'd like to create a batch file that runs a job in SQL, waits x seconds for that job to complete, and then runs…
  • Add Terms Code Discount Available to Invoice

    We are looking to add a line to our invoices similar to the one below and I am struggling getting the right Discount Amount to calculate on the invoice. The Discount Amount we are wanting is the Terms Code Discount (1% 10 days, net 30) but I am not able…
  • Company Name in Crystal Reports

    Where is the company's name flowing from in Crystal Reports, @CompanyAddressBlock? I've changed it in Library Master > Company Maintenance but it did not impact anything. Trying to avoid having to re-write the address block on all of our reports. Thanks…
  • Button View

    How do I find what a button does on a form. In my case I know that it opens a crystal report but I don't know the name of the crystal file.
  • Insights Explorer - compare two columns?

    I'd like to filter a view by comparing to columns in the view. I'm specifically trying to create custom 'Customer History Invoices' view in AR, and would like to identify invoices that didn't have an invoice date and a transaction date in the same month…
  • Sage Task Scheduler not running

    I created a task in the Sage 100 task scheduler to update PO batches. If I hit 'Run Now' button in the Task Scheduler module, it all works perfectly. However, I can't get it to execute at a certain time each day. Windows task history shows it's executing…
  • 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…