Sage 100

We had 2 checks stick together during check printing. I did not notice we were off by a check number until I had printed and posted the batch. about 40 of our 78 checks printed are off by 1 number. How do I fix this? Do I have to void them all and reprint…

Hello, I have been asked to copy the Report Setting that a specific employee that is no longer with the company had created and to bring it to the main company's account. The reason for this being is that the company's account, for some reason, is printing…

We have multiple companies that ultimately rolls into one set of financials. Company A accidentally paid invoice #1 for $100.00 when invoice #1 actually belonged to Company B. Company B also received and paid for invoice #1 already. Company B wants to…

Hello everyone, I was wondering if it is possible to edit a PO quantity ordered in the lines tab without having to reverse the receipt of invoice. From everything I learned, I always thought we had to create a reverse receipt of invoice first, then…

In Vendor Maintenance we see a vendor with 2 balances due. But in the check printing invoice payment section the invoices have $0 balances. We need to pay these bills, but are unable to. The payTodayFlags are set to no, because the payments got backed…

Within the AP Options - Entry- we have checked the box for Increment Next Check No. When Changed During Printing under the Manual Check Quick Print header. Our AP analyst has to manually advance this field when performing ACH payments. Does anyone know…

We need to have the ability to use Penny Test to verify bank accounts for a vendor instead of Pre-Notes. There are too many ways that fraud can occur by just using Pre-Notes. I created the following idea. If you agree, please vote for this. www5…

We are on Sage 100c Advanced v2019.2 We electronically paid 2 AP Invoices with 1 E-payment. The second invoice should not have been paid against this vendor. When we go to reverse payment, the total amount can't be changed to reflect only the 1 incorrect…

I have discovered that I have some invoices that have been paid, but the invoice is no longer showing up in transactions or history. The payment is there though. I'm not sure what happened but it puts my expense GLs out of balance. What could have happened…

For some reason quite often when i do a receipt of goods invoice a few days later the invoice shows for $0 with lines "0" invoiced. I do multiple invoices in batches and i always make sure that the quantity being invoiced matches what we received and…

Hello, Nobody use below t ransaction (#A000815 N ). But Sage100 said 'Record(A000815 N) is in use by another user' as shown below. I would be grateful if someone let me know. Thanks!

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

How to enter a deposit payment without applying an invoice?

Hello, I have a client who currently generates ACH files from Sage to upload into Bank of America. Bank of America mentioned being able to integrate with Sage, however, after searching online on how this would would or if anyone has done this before…

We are having an issue with Accounts Payable vendors. When I open Vendor Inquiry, and I start typing in the name of a vendor, the list will populate. Usually, I can find a vendor this way with no problem. However, I have been told there are several vendors…

i have created a VI Job that I am trying to use to reverse a large amount of checks. Each check has one invoice. I do not want to recall original invoices but create a distribution amount to a GL acct. When the job is ran it automatically recalls the…

We are migrating from Sage 50 to Sage 100? And in Sage 50 the "Waiting on Bill" feature allows you to get your costs (freight, Inventory, etc...) into payables without having an Invoice number. I have 6 freight Bills (Waiting on Bill-Do not have Invoice…

When running checks using blank check stock in accounts payable, we've had it to either skip a check number or go back and reuse check numbers. I am baffled as to why this happens? Would recalling another payment that is not a check itself cause the…

Our client enters their AP Invoices by batch. They also want to Select and Print their checks by batch. When I go to Invoice Payment Selection, by batch is not one of the choices. Is this possible? I cannot seem to find this option and am wondering what…

I used visual integrator on a test company to try to renumber an AP vendor. I used AP Vendor Master table, downloaded a copy, changed one vendor to test, and uploaded. This worked to create another vendor with the new number, however, the original vendor…

When the AP vendors were originally setup, they didn't leave enough space for additions. I'm considering re-numbering. We have hundreds of vendors. I'd also like to number any duplicate vendor in different companies with the same numbers. What…

I'm running Sage 100 Premium, 2017. I am not using PO's. A vendor wanted us to forward a payment to them before we have invoices. Also, the advance will end up being less than the total we pay to the vendor. (Example: we prepay 1,000, but the invoices…

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…

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…

Hello everyone. We are an E-Commerce Distributor and Furniture Importer located near Chicago IL. We are currently looking for a consultant that can come in, review our Accounting procedures and see if we are utilizing Sage 100 to its fullest potential…