maap100004

Accounts Payable Purchase By Location

Click to View Report

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. 

 

mapo101002

Purchase Orders by GL Number

Click to View Report

This report can be used to see all purchase orders related to specific accounts such as inventory or for specific expense accounts by department.

 

maap102003

A/P Repetitive Invoice Listing by Division

Click to View Report

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.

 

maap103003

A/P Vendor Top 20 Listing

Click to View Report

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.

 

mapo104001

Purchase Order Open Item Report

Click to View Report

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.

 

maap105006

Accounts Payable Cash Requirements 8 weeks out

Click to View Report

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.

 

maap106011

AP Source Batch Reconciliation

Click to View Report

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.

 

maap107016

AP Accrual Report

Click to View Report

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.

 

mapo108005

Non-Static Reorder Report

Click to View Report

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.

 

maap109017

Accounts Payable Trial Balance Report

Click to View Report

This report prompts for an "as of" date. It provides a more readable format that the standard MAS 90 AP Trial Balance Report. This report includes all invoices and all vendors and subtotals by division.

 

mapo110009

Return Goods History

Click to View Report

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.

 

maap112020

 AP Check Report for Reversals and Voids

Click to View Report

This report shows all A/P check reversals and voids. The report shows Check #, Type, Source, Date, Vendor Number, Payee if applicable and Amount.

 

maap113005

 A/P Vendor Listing by Last Purchase Date

Click to View Report

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.

 

maap114022

 Check Verification for WellsFargo (other banks available)

Click to View Report , Click to View Report Documentation Example

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.

 

maap115026

A/P Cash Requirements Report

Click to View Report

This Report is a great tool for cash planning. It shows Cash Requirements by Due Date with Running Discounts and Running Total. The report includes Vendor, Invoice #, Invoice Date, Discount Date, Invoice Amount, Discount Amount and Invoice Balance after any payments.

 

maap116009

AP Aging By Due Date With Future

Click to View Report

This A/P Aging report is particularly useful for companies that have very generous terms. The aging is based on Due Date so if the Due date is in the future, the amount shows up under the future columns.

 

maap117009

Check History by Batch

Click to View Report

This report is a check register by batch. The report shows check #, check date, vendor #, check amount, invoice #, invoice date, invoice amount and discount.

 

Contact Us



Copyright © 2004 by CrystalReportsLibrary.com, Inc.