Is there a way to remove credit card vendor from showing on an AP Aging Report

SOLVED

Hello Everyone, 

1) Here is what I've done so far, I setup a new vendor called 'American Express Credit Card', clicked the box to assign itself as a Credit Card Vendor. 

    Options> Accounts Payable > Assigned it to a GL called Credit Card Payable (Current Liability Account) 

2) Created a new AP payment term: 'Credit Card American Express' for entering in individual vendor invoices, assigned it to the Vendor created in Step 1

3) Created a new vendor to assign the Amex Charge, Changed the terms of that vendor to match Step 2

4) Entered in the invoice for vendor setup in Step 3

For some reason, these are still showing up in my AP Aging Report. Is there a way to remove all credit card vendors from our AP Aging Reports? Or specify a GL when running the AP Aging Report. 

Thanks in advance! 

  • 0
    SUGGESTED

    AmericanPropeller-

    It sounds like you may not have used the correct term when you created your new invoice.  When you created the invoice in step #4 what term did you use?  did you use the term set up in step #2?  If not, then you will need to go to:

    AP, Checks, Enter Payments

    • Select the vendor
    • For the 'Type' select Credit Card
    • Select the credit card vendor you used to pay the invoice
    • Enter reference text NOTE: This is required and will become the invoice # for your credit card vendor
    • Select the invoice(s) to pay
    • Post

    Thanks,

    Coleen

  • 0 in reply to Coleen Graber

    I confirmed I used the correct term when entering in the invoice. When I pull the AP Invoice Distribution report, the credit card vendor (American Express Credit Card) Credits and Debits the 'Credit Card Payable' GL, while the invoice for the vendor we want to pay using the credit card Credits the 'Credit Card Payable' G/L account and Debits the expense G/L. 

  • +1 in reply to AmericanPropeller
    verified answer

    That does sound correct.  The purchase vendor invoice should be closed and an invoice for the Credit Card vendor will be open.  (It basically transfers the balance from the purchase vendor to the credit card vendor).  So if it is the Credit Card vendor that is showing the open invoice on the aging, then that is correct.  There is no option to run the Aging by a GL #.  There is no easy option to exclude a vendor from the Aging report - unless you rename the vendor ID to appear at the bottom of the list...for example ZZVendor...then when you run the Aging and on the 'Include all vendors' option select your range of vendor for vendors A through Y, excluding the Z's.  Otherwise, you may want to call support to discuss this issue further.  The support number is 800-447-5700.

    Thanks,

    Coleen

  • 0 in reply to Coleen Graber

    Thank you Coleen. I was hoping I was doing something wrong, but it would appear to be a system limitation. Thank you for your time.