• File Attachment in PO

    We currently use Instadocs to attach specific files to SO's and PO'S, etc.. Is it possible to attach a pdf to a specific PO and then print the PO to pdf with that specific attached file in the same pdf file? I would not think it's possible but....
  • Type mismatch when using zeroingll in Sage Intelligence

    Getting an error when trying to add in the zeroingll to a spreadsheet tab. There are no non-numeric fields in the column used for checking. What else to look for?
  • 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…
  • Accounts Payable Check and update

    I'm hoping someone can help me out with an issue we have been having with Sage 100. We have multiple companies but we are only have this issue with one of our companies. When we go to make an Accounts Payable check under Manual check and Payment entry…
  • 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…
  • Aged Invoice Report

    When I uncheck "Age Credit Memos" on the AR Aged Invoice Report, credit memos are still showing up on the aging report. Any help is appreciated.
  • 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…
  • Payroll Earnings Report Showing Departments Employees Worked In

    Hello, I am trying to figure out how to create a custom Payroll earnings report to show the Department field, hours, and dollars from Payroll Data Entry. The stock Earnings report does not appear to report this information, only the department defined…
  • 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…
  • Vendor Customer Purchase Report

    Morning, We have Sage 100ERP, I am looking to see if there is a way to create a report by period that shows how much in sales per vendor. So we are a distribution company and we purchase products from several vendors, and then sell those products to…
  • 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…
  • Anniversary And Birthday Calculations

    I am attempting to modify an existing report in Sage 100 to show employees' next anniversary date and birthday starting with the hire date and birth date fields entered on the employee set-up screen. I can't seem to get the addint function to work if…
  • 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?
  • Inventory transfer form out of MAS

    Has anyone ever created an inventory transfer form that can be generated out of MAS that a shipping department can complete. I am looking for a picking sheet type of form but the item is simply being transferred from one warehouse to another (therefore…
  • 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…
  • Custom Report creation in Sage 100 ERP (in explorer?)

    Hi there, I searched and couldn't quite find what I was looking for. I'm looking to create a report where I can select 60 or so specific customers from our database and be able to see the sales (to all or each of them) of 35 items from our catalogue…
  • Upload Work Ticket Template with Visual Integrator

    I am uploading several work ticket templates at one time using visual integrator. I can find the tables/variables where all the field data exists, but am not able to find the extended text. Can you please help and advise the table name where the extended…
  • AR Aged Invoice Report - Past Due

    I am looking to customize our AR Aged Invoice Report to replace a manually done Past Due Report. The report is fine how it is for the most part, but I am wanting to filter the 30, 60, 90, 120 Days columns to exclude all zero's. The report is way longer…
  • Adding fields to Standard Sage PR report

    Have a client who needs to do some reporting for the state and the Check History Report seemed like a good place to start. HOWEVER, I have been unable to add UDFs from the Employee file at all (even non-encrypted fields) (they all show as blank), and…
  • Stub, Check, Stub format in payroll

    In SAGE 2020 is there anyway to format the top and bottom stub differently in Stub, check, stub format in SAGE 100 2020?
  • Pay stubs

    I would like to add the Company name on all employees pay stubs. Is there an easy way to do this?