• 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…
  • 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
  • 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
  • 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…
  • 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?
  • 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
  • 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?