Browse By Tags

  • AP - how to remove invoices with $0 distribution?

    In Accounts Payable How to I remove $0 distribution in invoices? These invoices shows up in "invoices to pay"
  • Transferring a credit balance

    How would I go about transferring a credit balance from one Vendor to another in Sage? We work with a Vendor that has a Concrete business and a lumber business and our records have each of these subdivisions as a vendor in Sage. Currently we have a…
  • 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…
  • Error 5 in frmPeriodEnd AP close out.

    Attempting to close out company P (first time) and receiving the subject message. Tracer messages: 13:48:59(5652836 - 46059448)-****** ENTER InvokeTask :Task ID - 67895298 13:48:59(41 - 46059489)-"Process Period End" - Task Flags, EFW_TF_AUTOLOADUI…
  • AP Module closing

    After inventory is changed to balance adjusted, payments made against inventory are still being made in a subsequent period. Those payments can produce PPV (STK) transactions when they differ from the PO amount. We would like the PPV to stop posting to…
  • Invoice import through visual integrator not hitting ledger accounts

    I have been trying to import invoices from one vendor through the visual integrator, I can pull up the invoices in vendor maintenance in accounts payable but the transactions are not posted to the ledger accounts. I visited invoice register to post but…
  • Finder Feature

    Hi All, New user to "Sage". I am trying to determine whether or not there is a "Finder" in Sage 300 AP Module that is similar to the Finder in QB Desktop. Right now I go into my Invoice or Vendor Inquiries to do my searches. Appreciate any assistance…
  • AP and Job Distribution

    How do I correct where the retentioin amount was entered to the discount instead of the retention on the job distribution line when entering an AP invoice. This invoice has been paid. I need to correct the amount paid show in the job too. Thanks.
  • Printing Journals for AP only

    Is it possible to set up to print journals for AP only? If so, I need to the journal to not only print but also be able to save it to a file. Thanks. Jannice
  • 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.
  • How to fix retainage after printing a partial check?

    When cutting a partial check for a commitment, it always messes with the retainange, leaving some of it in the Outstanding AP column and it should be in the retainage column. There are very few options to correct the retainage when cutting the check.…
  • Filter payables

    We have vendors that we have hundreds of invoices that we pay. They are not in numerical order do to their different depts billing. We have to search thru all these sometimes several times to find the invoices we are paying, and usually this is 50-100…
  • Credit Card Entry Methods when using Cash base Accounting

    Hi, I've read the knowledge base "How do I pay invoices with a credit card and then pay the credit card agency?" We follow this process which involves creating 2 separate Invoices and paying them out (one to the vendor and one to the credit card company…
  • How can I clear old invoices without affecting the GL?

    Hello, I need to clear old invoices however I need it to not impact the GL balance as the accountant said most of those payables are not in the GL anymore. Thanks
  • 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…
  • Open Credit on Credit Card vendor

    Hello, My boss recently overpaid on the balance of the business credit card and I ended up putting the remainder into open credits so that our bank statement would balance. When I applied some of the open credit to an invoice, the next time Payroll…
  • Check Envelopes

    We use Sage checks for payroll and AP and we were told by Sage that the envelopes are on backorder and its unknown when they will get anymore. Does anyone have a compatible check envelope for Sage product RN DWE323. I’ve been to Amazon and Office Depot…
  • 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…
  • Sage 200 Evolution Intercompany Integration AR into AP Tables / All other transactions

    Hi There. We are discontinuing a service with one of our Sage consultants. We wish to take on Transaction integration inhouse (SQL environment). What is the best way to go about this? Do we have to use a consultant, or can we adapt this technology…
  • AP Credit Note- Multiple Entries for GL account AP Trade

    Using Sage300 2020 - SAMINC a credit note was created for vendor 1350. The related GL journals seems a bit strange to me. See attachment. There are 5entries for the payables account, Why? https://drive.google.com/file/d/1Uck4Gtx_mNkBP2ctxkg7ZGDI9AV…
  • AP Report with Check Number, Job Number, AND Invoice Number???

    Does anyone have a report that runs AP invoices by job AND includes the check number and check date? I found the A/P Payment Register by Job but it doesn't include the Invoice Number(s) and I'm not savvy enough to adjust the report to include the invoice…
  • 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…
  • Looking to Export AP Payment Transaction History-System Limiting Export

    When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…