Purchase Orders Reports        

Purchase Orders | Reports

Purchase Order Status

This report shows the status of purchase orders, date ordered, requested receipt date and whether received yet. The receipt date and receipt no. print for each receipt. The report may be filtered to show only purchase orders for a selected status (work sheet, on order, completed, cancelled), vendor or item.

Purchase Order Detail

This report shows purchase orders with items, quantity ordered, received, and quantity on back-order. The report may be filtered to show only purchase orders for a selected status (work sheet, on order, completed, cancelled), vendor or item.

Quantity Available (MRP)

This report shows current inventory levels and extrapolates into the future as the inventory is depleted by sales orders, increased by purchase orders, manufactured goods increased by manufacturing orders, and materials (raw materials, packaging materials, and intermediate items) depleted by usage for manufacturing orders. The report highlights if the current inventory level or future inventory level will fall below the Minimum Quantity specified for each item.

It is used for MRP (Material Requirement Planning) for materials required for production, for scheduling manufacturing (together with the resource scheduling reports), shipping of sales orders, and purchasing. The report may be filtered to show only data for a selected item type or item, or only items below minimum.

Tip: You can extend the range of this report by entering “dummy” sales orders and manufacturing orders to show forecasted future demand, planned production, and resulting material requirements.

Lists

These list screens have a print option, and can be filtered and sorted in different sequences.

Purchase Orders

Receipts

Other

An ODBC driver is available (free upon request for end-user versions of Pilot) for creation of custom reports via MS Access or Crystal Reports, mail merge with MS Word, and to import Pilot data to MS Excel, etc.