• 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?
  • Why are none of my checks/transactions that were entered showing up on the GL?

    I am brand new to Sage and my client has entered checks and customer payments throughout the year but when I look at the GL, I'm not seeing them anywhere. What's missing?
  • 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…
  • 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…
  • 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…
  • Pay AP Invoices with Bank Purchase Card through an upload to the bank

    have a client that wants to do the following... "Process AP invoices just like we currently do, but the vendor set-up will reflect it being a credit card payment (i.e. rather than live check or ACH). When we process the weekly AP batches, we will…
  • AP invoice discount due date pulled into selection despite it being past due and a discount date range set during selection

    We are having an issue with a specific 2% Net 30 Vendor whose invoices frequently arrive too late for us to make the discount. When we do our invoice payment selection for the vendor, the discount is applied. This happens even when we set a specific discount…
  • Is there an easy way to extract the number of payments to vendors in a given year? (annual payment count)

    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
  • Adjusting old AP invoices created through Receipt of Invoice

    We came across a few invoices that were paid in AP using our GL account for purchasing instead of using the Invoices that were created through Receipt of Invoice. I want to adjust these existing invoices that have been paid through AP, but not clear…
  • Quantity invoiced is larger than quantity received on a PO

    It looks like we have a big mess here. I was cleaning up the purchases clearing report and ran across the issue below. How can this be unraveled? We have already paid the invoice. We are not going to get another 5 items. As for as the cost paid for these…
  • ap invoice is already paid

    We voided a check and later were trying to void the invoice. We go into the Invoice Data Entry screen, enter vendor and then the invoice number and get a message that the Invoice is Already Paid. We select "ok" as it is the only option and it basically…
  • How do you merge duplicate A/P vendors?

    We have the same vendor set up in the A/P module twice. How do I go about merging them so the history is there? It will not allow me to make the vendor inactive as there is activity on the account. Thanks, Amy
  • Reverse AP posting with a PO

    I posted an invoice to a PO. Two days later, the vendor decided to give us a discount. I tried to adjust the invoice through AP, but that didn't work. I need to reverse the invoice, adjust the price and then reenter. Thank you! Jennifer
  • A/P aging

    How do people handle invoices that come in after the period has closed? Do you change the invoice date to the current period so the GL will tie to the aging? Or do you keep the invoice date as is, let it age out to the appropriate column, knowing that…
  • AP Invoice Register updated in wrong month but caught before GL posting

    Hello Sage Community, We have a situation where an AP Invoice Register for entire batch was updated in the wrong period, but the date error was caught before the Daily Transaction Register was updated. Is there a clean method to correct the AP module…
  • Invoices not available to pay

    We are running Sage 100, vesrion 5.20.2.0. We have invoices that haven't been paid, but when we try to pull them up to pay they are not available. However, if we run an aging report they are listed as needing to be paid. Any idea what is causing this…
  • Feedback on my process of entering Prepaid Expenses

    Hello, I have done some research using the SAGE 100 ERP built in help center, this community, and general google searches and it appears that the following process would work for recording a prepaid expense. The expenses related to this payment will…
  • AP Check register posted twice

    It appears that the AP check register posted twice in the same day. I didn't know that was possible. How do I unwind the double posting?
  • Reprint a check that has not been posted

    How do you reprint a check that has not been posted? I processed a payment for an NOF vendor, and I didn't enter the company name and address. I want to print another check with the company name and address. Jennifer
  • A/P - Vendor ACH - Import Banking Info?

    I can't seem to find this information anywhere. Sorry if this has been asked before. Is it possible to upload vendor's banking information into Sage 100 so that I don't have to enter them all manually for ACH setup? Thanks, SP
  • RE: G/L Detail Report vs. AP Expense by GL

    AFCACCPAY said: Before I contact my service provider, I thought I'd ask here. For several years in a row, we have some mystery amounts of $$ in accounts where they do not belong and we cannot figure out how they got there. We have no record of entering…
  • Entering in AP with sales tax

    Do you have to split out sales tax when you enter AP?
  • Discounts on AP

    I took discounts on invoices and the discount posted to suspense. 1. Where should they discount post? I assume an expense account. 2. How do I program the discount to go to the correct account?
  • A/P Invoice - Reversing a Credit Card Transfer that was applied to an American Express Vendor with an incorrect amount?

    Hello, We use the A/P Invoice Data Entry to transfer balances from product vendor invoices to various credit cards that have been used to pay off those invoices. While the A/P Invoice Data Entry is in the open status we can make changes to the invoice…