Open Invoice Register showing invoices which is fully paid.

SUGGESTED

Dear Team ,

 We have a scenario where for some vendors, some invoices appearing in open invoice register which is fully paid , Attaching screenshot for one vendor for your reference , similarly we have few vendors as well .

Thanking in advance ,

 Salim

Tamcon

  • 0

    Hello,

    I would check if these invoices have an extra "distribution" line item with 0.00 value.  Delete that line using change invoices.

    Had this happen to me once, it may or may not be the cause but worth a try.

    Good luck!

  • 0 in reply to Virliza Solis

    Dear Virliza Solis ,

     Thank you for your quick response . As you explained , I checked for distribution and found that 0.01 tax distribution present . I managed to delete the distribution for except one , for which distribution is 0.02 . It gives error as below

     How to get rid of this ?

     Thank you in advance !!

  • 0 in reply to IT Tamcon
    SUGGESTED

    The error is informing you that you cannot reduce the tax amount below what has been paid, $0.02.  Therefore, change the tax amount to $0.02 rather than $0.00.

    Art MInds
    Senior Independent Consultant
    Pasadena, CA

  • 0 in reply to ArtMinds

    Dear Art Minds ,

     The original amount is 0.02 , i was trying to make it 0.0 since small amount showing me in unpaid list in open invoice register as shown below .

    Here tax amount is 0.02 . Invoice is already paid , but system showing unpaid / partially paid .

  • 0 in reply to IT Tamcon

    Rather than use your report, go to the Inquiry menu in AP, and choose Invoice Inquiry. Drill down on the Vendor and Invoice to display all distribution items for the invoice to see where the unpaid detail resides.  Sometime you have to enter a zero payment amount using a dummy check number to clear distribution items that have offsetting positive and negative open amounts.

  • 0 in reply to IT Tamcon

    Salim, I didn't realize this was your message.  When you see invoices on your "Open Invoices" list that show the amount and payment amount are the same with a zero balance, it's usually because there are invoice distribution items that remain open, so the correction lies at the distribution level and most likely payments were applied in a way or "change invoices" was used after payments were made that leave unpaid distribution line items.  It's mostly a "status" thing, Let me know if you have additional questions after you review the distributions in an inquiry for the problematic invoices.

    Art Minds