• Are First and Last Names needed for printing or eFiling 1099s?

    I thought I read a post about this, but now I cannot locate one. When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not: Of course we get this message, which…
  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • Work Ticket Printing Error

    There are 2 buttons designated to printing the pick list and also the work ticket. When clicking on the Pick List print button it allows us to print the pick list with no issues. However, when trying to print the Work Ticket we are met with an error …
  • Purchase Order Printing

    When I print the purchase order it does not show the item description on the purchase order. How do I fix it to show the description on the purchase order? Thanks
  • Invoice total and Final balance due on AR invoices don't match

    Hello everyone, I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…
  • Silent ODBC on terminal server

    Hi All, I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…
  • "SendAsDeniedException" when trying to send emails since moving to Office 365

    Have a client who was emailing SO Orders and Invoices with no problem when they hosted their own Exchange Server. Recently moved to a cloud based Office 365 solution and now when they try to send a test email or a Form they get, "SendAsDeniedException…
  • Sage 100 Paperless PDF of AR & SO Invoices prints Blank (All White with no data) for Plain Invoice form and like a Photo Negative for Customized Marbled form after Adobe DC update to 2019 version

    This problem has been driving me crazy for the past 2 days. Have a client who PDF's & electronically delivers AR & SO Invoices. They are on 2014 PU 4 Premium version of Sage. They have been using the same customized form codes in both AR & SO for years…
  • How to you link the SY_RoleSecurity table to the SY_Tasks table

    I need to link these 2 tables in order to see a report of user roles and related tasks. But there doesn't seem to be a clear link. The SY_RoleSecurity table has key field called TaskKey which ha values of 9 characters, whereas the SY_Tasks table has a…
  • Error #11: CI_UpdateDetailToIM.pvc

    Can you help with this error? Error #11: Record not found or Duplicate key on write Program CI_UpdateDetailToIM.pvc Line 1605 Object Method UpdateDetailToIM Object Text SO_SalesJournal_upd
  • Printer Settings Not Saving

    FormerMember
    FormerMember
    They have upgraded from 2014 to 2017 Std. Prior to the upgrade, they could change the paper size to 11x8.5 during Invoice Printing and it would save that paper size the rest of the day. Now, once they print, it goes back to Letter size everytime. They…
  • Sage 100 Premium - Connection to Crystal Reports

    We run just the Financials in our SQL version of Sage 100. Recently, none of my canned reports will run. The error: "The database login failed. Logon failed. Details [Database Vendor Code: 6]...Unable to connect: incorrect log on parameters..." This…
  • How do I get a pdf to appear while also printing a Sales Order with Paperless Office?

    My uses are accustomed to having a pdf pop up when they choose to print a Sales Order. With Paperless Office and the "pdf all" option it doesn't. And I can't convince them to go to the location on the server to retrieve the .pdf for emailing. Also, the…
  • AP Period End Printing

    I'm not sure if this is the right forum, but I am having issues with my period end reports printing when I process through AP. In the AP module, I click PE processing, then enter a date of the last date in the month I am closing. I keep the "print PE…
  • PO Printing received the following message:

    PO Printing received the following message: Unable to preview PO_OpenPurchaseOrder.rpt. Index was outside the bounds of the array
  • Job Cost Report Showing Mark-Up Labor and Contractor's Fee

    We have been looking for a report that will show the total job cost including labor cost at the marked up rate and contractor's fee for bid and time & materials jobs. Is there a report that will show those numbers? The only ones I have been able to find…
  • Some users suddenly can't print sales orders

    2014 Sage 100 3 out of 7 workstations today can't print sales orders. Message is "Unable to print salesorder.rpt. A generic error occurred in GDI + Any ideas? Rebooted server and workstations. Nothing new installed. everything fine prior to today…
  • Database login failed...issue with system.data.dll

    We are utilizing Sage ERP 100 premium 5.10.40. I have one workstation that keeps getting the following error any time they try to print or run a report: "The database login failed. Could not load file or assembly 'System.data.dll' or one of its dependencies…
  • Payroll deductions

    Deductions are automatically calculated but at times when an employee is on vacation, deductions are not calculated for that week for that employee. They are entered manually next pay period in addition to the automatically calculated deductions. What…
  • Business Insights Reporter Wizard Payroll Hang

    I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…
  • MAS90 and Excel 2013

    Can I use Excel 2013 with MAS90 version 4.5? We are upgrading to the current Sage 100 version, but I need to replace my computer before that is scheduled. Thanks for your help!