EXPENSE CENTER DETAIL REPORT

The Expense Center Detail Report allows you to report on Expense Center Transactions. The report can be generated for any selection of Expense Centers and will either show the batched or unbatched transactions for the selected Expense Centers. It can also be filtered further by Part Type and Transaction Type.

Navigation

1. Click Stores and select Expense Center Transactions.

2. Select an Expense Center.

3. Click Detail Report.
   

   

   
   

Report Option 1 - View Batching for the Selected Expense Center

1. Select View batches for (this reports only on the Expense Center that is currently selected on screen).

2. Select the Batches to report against.

3. Select Parts to Include

   1. All Parts

   2. Consumables Only

   3. Non-Consumables Only

4. Select a Sort Order.

5. Select Transaction Type(s) to include in the report.

   1. Labour Transactions can further be filtered by specific employee

      • Labour Transactions can only be reported here when Company Settings - Use Employee Trade Labour is selected

6. Report output options:

   1. Print - creates a PDF report

   2. Export - creates an Excel report

Report Option 2 - Viewing the Last Batch for Selected Expense Centers

1. Select View last batch for selected ECs (this option will include transactions from the last batch for each of the selected Expense Centers). 

2. Select the Expense Center(s) to report against.

3. Select Parts to Include

   1. All Parts

   2. Consumables Only

   3. Non-Consumables Only

4. Select a Sort Order.

5. Select Transaction Type(s) to include in the report.

   1. Labour Transactions can further be filtered by specific employee

      • Labour Transactions can only be reported here when Company Settings - Use Employee Trade Labour is selected

6. Report output options:

   1. Print - produces a PDF report

   2. Export - produces an Excel report

   3. EC Trend - produces a PDF report with a graph

   4. Export EC Trend - produces an organized Excel report

Report Option 3 - Viewing All Batches for Selected Expense Centers Over a Date Range

1. Select View all batches for selected ECs within date range (this will include all transactions for the selected ECs, regardless of the transaction date, that have a batch date within the date range entered).

2. Enter a Start Date and an End Date.

3. Select the Expense Center(s) to report against.

4. Select Parts to Include

   1. All Parts

   2. Consumables Only

   3. Non-Consumables Only

5. Select a Sort Order.

6. Select the Transaction Type(s) to include in the report.

   1. Labour Transactions can further be filtered by specific employee

      • Labour Transactions can only be reported here when Company Settings - Use Employee Trade Labour is selected

7. Report output options:

   1. Print - produces a PDF report

   2. Export - produces an Excel report

   3. EC Trend - produces a PDF report with a graph

   4. Export EC Trend - produces an organized Excel report

Report Option 4 - Viewing All Non-Batched Items for Selected Expense Centers Over a Date Range

1. Select View all non-batched items for selected ECs within date range (this will include all non-batched transactions with transaction dates within the date range entered).

2. Enter a Start Date and an End Date.

3. Select the Expense Center(s) to report against.

4. Select Parts to Include

   1. All Parts

   2. Consumables Only

   3. Non-Consumables Only

5. Select a Sort Order.

6. Select the Transaction Type(s) to include in the report.

   1. Labour Transactions can further be filtered by specific employee

      • Labour Transactions can only be reported here when Company Settings - Use Employee Trade Labour is selected

7. Report output options:

   1. Print - produces a PDF report

   2. Export - produces an Excel report

Note: Discarded Transactions will be filtered out by default, but can be included by selecting Include Discarded Transactions.