• Check Customer Balance while Backdating

    My company has two departments, the main account dept are doing a process called Backdating. While they do this, another department is doing customer lookups for their current balances. The issue is when the main Account Dept is doing the backdating;…
  • 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…
  • 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…
  • 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.
  • AP GL Reconciliation-How TO?

    I am a very new user and am trying to reconcile my AP GL balance to my AP Aged Invoice and AP Trial Balance. What are the steps to do so? In previous systems I have used, you could reconcile an account like this by reviewing the "schedule" for lingering…
  • 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 Check selection displays duplicate phantom invoice

    Sage 100 2021 PU3 Advanced. After selecting vendor invoices for payment, then going into the check maintenance window, duplicate invoices display. However, the invoices are only entered / posted once. If the phantom invoice is not removed from the check…
  • Vendor List won't autopopulate. What am I missing here?

    Hello, all! Here's a small, odd thing I'd like to resolve for a colleague. When I access AP>Vendor Maintenance or Inquiry>Lookup (magnifying glass) and the Vendor List pops up, the entire list of vendors unfurls itself. When my colleague does this, the…
  • 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…
  • Prepayment of Invoices

    We have made a prepayment to a vendor. How can we record this prepayment and the subsequent entry of invoices to relieve the prepayment?
  • 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…
  • AP invoice posted with wrong invoice date

    We have several AP invoices entered with the wrong invoice dates (dated 11/30/2025 instead of 11/30/2020). The GL posting date is correct. Some of these invoices have been paid. What is the best way to correct this? I am using version 2018. Thank…
  • Check Printing Setup Stub Check Stub Sage 100

    How do I change the Check Print Set Up in SAGE 100? It is currently set for Check, Stub. I need to Change to Stub, Check, Stub and retain that setting for the future. Currently have to change it every time check is prepared. Thanks - DJS
  • Accounts Payable Invoice History by Receipt Date

    Hi, How can we change the report for Accounts Payable Invoice History invoice date to use Receipt Date instead? Thank you, Tea
  • AP/PR ACH Email address

    FormerMember
    FormerMember
    If one person prepares AP ACH transactions and another person prepares PR Direct Deposit, can you have two separate email addresses to send the receipts or is it all under one? I noticed that when I change the email in the payroll module I see it carries…
  • 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…
  • Import batch of similar invoices via Visual Integrator for A/P Invoice Data Entry?

    For context, I tried searching these forums for at least an hour to find an answer on this, but the only active discussions that popped up were 8+ years old. Either I was using the wrong search terms, or this is an uncommon issue. Apologies in advance…
  • Invoice adjustment

    How can a adjust the amount of an AP invoice when the invoice is already in Sage?
  • Is there any advantage/disadvantage to numbering vendors with numbers or using alphabetical?

    Any suggestions on whether it is better to use numbers or alphabetical method for numbering vendors? We can use 1, 2, 3, etc, or we could use the first letters of a vendor's name? Thanks.
  • 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…
  • Is there a way to produce a remittance advice using AP manual check and payment?

    Is there a way to produce a remittance advice when making payments using AP manual check and payment? We are not set up yet to pay ACH's through Sage check printing and electronic payments, so we are entering ACH payments through manual check and…
  • Paperless office works for GL reports, AP reports, but not for AP invoice entry and invoice register?

    Paperless office is working for GL reports, AP reports, but I can't seem to get it to work with AP invoice entry and invoice register. I"m using Sage 100 premium 2017. I went under Paperless Office module, Setup, and Journal and Register Maintenance…
  • Looking for a Sage100 table for General Ledger with invoices history data.

    Dear experts Using Excel need to pull the data that the general ledger detail report displays but I need to add invoices number, invoice date, comments... what tables in Sage 100 gives me: GL Account Number, description, Date, Journal Comments…
  • Select Invoices for Payment

    Hi - new here. Looking for a bit of help. I am trying to use the "Select Invoices for Payment" window that pops up from the "Check Printing and Electronic Payment" function. My understanding is that you can use this window to post A/P to the general…