• Historical MRP from prior year

    Hi. I am trying to pull MRP from the prior year.
  • Crystal custom rpts after upgrade to 2021

    Getting database connection error on all custom payroll rpts after upgrade to 2021. Other custom rpts fine.
  • Why should an end user ever be able to circumvent paperless office for forms by selecting "Print All"?

    I'm scratching my head wondering what business reason would exist for a company to adopt a paperless office policy for forms distribution and then also want a random employee to be able to NOT save a copy of the form simply by selecting "Print All"? …
  • How to identify user running crystal report

    Does anyone have a creative suggestion on how to display the sage 100 user who is running a custom crystal report on the report so I can link to the AR salesperson? I’m trying to find a way to suppress information on a custom crystal report where the…
  • Schedule Crystal report

    Scheduled regular sage 100 rpts work well in task scheduler. Is there a documented way to schedule a custom crystal report. Posts I see are many years old so hoping there's an easier solution now. Have a involved rpt that takes a while to run while…
  • International Paperless Office Emails

    I have two end users that often email Purchase Orders Internationally...both to China. On occasion both end users are unable to send their email, they get the long/cryptic Paperless Office error that ends with: Failed to read beginning of SSL/TLS record…
  • Business Insights Report fails after update from 2020.1 to 2020.2 Advanced

    Message is “You cannot run this report as the data is in use by another task.” Other messages include: "view cannot be used - one or more tables are missing" to the table VIEW_ to the "you do not have sufficient rights" depending on if you try to select…
  • 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…
  • Crystal Report all of a sudden not found

    Hello, I was making final edits on a Crystal Report, Inventory Reorder Report in Inventory Management, and I have not moved the file in any way or changed the name. I am just now getting this error after running the report successfully mere minutes…
  • Print to Tray 1 or 2 Based on Criteria in Order

    Hi, I found a thread about a somewhat related customization, but it wasn't quite similar enough and I wasn't able to learn enough to be able to use the information there. I'm trying to setup my sales orders to print to different trays based on criteria…
  • Print List of All Jobs from 2015 - present -

    Please forgive me if already answered somewhere, but I could not find it. Sage 100C - I need to print a list of all jobs from 2015 - present. Just need the Job Number, Job Name, Job Address. This should be so simple, but I was not able to find…
  • Is an "Enforced Both Inner Join" type supported by the SOTAMAS90 ODBC DSN?

    I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…
  • Picking Sheet Printing - pritning orders that contain a specific item

    I'd like to edit the Picking Sheet printing Crystal report to only print orders containing a specific item. So if it contains that item, it prints a picking sheet with that item and any additional items ordered. Does anyone have a formula for that?…
  • Strange behavior from Picking Sheet Printing

    I have a UDF(checkbox) on SO_Header called 'Additional Handling'. When I open Picking Sheet Printing, and use the filters to say UDF_ADDITIONAL_HANDLING equal to "Y"....the correct orders print, but each pick sheet only has 1 line on it...even if the…
  • Unable to Preview - invalid index - Sage Preview / Crystal Reports Form Issue - Sage 100 ERP 2013

    Sage 100 ERP 2013 I've been struggling to create a panel I need for my small business and create a form in Crystal Reports for it - I've hardly had time to attempt this and I'm not having an easy time with the advice that's been offered. I don't have…
  • Work Order Traveler adding a UDT link

    I've created a UDT with 2 fields, ItemNumber (The key) and Description (A multiline text field). I want to link the ItemNumber to the ItemBillNumber of a work order and display the Description on the Work Order Traveler. I've added the UDT table in…
  • dynamic parameter not showing full list when running crystal report through sage custom reports menu

    Hi... Seen many posts about this issue, but no solution or answer. I have edited the windows registry and running the crystal outside of sage or from the report manager function, the parameter shows all the records for that database, even if over 1000…
  • Need help deciphering Activity Log

    Hello, We went live with a new project yesterday and are having some issues. I spoke with support, but because we have so many modifications they said they were unable to help. I found the two below entries in the activity log that I believe may be…
  • Create Crystal report $0 customer sales for a specific time frame - Not fiscal year and period

    Cannot utilize AR_CustomerSalesHistory. Need $0 Customer sales report for specific time frame. Parameter = i.e. Nov 1 2018 thru Nov 31 2019. Thanks for your assistance.
  • Paperless Office Sends out all old PO's when in Purchase Order Printing

    Hello, Normally when sending out a purchase order, everyone uses the Quick Print button to Print and Electronically Deliver just that PO. Occasionally someone will hit the Purchase Order Printing Button to Deliver the PO and will accidentally send…
  • Monthly Sales Report

    When running the standard Monthly Sales Report in the Accounts Receivable module, under Options, the screen only shows the oldest accounting period in our database. Shouldn't users be able to pull down a menu and choose any individual month or range of…
  • Report data source - Sales orders

    I've created a report that generates a label. My report asks for the Sales order no and the line on the sales order. The report table sources are so_salesorderheader, so_salesorderdetail and line item reference on the sales order. Sometimes the…
  • PII Data

    I'm sure this is similar to the issues others are having when trying to get PII data from Sage to another application, but I'll ask anyway. Our client has an Access database. They need First Name, Last Name and Status. Anyone figured out how to do this…
  • Setup Paperless AR Statement Delivery SOP

    Is there an SOP available to set up Paperless AR Statement Delivery only for specific customers?