A paid invoice appears open in Accounts Payable (0.00 distribution with unaccounted Tax Liability)
Description
Cause

The invoice has a distribution with zero (0.00) Amount but has an amount in Tax Liability. When the other distribution(s) on this invoice were paid, this distribution was not included so that Tax Liability Accounted did not get updated and the distribution Status remains Open.

To confirm:

  1. In Accounts Payable, select Inquiry, Invoice Inquiries, Invoice Register.
  2. Select the Master file, then click OK.
  3. Select the Register file, then click OK.
  4. Find the vendor, then double-click on the vendor to drill down to the invoices.
  5. Find the invoice.
  6. Add a column for Status.
  7. Double-click on the invoice to drill down to the distributions.
  8. Add columns for the following:
    • Status
    • Tax
    • Tax Paid
    • Tax Liability
    • Tax Liability Accounted
  9. Review the distributions for which distributions have a Status of Fully Paid and which have a Status of Open. If the only distribution with an Open status has an Amount of zero (0.00), has an amount in Tax Liability, and zero (0.00) in Tax Liability Accounted, then this issue applies.
Resolution

To get the Tax Liability distribution updated as Fully paid

Change the distribution and enter .01 in the Amount then add a new distribution coded the same as this Tax Liability distribution but enter the Amount as -.01 with no Tax Liability then pay both distributions together as follows:

  1. AP, Tasks, Change Invoices.
  2. Select the Vendor.
  3. Select the Invoice.
  4. Determine if you will need to change the accounting date to have this correction post in the period you want, then change if needed.
  5. Enter through to the distribution with the Tax Liability. Make note of the Tax Liability amount, then in the Amount field, enter .01. If the Tax Liability amount gets cleared, enter the amount again. Click Accept Dist.
  6. Enter a new distribution, coded the same as the original Tax Liability distribution (same commitment, job, cost code, account, etc...) but enter the Amount as -.01 and do not enter anything in Tax Liability. Click Accept Dist.
  7. Click Accept Invoice.
  8. If you had changed the accounting date in step 4, you will be prompted to choose the date to use for the reversing entry. If you do not want anything to post to the Original date, then choose the Revised date.
  9. Click Finish.
  10. Pay this invoice to pay the Tax Liability distribution and the new distribution (the amounts will net to zero) to update the Distributions' statuses to Fully paid.
DocLink: Fully paid Accounts Payable invoice shows as open on task or report

[BCB:156:Chat 300 CRE US:ECB]
Defect ID
Steps to duplicate
Related Articles