SmartFusion Modules > Accounts Payable > Reports> AP Report by Account Number

Recent Changes

Recent Changes: 
6.229 - If 'Assign multiple purchase orders to single voucher' is set in AP System file, then the purchase order information will be obtained from the voucher detail.

6.185 - Handling 'Tax Refund' vendors so the customer names display on the report.
6.168 - Added beginning/ending PO number, beginning/ending PO reference number, invoice number and invoice description as filter criteria

6.139
- Added new checkbox called "Show invoice number".
- Updated existing report to UX standards and relabeled it "Portrait"
- Created a new crystal report in landscape. This report is identical to the portrait report except it includes the invoice number.

6.105
- Added the "Show inactive vendors" checkbox that allows users to include inactive vendors in the vendor number selection

Introduction

This report gives you an accounts payable report by account number

Explanation

This report has a portrait and a landscape version. Landscape is identical to portrait except it contains the Invoice Number as a column.

The default report is portrait. Landscape will only print if "Include invoice number" is checked.

Pay Date vs Check Date

This report has filter options as well as a single column for Pay Date/Check Date.

For the Pay Date/Check Date column, if the record has a check number, it will display the check date from the Check Posting. Otherwise, it will display the pay date from the Voucher.

Report Selections

Vouchers to include - Allows for a range of vouchers to be selected
Accruals to include - Allows for a range of accruals to be selected

Enter range to include

Criteria number - Allows a range of criteria to be selected
Show inactive vendors - Controls whether inactive vendors appear in the vendor number selection
Vendor number - Allows a range of vendors to be selected
Check date - Allows a range of check dates to be selected
Pay date - Allows a range of pay dates to be selected
Check run - Allows a range of check runs to be selected
PO number - Visible if client has Purchasing and "Hide purchase order field" is not selected in the AP System File
PO refr number - Visible if client has Purchasing and "Require a valid purchase order number" is not selected in the AP System File
New page for each account
New page for each fund
Print voucher line description
Show invoice number - Prints the landscape version of the report which includes a column for Invoice Number.

Invoice number filter - Accepts partial text
Invoice description filter - Accepts partial text

Report Criteria

Report title

Ranges to include

Fund - Allows for a range of funds to be input
Function - Allows for range of functions to be input
Object - Allows for a range of objects to be input
Location - Allows for a range of locations to be input
Department - Allows for a range of deptartments to be input
Object group - Allows for a range of object groups to be input
Program - Allows for a range of programs to be input
Modifier - Allows for a range of modifers to be input
Cost center - Allows for a range of cost centers to be input
Job class - Allows for a range of job classes to be input

Account Range/Match

Enter beginning account
Enter endinig account
Enter account match

Format Options

Detail/Summary/Totals only