Sage 100

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…

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…

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 …

Hello, For one PO we received two different invoices since products were shipped separately. For a line that was for the sales tax, it was used twice when receiving the two invoices instead of a second line being created for the second invoice's sales…

I made the mistake of not printing any of my period end reports in AP Module only. I closed all the periods through period end processing. Is there a way I can print these reports now?

I had entered an invoice in AP → Invoice Data Entry instead of using PO → Receipt of Invoice Entry. When I run the Open Purchase Order Report. The PO is now Backordered and it shows as the item being ordered and received, but not invoiced. The invoice…

Appears that our friends at the IRS are going to require a new form this year. Where is Sage with the modifications to track this information? Hope to not be scrambling at year-end getting folks updated to accommodate the new forms.

We have checked to make sure the data on vendors requiring form 1099-NEC have the appropriate year, form (NEC), and amount in accounts payable maintenance. We made sure the A/P options showed 2021 as the current year. we made sure the 1099 report in A…

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

If customer is running Sage 100 2014,2015,or 2017, will IRS accept Box 3 Other Income for Non-employee compensation because 1099-NEC is not an option?

Is it possible to get a Active Vendor List? Lets say vendors that have been paid in the last 3 years?

I've run into this issue occasionally for at least the last couple of years. Say, for example, that I'm posting a batch of Invoices in Accounts Payable while my coworker is posting a batch of Cash Receipts Entries in Accounts Receivable. I post my batch…

We just updated crytal reports from 2011 to 2016 version. Do we have to convert any reports that we changed with crystal reports to work with the new version?

Just a heads up - in v2019 an additional header was added to AP Aging Report. There are now 2 headers. Page header f and Group Header 2 If you do NOT have divisions and run the report sorted by the default Vendor Number, both headers are suppressed…

Good morning! I need a hero to save me today. I need to give the assets for the 2008 year to the CPA. I need to generate a query in Excell but I do not know what table or fields to pull so it gives me GL Account Number, description, Date, Journal…

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…

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…

Hi, In Sage 50, I was able to pull a report showing me all the payments we made to a particular vendor quite easily, but in Sage 100 I'm not sure how to go about it. I would like for example to see what we've paid to Vendor XYZ from August 1, 2018 to…

Hi. I am having an issue with electronic delivery or PDF storage of remittance advice for paperless office. It saves and delivers by email BLANK page for PDF instead of the data. When printing to a printer it prints just fine but when saving to PDF…

our bank is asking us to supply information from our master vendor file. one of the fields they ask for, per vendor, is annual payment count. Is there any way to extract this data into a report or somehow using explorer? thank you

Here's the scenario ... we have an A/P invoice posted in our system with a 4/30 date. A wire transfer was made, dated 4/15, as payment of this A/P invoice. Logically, I would think that if an aged payable report was run any time between 4/15 and 4/29…

Sage 100 ERP 2015 Update 4 We have multiple companies. When printing the weekly AP checks for all companies ONLY ONE COMPANY gets the "Sage 100 System Stopped Working" error message. This is a regular error message that happens every week, but ONLY…

This is our first year to print 1099's out of the system. Does the system print the whole 1099 form or do you need to purchase the 1099 form and then the information will print out on it?

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…

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…