Invoice with balance of .01 Sage 300 CRE

SUGGESTED

I'm sure this has already been addressed.  I have an AP invoice that shows up on my register with a balance of .01.  I've followed the usual steps to correct any issues (i.e. tax vs. tax paid), and no matter what I do the invoice either shows up on my register or my select invoices to pay task.  This is an old invoice from 2011 so I can't void the check and correct it.  Is there a way to get rid of this or move it to history even if it shows a balance paid?

Details

Line 1: Amount 352.94  Tax 40.60       Amount Paid 352.94  Tax Paid 40.60

Line 2: Amount 823.53  Tax 94.75       Amount Paid 823.52  Tax Paid 94.75

I see the issue with line 2, however, nothing I do will correct this and it is currently showing up in the select invoices to pay task.  If I write a cheque to clear it, It throws the aging off again.  Any help would be appreciated.

  • 0

    Have you already tried entering an invoice for -.01 (negative one cent), and then paying both invoices with a zero-dollar check?

  • 0 in reply to JimFromBend

    Yes, and what it does is remove the invoice from the select invoices to pay task and adds it back to the payable register as being overpaid by .01.  This happens to a lot of our supply invoices and I can normally fix them fairly quickly, but this one is being stubborn.

  • 0 in reply to King Construction

    One more idea:  1) Enter an invoice for -.02 and then pay at -.01  along with the +.01 for a zero dollar check.    Test this to make sure it doesn't make the problem worse. 

  • 0 in reply to Rhonda V
    SUGGESTED

    Have you tried this?

    Cause

    There is a penny difference between an invoice's amount and its payment calculation  

    Resolution

    Determine the Amount and Amount Paid to make appropriate changes. Download and print the attached report, then use that report to correct your invoice as follows: 1.Download and print the attached report. See the link below for more information.

    Note: Click [Ranges] or [Conditions] to select specific invoices.

    2.Review the report and compare the following fields. Identify any that have a penny discrepancy. ◾Amount and Amount Paid

    ◾Tax and Tax Paid

    ◾Discount Offered and Discount Taken or Discount Lost

    3.In Accounts Payable, from the Tasks menu, select Change Invoices.

    4.Enter the vendor and invoice ID of the invoice you want to correct in Change Invoices.

    5.Adjust the Amount, Tax, or Discount on either the invoice or distribution level to equal the corresponding payment field which appears on the report.

    6.Change the Accounting date if the invoice is for a closed period.  

    7.Accept your invoice or distribution changes.

    8.Select to use Revised accounting date for the reversal. Click OK.

    9.Click [Finish].

    10.Click [Start] to print your journal to a file or printer.

    To prevent this from happening going forward, when entering the the invoice, do not enter the tax amount at the invoice level.  The number will prefill from the distributions once the invoice is Accepted.

  • 0 in reply to nowwhat

    Thanks.  Yes, I have used this method several times in the past and it usually works.  In this case, it isn't which is quite baffling.