A/P Pending Detail Report

This option allows you to print a detail backup of the A/P Pending G/L account for users who are currently using Central Pay. Information includes the balance forward for the account selected (by office), billing for the month selected, and clearances added to Accounts Payable in the month selected. The net of these two columns (Billed and Cleared) supports the General Ledger entries. An ending balance (Account Total) is also printed and should match the A/P Pending General Ledger account. Also, detail columns of information include estimates, media codes, vendors, and invoice information. Also, for each transaction date, the amounts billed, cleared amounts, cash receipts, media adjustments, and net totals are displayed. Grand totals are shown at the end of the report and include an Office Total, Account Total, and Report Total all with ending balances. A blank line is inserted between matched sets of estimates for easier viewing.
  1. Select Accounts/Payable|Reports|A/P Pending Detail Report.

A/P Pending Detail Prompt

  1. Key the Period to Report in MMCCYY format.

  2. Key the A/P Pending G/L Account on which you want to print detail backup.

  3. To print the pending account balance forward for the year and detail for each month leading up to the specified reporting month/year, select one of the following from the Include Detail For area. Click the "Month Requested Above Only” to run the original A/P Pending Detail Report. Click ”All Months Through Month Selected” to print detail with the pending account balance forward for the year based on the specified reporting month/year. If you key October 2007, then data is collected for all months prior to and including this date. Detail shows how the balance was created and is sorted by client with totals for each client.

  4. To display the Printing Selections Window, click the Report button.

  5. To export the report to a spreadsheet format, click the Export button.

  6. To continue to work in another option or even log off while the information is being processed, click in the "Process in Background/Batch checkbox. This feature works with the Export function so make sure you click both the Export radio button as well as the "Process in Background/Batch" checkbox to process requested information in the background.

  7. To limit information that displays in the collection, click the Selection buttons and select items from the list.

  8. Click the Next icon. If you selected Report, the Printing Selections Window displays.  If you selected Export, the Columns to Include on Listing window displays. Select only the information you wish to include on the report then click the Next icon again to display the Processing Window.

  9. You may click <Cancel> to cancel your request or if the report is large, you can take advantage of the <Send to Background> function which processes the request in the background so you can continue to work in other options. This function is also available on the Prompt as described above. As always, if you process in the background and your report is under 2MB in size, you will receive your report as an attachment in an email after processing is completed. If your report is over 2MB in size, your email will contain a link that will open a download window where you can save the file to a spreadsheet format.

  10. If you do not click <Cancel> or <Process in Background>, your report is output to the browser where you will see Filter, Page Number, and Max Rows functions. Click the Next Page (down) arrow to display the next page of information on the report. Click the Previous (up) arrow to return to the previous page of information. Key a Max Row to limit the amount of rows that display on a page to the specified number. To filter information, key a valid filter in any of the blank fields located below the applicable column heading and press <Enter>. Only values that match the specified filters are displayed. When filters are applied, page numbers are no longer displayed; however, you can continue to use the Next Page feature to advance to the next page of filtered information on the report. To remove all filters, click <Clear Filters> or you may remove filters separately by highlighting a filter and clicking <Delete>. Note: Total rows are not recalculated when filtering.

  11. Click <Export to Spreadsheet> to export your report to a spreadsheet format or click the Print icon to generate a PDF of your report. If filters are used, only the information that is filtered displays on the spreadsheet or PDF.

Note: PDF processing limits the number of rows that display on the PDF to 3,000. If you receive the message “3000 row limit reached”, use the new filter function to limit the amount of information that is collected.