# Epicor Kinetic Custom Report Inventory Worksheet

> Source: https://netray.co/tools/epicor-kinetic-custom-report-inventory-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable register of custom reports, BAQs and dashboards to support upgrade testing and clean-up of unused items.

## Category

epicor

## Erp

Epicor Kinetic

## Audience

- Epicor administrator
- Report developer
- Business analyst

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Report or query name

**Key:** name

**Type:** text

#### Type

**Key:** type

**Type:** select

**Options:**

- Report style
- BAQ
- Dashboard
- BAQ report
- External report

#### Business area

**Key:** area

**Type:** select

**Options:**

- Sales
- Purchasing
- Production
- Inventory
- Finance
- Quality
- Other

#### Owner

**Key:** owner

**Type:** text

#### Active users

**Key:** users

**Type:** number

#### Runs per month

**Key:** runs

**Type:** number

#### Minutes saved per run

**Key:** mins

**Type:** number

#### Monthly minutes of value

**Key:** value

**Type:** number

**Expr:** runs * mins

**Format:** number

#### Action

**Key:** action

**Type:** select

**Options:**

- Keep
- Test on upgrade
- Redesign
- Retire

**Rows:**

#### Packing slip custom

**Type:** Report style

**Area:** Production

**Owner:** Shipping

**Users:** 8

**Runs:** 400

**Mins:** 2

**Action:** Test on upgrade

#### Open PO by buyer

**Type:** BAQ

**Area:** Purchasing

**Owner:** Purchasing

**Users:** 6

**Runs:** 120

**Mins:** 10

**Action:** Keep

#### Late jobs dashboard

**Type:** Dashboard

**Area:** Production

**Owner:** Plant manager

**Users:** 14

**Runs:** 300

**Mins:** 5

**Action:** Test on upgrade

#### Old margin report

**Type:** BAQ report

**Area:** Sales

**Owner:** Unknown

**Users:** 0

**Runs:** 0

**Mins:** 0

**Action:** Retire

**Totals:**

#### Total monthly minutes of value

**Key:** value

**Agg:** sum

**Format:** number

#### Items listed

**Key:** name

**Agg:** count

**Format:** integer

**Summary:**

#### Average value per item (min)

**Key:** avg_value

**Expr:** sum_value / count

**Format:** decimal

**Primary:** true

**Notes:** Minutes saved per run is your own estimate of the work the report replaces. Items with no owner and no runs are candidates to retire after a notice period.

## Content

**Intro:** Custom reports multiply over the years. Before an upgrade or a cloud move, you need to know which ones matter and who owns them. This worksheet is a quick inventory that ends with a keep, test, redesign or retire decision.

**Sections:**

#### How to use the worksheet

**Body:** List custom report styles, BAQs, dashboards and external reports that read Epicor data. For each, name an owner, count users and runs per month, and estimate the minutes saved per run. Choose an action. Export to Excel to share with department heads for confirmation before you retire anything.

**Bullets:**

- Start with reports that are emailed on a schedule
- Ask owners to confirm, do not assume
- Mark anything with no owner for review

#### Why inventory before upgrade

**Body:** Custom report styles and queries depend on data model details that can change between releases. Testing all of them costs time, so you test those that matter. Items with many users or financial impact get a test line in the upgrade plan, while unused ones are retired so they stop consuming effort and giving conflicting numbers.

#### Reading the value column

**Body:** Monthly minutes of value is runs times minutes saved. It is a rough ranking tool, not an accounting figure. A dashboard run 300 times a month saving five minutes each is worth far more than a pretty report used twice. Use it to explain to stakeholders why you will test some reports first and retire others.

#### Common mistakes

**Body:** Teams retire reports based on system usage data alone and miss quarter-end or annual reports. Others keep three versions of the same report because nobody knows which is right. Check the calendar of use, and agree one trusted version per question.

**Bullets:**

- Retiring year-end reports in a quiet month
- Duplicate versions of a sales report
- Reports reading from copied spreadsheets

**Cta:** If your reports are scattered across tools, we can help consolidate them with a private assistant that answers questions directly from ERP data, with the query shown.

**Faq:**

#### What counts as a custom report?

**Answer:** Anything built or modified locally that business users rely on: report styles, BAQs, dashboards, and external tools such as spreadsheets or BI reports connected to Epicor data. Standard unmodified reports usually do not need a line.

#### How do I find unused reports?

**Answer:** Use available run history, audit or scheduling information in your environment, then confirm with owners. Absence of recent runs does not prove a report is unused, because some run once a year.

#### Is the value estimate meaningful?

**Answer:** It is a ranking aid based on your own estimates. Do not present it as savings. Use it to order the testing list and to start conversations with owners.

#### Can I attach screenshots?

**Answer:** Not in the worksheet. Keep screenshots or specifications in your document store and reference the location in the name or owner column.

## Search terms

epicor custom report list, epicor report inventory, epicor baq inventory excel, epicor report rationalization, epicor upgrade report testing, epicor dashboard documentation

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json