• 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…
  • How to Process Online Payments through the AP Module

    FormerMember
    FormerMember
    Hi all, I'm a new user to Sage 100 and I have a question regarding online payments and processing them through the AP module. I process a wide variety of payments through online portals and the process in place has always been to book them through the…
  • 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…
  • Change the length of a Manual Check Number

    Hi there, Is it possible to change the allowable length of a manual check number? I want to use the format VMMDDYY (where V is the vendor initial), as I write manual checks for several vendors who I pay by credit card or wire, then record in MAS via…
  • how do I assign an ap invoice to a department

    FormerMember
    FormerMember
    We have set up departments for each location for reporting purposes. How do you code an ap invoice to a department?
  • 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…
  • Looking to print invoice detail lines on check stub

    Looking to print invoice detail lines on check stub however I have not been able to determine which column in the AP_CheckStubWrk table contains the information that I am looking for. I have attempted to link the work table to the AP_InvoiceHistoryDetail…
  • Cannot print batches of AP checks in Windows 10

    Since I received my new computer with Windows 10 I cannot print a selection of AP checks. It only prints the first couple and then it stops. The spooler only shows a couple and then stops. I keep canceling the job and then starting again. If I hit it…
  • Concur Standard for 100 ERP Sample Upload

    Hi Everyone! We are going to be using Concur Standard to handle our company credit card expenses. The Concur rep told me to contact Sage and ask for a sample input file so she can customize our upload file to Sage's specification. I contacted Sage…
  • Voiding both Check and invoice in accounts payable

    We are working in Sage 100c. We void a check through checks/manual checks entry. When entering the check to be voided: System ask is this a reversal - we say yes, then system prompts do you want to recall the invoice - if we say NO - it still shows…
  • Cost Codes on PO does not match Cost Code on invoice

    FormerMember
    FormerMember
    We utilize codes codes on all our projects. Project Manager open Purchase orders with specific cost codes. However when Accounting enters the invoice against the PO the cost code defaults to one code, then we would have to lookup the cost code on the…
  • AR Customer is issuing joint check to our AP Sub/Suppliers - Can someone please help?

    FormerMember
    FormerMember
    Working with a contractor(AR) that is issuing joint checks to our Sub/Suppliers (AP). Have entered inventory through the PO module (Ordered, Received, and Invoiced), and now has flowed into AP. Have entered Revenue Receivable through the JC module…
  • AP Automation

    Has anybody had success automating their AP through a 3rd party solution? We are currently looking at Altech DocLink to do the data entry and help control/oversee approvals more efficiency. However, I'm hoping to get some feedback from Sage 100 users…
  • 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
  • Delete a Sage created invoice

    I reversed one entry too many times and Sage created its own invoice with the same check number making my AP off. How do I fix this. The balance shows zero on the invoice but the invoice is open with a negitive amount. Invoice No. lnv Date lnv Due…
  • Sub ledgers don't match financial statements

    I am new to Sage. I am reviewing books for a client and find that none of their sub ledgers (A/R, A/P or Inventory) match the financial statements. In QuickBooks I know how to trouble shoot these; but not so in Sage. Can someone point out the common mistakes…
  • In Accounts Payable, how do I limit a user to only certain vendor number access?

    I have a shared vendor masterfile between multiple locations within our business. There are a handful of vendor numbers that only are used by corporate finance people and I don't want other users to be able to do an inquiry and see them? Is there anyway…
  • 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…
  • Error 41 closing a/p. .

    Line 797 program ap_periodendprocessing Sage 100 2016. Last key in info is an invoice. Any ideas. Rebuilt keys. That record looks fine in dfdm.
  • 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…
  • checks posted to wrong month

    I posted checks in the wrong month can I reverse the post and re-post in the current month?
  • Mass Vendor Name Change (From Check Name To Alphabetical)

    We have been doing vendor imports for all of our patient refunds and I just noticed a problem. Since we want the check to be made out to "John Brown" that is the column that is imported. However, although the checks come out correctly, the Vendor Name…
  • 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