Purchases Reports

Purchases Reports 2016-09-18T23:48:38+00:00

Purchases by Date

This report requires at least a date or date range, and summarizes the purchases by date. It is especially useful for end of month reporting, comparing aerotrack to your accounting software. Remember to also include the status of the purchases if you only want to find bills for a month for example.

Purchases by Supplier

This report requires at least the supplier name, and summarizes the purchases of this supplier. You typically also add dates or date ranges to this report. Remember to also include the status of the purchases if you only want to find bills for a month for example

Purchases by Item

This report requires at least the item code, and summarizes the purchases by this code. You typically also add dates or date ranges to this report. This report is useful to track all the purchases of a particular item within a period.

Purchases by Job

This report requires at least the job no, and summarizes all purchases of all items by that job no. This report is useful to track all the purchases of items against a particular job no.

Purchases by Department

This report requires at least a date range and will display all purchases in that date range grouped by department.

Purchases by Account

This report requires at least a date or date range, a currency and an account code, and summarizes the purchase for the account code. This report will list the purchases account data for each purchase as specified per each inventory item.  This report is especially useful to enter data into your accounting software if you are using multiple purchase accounts.

Parts Ordered not Received

This report will generate a list of parts that are still on order but have not been received. As parts are received they should have a batch reference (e.g. GRN) allocated to them non received parts are left empty. This report simply identifies all parts without a reference that are still on order. It requires no user input, just run the report. This report groups by supplier and then sorts by date. Supplier groupings do not break across the page. This allows you to email suppliers their specific section of the report for outstanding PO’s.

Purchases Delivered not Billed

This report uses the new delivery ref. field to find all purchases that have a delivery reference but not a supplier invoice.

Outstanding Back Orders

This report will find all PO’s created by the back order function that are still at an order status.

Outstanding Repair Orders

This report will show all repairs at a status of ‘Order’. It will report full item information including description. No search requirements.

Overdue Purchases

This report will show all purchases at a status of ‘Order’ whose ‘Required By’ date is in the past. It will report all purchase information. No search requirements.

Open Requisitions

This report will show all requisitions at a status of ‘Open’. It will group the requisitions by ‘Urgency’. No search requirements.

Suppliers Listing

This report shows all suppliers in alphabetical order grouped by currency they trade in. No search requirements.

GRN Register By Date

This report requires a date range. It will generate a list of all inventoried parts allocated a GRN that were purchased in this period. Also included is the source references and supplier names and quantities etc. for traceability purposes.

GRN register by Batch Creation Date

Similar to the GRN Register report but is based on the batch creation date rather than the purchase date. These may be different due to receival date being different from the date of invoice. Requires a date range.

GRN register by Batch Creation Date (Batch Sorted)

Same as the GRN Register by batch creation date report but is sorted in batch order. Requires a date range. Can also specify a batch.