Crystal Reports Library—Purchase Order/Accounts Payable

Report

Price

Accounts Payable Purchase By Location   APPO-100 (pdf 5 kb)
This report provides a listing, by General Ledger Account Number, of the Accounts Payable Invoice Number, Vendor Name, Invoice Date, Invoice Amount and Discount Amount for an inputted date range. The report also sorts by General Ledger Account Segment. In this report, segments are established for Department and Location. The report could be used to compare expenses on a department-by-department basis between different business offices or stores

$ 325.00

Purchase Orders by GL Number    APPO-101  (pdf 14 kb)
This report can be used to see all purchase orders related to specific accounts such as inventory or for specific expense accounts by department.

A/P Repetitive Invoice Listing by Division    APPO-102
This report lists all repetitive A/P invoices by vendor showing the billing amount per invoice and total billed per date. The report shows billing cycle, billing start date, date of last bill and number of payments to date by division and by vendor.

A/P Vendor Top 20 Listing APPO-103   (pdf 5 kb)
This report lists the top 20 A/P vendors by current year and prior year purchases. The report is sorted by highest dollar amount of current year purchases. The report also provides the dollar percentage of the total by vendor for current and prior year purchase.

$ 325.00

Purchase Order Open Item Report   APPO-104  (pdf 5 kb)
This report is run for a specific Purchase Order Number. It identifies items on the selected Purchase Order that have been received, partially received or back ordered. The amount owed for items not yet received is calculated and totaled. This is a good inquiry report for finding the status of all items on a given Purchase Order.

$ 325.00

A/P Cash Requirements 8 Weeks Out  APPO-105  (pdf 16kb)
This report calculates requirement cash payments from A/P based on the invoice due date.  It extends the cash requirements out to 8 weeks from the report date that is entered. This report pulls from the A/P open invoice file and is designed to be a tool for cash management.

$ 350.00

A/P Source Batch Reconciliation  APPO-106  (pdf 5 kb)
This report lists all the Invoices in the AP_12 Invoice History File by A/P Invoice Register Number To reconcile with G/L Postings.

$ 325.00

A/P Accrual Report  APPO-107  (pdf 11 kb)
This report helps users to close out Accounts Payable on the last day of the month. All invoices vouched the following month are updated to the G/L on the date posted regardless of the invoice date. This report will pick up all invoices with an invoice date equal to or less than the month end cutoff date and a transaction date greater than the cutoff date. The month end cut off date is the input parameter. The report is a great tool to be used as a basis for reversing Journal Entries and can be run at the end of the G/L closing cycle. The report shows details and summary information by G/L Debit Account including Account #, Account Description, Transaction Date, Source Journal, Source Batch, Vendor, Invoice Date, Invoice # and Amount.

$ 325.00

Non-Static Reorder Report  APPO-108  (pdf 4kb)
This report is very helpful for computing reorder quantity for seasonal type businesses. The report looks back to the last two years of quantity sales for an inputted month and based on the percentage increase in sales, computes estimated current months sales. The report then subtracts current available units from estimated sales to arrive at re-order quantity.

$ 350.00

A/P Trial Balance Report  APPO-109  (pdf 17 kb)
This report prompts for an "as of" date. It provides a more readable format that the standard Sage MAS 90 AP Trial Balance Report. This report includes all invoices and all vendors and subtotals by division.

$ 325.00

Return Goods History  APPO-110  (pdf 5kb)
This report lists returns by Purchase Order number for an inputted date range. The report shows P.O Number, Item Number, Return Number, Return Date, Vendor, Quantity Returned and Unit Cost.

$ 300.00

A/P Check Report for Reversals and Voids  APPO-112  (pdf 16kb)
This report shows all A/P check reversals and voids. The report shows Check #, Type, Source, Date, Vendor Number, Payee if applicable and Amount.

$ 300.00

A/P Vendor Listing by Last Purchase Date  APPO-113  
(pdf 10 kb)
This report lists all Vendors by Vendor Number. The report includes Vendor Name, Address and Last Purchase Date. You have the ability to input a beginning date range and the report will print all Vendors with a last purchase date from the inputted date to the present.

$ 325.00

Check Verification for Wells Fargo (other banks available)  APPO-114  (pdf 3 kb)
This report is used to prevent check fraud by sending check information to the bank and utilizing the bank's recent service offerings. It provides a method where a client can email check data to their bank where it is used to match against checks being cleared by the bank. Click above for an example of the documentation available for the report.

$ 500.00