• 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 …
  • Is there a report that distinguishes between credit card customers and Net 30 customers who pay by credit card?

    Hi, I'm doing an analysis of credit card fees, with the intent of beginning to charge my Net 30 customers a fee for using a credit card to pay their invoice. I doubt it's possible, but is there some sort of report, or series of reports, I could run that…
  • How to find the cause of variance between invoice total and the number on income statement ?

    Hi, I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…
  • 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
  • Printing an adjusted Invoice in AR

    I have an invoice that was posted without freight added, so an adjustment was successfully processed to the specific invoice. I'm trying to find a way to update paperless office with a new PDF that reflects the adjustment, or some sort of means of sending…
  • How can I produce an AR Aging report that ONLY shows customers that are delinquent?

    How can I produce an A/R Aging report that ONLY shows customers that are delinquent? Thanks!
  • Upgraded from 2017 to 2018. No AR Rep Code in Statement Printing.

    Hello, Our company recently upgraded from SAGE 100 2017 to 2018, and we have an employee who is trying to do Statement Printing. He reported that the field "AR Rep Code" is no longer under the Selections area on the Statement Printing panel, while it…
  • 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…
  • AR Reports

    Question, I need to run a report showing what I billed our customers for the month of December 2016. But I need to choose customers who only purchased certain products. Which report do I need to run? I'm starting to confuse myself. Help!! Thanks.
  • Setting default settings for statements printed on invoice data entry

    As it stands when I print statements entered on invoice data entry its automatically defaulted to "partial" comments, I want it defaulted to be "full" would anyone know how to do this? Thanks in advance.
  • 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…
  • 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!