Export Queries

//Export Queries
Export Queries 2017-09-11T03:59:20+00:00
DescriptionSearchDescription
Parts Used per Job#job #Shows all parts allocated to the job #
Inwards Stock MovementsRequires a start and end date and a Category can be included if required.Returns all stock booked Returns all stock booked into the system via a Purchase Order, Adjustment or on a Job.
Outwards Stock MovementsRequires a start and end date and a Category can be included if required.Returns all stock booked into the system via a Purchase Order, Adjustment or on a Job.
Parts Turnover QueryParts Turnover for specific date range.
Enter a start and end date for reporting.
Parts Turnover for specific date range.
Companies Contacts QueryNone required.All contacts for all companies with their contact details
Batches per Part# on HandNone required.All batches on hand per part# with Notes.
Labour per JobJob NumberLabour allocated per job
Compliance Allocation QueryCompliance allocation for all parts used on a job - enter the 'log books id'Lists parts used on a job using the Log Book ID
Kit Components QueryEnter the part# (model) of the kitAll parts that are part of a specific kit
ADs & Inspections Forecast
Enter the rego, hours, days, cycles & landingsAll ADs and Inspections on Schedule
Components ForecastEnter rego, hours, days, cycles & landingsAll Components and Inspections on Schedule
MSDS PartsNone required.Lists all MSDS part numbers
WIP Parts QueryNone required.All inventory parts used and returned to stock on all 'In Service' jobs
COGS QueryEnter date range - same result as reportCost of Goods Sold – usually run by calendar month.
Adjustments Issues QueryThis query will run for a while. No parameters required.Adjustments carried out in a date range.
Turnaround QueryStart date and end date & job status.Returns turnaround details.
Purchases QueryDate rangeLists top 50 parts that have been ordered on the highest number of purchases within the date range specified
Export Contact DetailsNone required.Export contact details for both customers & suppliers, active & inactive
Empty Buy PriceNone required.Lists all inventory where the buy price is empty.