Identify Accounts Payable invoices with blank lines using the Account Verification Report
Description
Cause
Resolution

CAUTION:

Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.

Invoices with blank lines of distribution can stop an Accounts Payable check run. Find and delete blank distributions from any invoices selected for payment. Missing General Ledger information can also trigger as a "blank line of distribution".

Locate the blank distribution lines

Choose an option below to locate the blank lines of distribution.

Print the GL Account Verification Report

  1. From the AP Reports menu, select GL Reconciliation, GL Account Verification Report.
  2. Select AP Master then click OK.
  3. Click Conditions.
  4. In the Field section, select Included for Pmt.
  5. In the Operator section, select Equal to.
  6. In the Value section, select the checkbox.
  7. Click OK.
  8. Click OK.
  9. Add additional ranges or conditions, if desired.
  10. Click Print Preview or Start to print the report to a file or printer.
  11. Review the results.

Download and print the modified Invoices Selected for Payment report

Download and save the attached report.
Attachment: InvoicesSelectedForPaymentWithBlankDist.rpt

Only blank distributions that have a zero amount, no expense account, and that you selected for payment appear on the attached report.

Delete blank distributions

Distributions with a 0.00 amount can be ok as long as they have a General Ledger account assigned.

CAUTION:

Don’t delete 0.00 amount distributions if they were a credit amount and changed to 0.00 after you already paid it. This creates a file fix situation.

  1. From the Tasks menu, select Change Invoices.
  2. Enter the vendor and invoice number for one of the invoices identified in the report.
  3. Press Tab on your keyboard until the distribution grid appears in the lower portion of the window.
  4. Click inside the next available blank line of distribution.
  5. Click Delete to delete the blank line of distribution.
  6. Click Accept dist, click Accept invoice.
    • If you had selected the invoice for payment, re-select it (Tasks, Select Invoices for Payment, On-screen List).
  7. Repeat steps 2-6 for every invoice with a blank line of distribution.
  8. Click Finish.



[BCB:156:Chat 300 CRE US:ECB]
Steps to duplicate
Related Solutions

Error: "This check has a non-zero distribution with a blank GL Expense account"