AM12 Sample Reports

The Purchase Order Reports provide information on purchase order transactions. These reports have various options and criteria that provide a wide variety of purchase-related information and report formats. Read the information below to get a closer look at each of the Purchase Order Reports available in AccountMate.

Purchase Order Summary Report

The Purchase Order Summary Report provides summary information on purchase orders or purchase quotes. This report is useful in evaluating your purchasing activities and reviewing the purchase orders/quotes created within a specific period.

You can filter this report to include only the purchase orders or only the purchase quotes. You can also opt to show multi-currencies.

Purchase Order Line Item Report

The Purchase Order Line Item Report provides detailed information on each purchase order or purchase quote line items. This report is useful in reviewing the details of the inventory items included in a purchase order or purchase quote and in evaluating the accuracy of each purchase order or purchase quote information.

You can select to generate this report only for purchase orders or only for purchase quotes. You can include in this report the freight charge and sales tax information. You can also opt to show the item descriptions, reference GL Account IDs and multi-currencies.

Purchase Order Backorder Report

The Purchase Order Backorder Report provides detail information of purchase order line items that are on back order (e.g., orders that are yet to be received from vendors). This report helps you identify which inventory items are on back order and also helps you evaluate your vendors’ ability to supply orders on time.

You can opt to show on the report the inventory item descriptions, reference GL account IDs, and multi-currencies.

Purchase Order Line Item Status Report

The Purchase Order Line Item Status Report allows you to print or preview information about the purchase order line items’ status including the purchase order line items order quantities, received quantities, backorder quantities, and cancelled quantities. Since this report can help you determine the PO line items status, you can find it useful in making sound purchasing decisions.

Received Goods Report

The Received Goods Report provides information on inventory items that are recorded as received from vendors using the Receive Goods function. This report is useful in reviewing the order receipt details including the unit costs, discounts that are taken advantage of, quantities received, among other pertinent information.

You have the option to include freight charge and sales tax information in the report. You can also opt to show the inventory item descriptions, reference GL account IDs and multi-currencies as well as serial and lot numbers, if there is any.

Cancelled Received Goods Report

The Cancelled Received Goods Report provides information on inventory items that were previously recorded as received but cancelled using the Cancel Received Goods Maintenance function. This report provides details on which item receipts are cancelled, the quantity cancelled, the related purchase order number, and other pertinent information. This report is useful for reviewing the reasons for canceling receipt of goods and for evaluating the frequency of purchase returns.

You have the option to show on the report the inventory item descriptions, reference GL account IDs and multi-currencies as well as serial and lot numbers, if there is any.

Vendor Performance Analysis Report

The Vendor Performance Analysis Report provides information about the lead time between the placement of your order and the delivery of your ordered goods and the percentage of full shipment. This report is very useful when making decisions on retaining or replacing your current vendors after evaluating their performance based on the timeliness of their deliveries, completeness of order fulfillment and pricing.

You can select to display only the purchase orders which items are received later than the request dates. You can also opt to show multi-currencies. You can further filter the report to generate only for those purchase receipts with invoices, only for purchase receipts without invoices, or for all purchase receipts.

PO Line Items for AP Matching Report

The PO Line Items for AP Matching Report (called Accrued Received Goods Report in versions lower than AccountMate 7 for SQL/Express) provides detailed information on the PO receipts that are yet to be matched to AP invoices. These PO line items are received from vendors whose records are set up to use the AP/PO Matching feature. You can use this report to determine the quantity and amount of PO receipts for which no AP invoices are posted. It also serves as reference when reconciling the received goods liability account balance in the General Ledger.

You can include in the report the PO receipts that are fully matched to AP invoices. You also have the option to show the reference GL Account IDs and multi-currencies. The report can be filtered to display information only for the accrued PO receipts, only for the PO receipts that are not accrued, or both.

Last Received Cost Report

The Last Received Cost Report provides information on each PO line item price that is based upon its last purchase cost. This information includes each inventory item’s last purchase price, the related purchase order number, and the number of days the purchase price remains effective. This report is useful in determining the latest purchase cost of inventory items and the duration that price will be in effect.