• Vendor has new FEIN. Do you create a new vendor?

    That's it, really: when an existing vendor provides a new FEIN via their W-9, do you prefer to A. update their FEIN in vendor maintenance and carry on, or B. create a new vendor to account for the new FEIN and deactivate the old vendor?
  • Vendor has a DBA name on W-9. How to record in vendor maintenance?

    When a vendor's W-9 lists company and/or personal names in both boxes one and two, what is the correct way to record this information in vendor maintenance? In other words, what name should go into the Name slot in VM? Or, should the two names be split…
  • 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…
  • Post Dating Accounts Payable Check to a future date

    We would like to print checks on the 30th but have them posted to the 1st of the next month, can we do this and have it posted in the next month as well? If we can, how would we do this? We want to do this because the rent invoices are for July but…
  • Finding the number of invoices entered in AP? AP Analysis Report is showing data from a previous year. How do I change the periods it is pulling from?

    I'm trying to find out how many invoices are being entered by month/period. The generic report JAccounts Payable Analysis Report shows this information, but it is showing me data from year 2022, May through October. How do I change the date range? Or…
  • Duplicate imported payments

    We imported manual check entry payments via the Visual Integrator module. Accidentally uploaded twice, and now have duplicate payments posted. They're exactly the same, down to the same check number. Can I delete the duplicate? Or will I have to void…
  • When drilling down on an "MC" source journal, it brings up Payment History Inquiry instead of AP Invoice History?

    Hello all, I am looking in Account Inquiry at AP and MC source journal entries. Drilling down on AP entries brings up AP Invoice History information. However, drilling down on an MC entry brings up only Payment History Inquiry. Does anyone know why…
  • 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…
  • Need to set up backup withholding for a Subcontractor in AP

    Is there an easy way to set up backup withholding for a vendor in AP? We need to withhold federal backup for a subcontractor.
  • how to record prepayments for assets or Pro-forma invoices

    we frequently need to make wire payments in advance of receiving an invoice, non-inventory items. We record the wire as a manual check. We have had duplicate payments to vendors as we've lost invoice # being the control. When I view the vendor inquiry…
  • AP to GL Reconciliation

    When reconciling AP to the GL and using the AP Trial balance, does the invoice date have an impact on differences? As I understand it using the AP Trial balance goes by transaction date which is the GL posting date. I'm reconciling day by day and sometimes…
  • Selected a/p invoices do not stay selected when selecting by invoice number

    Version 7.0.4 Sage 100 Use Check maintenance to select invoices. Pick a vendor and enter 3 invoices to pay. All are selected and the total of three is at bottom of screen, Go to print a check and only 1 or 2 of those invoices are on check. Realized…
  • Looking for timeline of 2022 1099 changes.

    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.
  • AP Aged Invoice line doubled the amount

    I am trying to correct some dating issues between transaction date and invoice date being in different years. I went through AP-Invoice Data Entry, using the incorrect date, and used the same invoice number with a negative amount. Then I re-entered the…
  • Check History Full error 16 during a/p manual ck register update

    Voided checks filled up check history in updating manual checks register producing error 16 file full. Sage 2021. Reason -Owner decided to use the expanded check number to prefix the division to the previous check number sequence creating millions of…
  • AP and Cash issue - An invoice was paid once by check and a second cash ACH sent after the check didn't clear, then the vendor refunded the overpayment

    We paid an invoice three months ago by paper check for say, $100. The check didn't arrive to the vendor, and so we then paid the invoice by ACH for $100. The ACH cleared, and then they also received and cashed the check. When the vendor realized they…
  • the update was interrupted. select the journal program to continue the update

    I have a client that gets the message 'A file is in use by another task. Update will continue to retry until record "" is available' when trying to print the Invoice Register in AP. There is no one else in AP. If you shut down and go back in you get the…
  • No Data to Print when trying to print 1099-NEC

    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…
  • 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…
  • Unselecting invoices to be paid

    Our bookkeeper passed away last week, I was trying to pay Friday checks, I accidently selected checks I did not want to pay, is there a way to unselect them. I have not printed checks. I am not sure what category or subcategory to choose. I am new to…
  • AP Check voided using the wrong date.

    We accidently voided a few AP checks using the original issue date instead of the current date (the GL posting date is correct). What affect does this have on our financial reports? Should we reverse the void and re-enter using the correct date?
  • Delete vs inactivate old vendors

    We have a very large amount of old vendors in Accounts Payable. I am trying to decide whether to delete or inactivate them. What are the pros and cons of each? I really want to delete them, but I am afraid I will regret it later. Any advice is greatly…
  • 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…
  • Adding AP Check Forms to Multiple Companies

    I entered AP Payment Processing in Company "A," created a new Form Code, and used Designer to create a new custom Check. I have 10 other companies and would like to copy the custom Check to all of those companies. I think I'm supposed to use Report Manager…
  • 1099-MISC box 3

    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?