| How can I identify and correct Accounts Payable invoices with blank lines of distribution with an Account Verification Report? |
Resolution | [BCB:5:Third-party support:ECB]
Invoices with blank lines of distribution can stop an Accounts Payable check run. Find and delete blank distributions from any invoices selected for payment. Sometimes if it is missing GL information it will also be called a blank line of distribution.
- To find blank lines of distribution on Accounts Payable invoices selected for payment, print the GL Account Verification Report (Option I) or download the attached report (Option II) as follows:
- Option I: Print the GL Account Verification Report
- From the AP Reports menu, select GL Reconciliation, GL Account Verification Report.
- Select AP Master then click OK.
- Click Conditions.
- In the Field section, select Included for Pmt.
- In the Operator section, select Equal to.
- In the Value section, select the check box.
- Click OK.
- Click OK.
- Add additional ranges or conditions, if desired.
- Click Print Preview to preview the report or click Start to print the report to a file or printer.
- Review the results. Refer to article 97542 DocLink: How to interpret the results of the GL Account Verification Report in Accounts Payable
- Option II: Download and print the modified Invoices Selected for Payment report
- Download the attached invoices_selected_for_payment_0_dist.rpt. Refer to article 18607 DocLink: How do I save, add, and print a report design? for more information on how to download and add a report design to your Reports menu.
- Note: Only blank distributions that have a zero amount, no expense account, and are selected for payment appear on the attached report.
- Delete any blank distributions you find as follows:
- Note: Distributions with a 0.00 amount may be ok as long as they have a GL account assigned.
- WARNING: Do not delete 0.00 amount distributions if they were a credit amount and changed to 0.00 after it was already paid as it will create a file fix situation.
- From the Tasks menu, select Change Invoices.
- Enter the vendor and invoice number for one of the invoices identified in the report.
- Press Tab on your keyboard until the distribution grid appears in the lower portion of the window.
- Click inside the next available blank line of distribution.
- Click Delete to delete the blank line of distribution.
- Click Accept dist, click Accept invoice.
- Note: If your invoice was selected for payment, you must re-select the invoice for payment (Tasks, Select Invoices for Payment, On-screen List).
- Repeat steps 2.2-2.6 for every invoice with a blank line of distribution.
- Click Finish.
DocLink: How do I save, add, and print a report design? DocLink: How to interpret the results of the GL Account Verification Report in Accounts Payable Attachment: 347_20230425114308_invoices_selected_for_payment_0_dist.rpt
[BCB:156:Chat 300 CRE US:ECB] |
|