• Balances due under vendor maintenance, but in the check printing invoice payment selection, the invoices have $0 balances

    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…
  • Anyone needing to set up Penny Test processes in Sage 100?

    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…
  • How to reverse AP check/electronic payment against 1 of 2 invoices

    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…
  • Paid invoice not showing in transactions or history

    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…
  • in use by another user_Manual check and payment entry

    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!
  • Active Vendor List

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

    How to enter a deposit payment without applying an invoice?
  • Does Sage 100 integrate with Bank of America's CashPro?

    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…
  • Accounts Payable Vendor not showing in the Vendor Inquiry by searching, but shows up using the spyglass

    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…
  • VI Job into Manual Check Entry (Reversal Checks)

    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…
  • Does a "Waiting on Bill" feature from Sage 50 exist in Sage 100?

    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…
  • Why would accounts Payable occasionally reuse check numbers when printing on blank check stock?

    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…
  • Is it possible to print AP checks by batch? Or is there a different solution?

    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…
  • Visual Integrator - how do I renumber a vendor and delete the old vendor number?

    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…
  • What is the easiest way to re-number vendors?

    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…
  • How do I enter an advance payment in AP and have it show as a credit? Also without messing up 1099 info?

    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…
  • to link AP INVOICE HISTORY to a General ledger Detail Report...tables names?

    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…
  • paperless office

    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…
  • AP Batch Processing

    When I go into AP setup options> entry there is no option to enable batch processing. It's blank... but the option is there in another company we have. I looked at both side by side and the only difference is how long we retain history. Help?!