• Transfer A/P invoices to GL account - P card

    FormerMember
    FormerMember
    We recently began using P-cards to pay some vendor invoices. Our idea was to transfer AP invoices to a GL clearing account in order to wash out the AP invoices paid by the P-card and then when we pay the P-card, it would then wash out the GL clearing…
  • 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?
  • How can I change the job/description field on my check to be longer?

    When printing my AP checks, I cannot figure out how to change my description field to be longer. I can change where items appear on the check portion, but I cannot change the length on the stub.
  • 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…
  • Sage 100 : PO with custom Charge LineItem is missing in Receipt of Goods

    Hi, I have a query on PO and Receiving module. When a charge/expense line item is created in PurchaseOrder and a Receipt of Goods is created against it, those lines are not adopted in receiving. However when I manually add a new charge Receipt of…
  • 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…
  • Attempting to print checks pulls up a different user's report?

    We have an employee who was trying to print his check report (Invoice Payment Selections), and after selecting the customer and the corresponding invoices, he selected proceed, and then went to print. However, when the preview popped up, an unrelated…
  • Accounts payable options. This task is in use by another user. this task can only be viewed

    We are trying to do our 1099's and get this message, "This task is in use by another user. this task can only be viewed". So I tried going into Accounts payable options and get the same message. Will the physical count lock that up or what else would…
  • 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?
  • Report vendor payments by specific vendor and date range? How do I do this easily?

    Hi, In Sage 50, I was able to pull a report showing me all the payments we made to a particular vendor quite easily, but in Sage 100 I'm not sure how to go about it. I would like for example to see what we've paid to Vendor XYZ from August 1, 2018 to…
  • VI Import into AP_InvoiceHeader

    I'm attempting to import an invoice using VI import and encountering a "HS Record Invalid or Write Failed. The Vendor Number is Required" condition. I've confirmed that the Vendor record exists but it continues to fail on the import. This error also…
  • Custom Script to Run with AP Posts

    I need an executable to run when the client Posts AP Batch to the Invoice Register. I cant add a user defined script to the AP Invoice Registry screen because i cant get to it with Customizer. Is there a way to get around this?
  • 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…
  • custom reports filter by time stamp

    Good morning, all! A couple of years ago I made a custom report that shows all our unpaid payables. I currently have one filter on it, the DateUpdated field, so I can narrow it down to a certain day(s). Since that is my only filter, I have to wait until…
  • Any way to add filter criteria to Invoice Payment Selection?

    I'm looking to mark credit card invoices and then weed these out easily during AP invoice payment selection. I have not been able to add a UDF or think of another way to accomplish this. I tried adding the UDF field to the invoice payment listing table…
  • Zevez RewardWorks

    Has anyone used Zevez RewardWorks? It is a third party add-in product that interfaces with Sage 100 Accounts Payable to assist with making credit card payments. We are considering using this product and would like to get input as to how well it works…
  • Vendor number lookup

    When I go into Vendor Inquiry (or Maintenance), under the Vendor Number field, it won't look up using the vendor number, only using the vendor name. Is there a way to fix this in my settings?
  • Reprinting journals

    Does anyone know of a way to reprint journals? I need to reprint the accounts payable posting journals. I tried to go in through the General Ledger reprint journals but no such luck. Any ideas? I'm trying to reconcile my AP account and need those reports…
  • AP Vendor Maintenance Invoice only showing Invoices for this year

    Hello I am running MAS 200 Version 4.40.0.6. Today I was notified that in AP Vendor Maintenance Invoice tab as well as Transactions tab we can only see Invoices for this year 2016, for all Vendors, even if they have many more invoices from other years…
  • 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…