# QAD EE Custom Code Inventory Worksheet

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

## Short answer

Editable inventory of QAD customizations with type, use, complexity and retire or rebuild decision, totalling rebuild effort.

## Category

erp-migration

## Erp

QAD

## Audience

- QAD technical lead
- QAD developer
- ERP project manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Program or report name

**Key:** program

**Type:** text

#### Type

**Key:** type

**Type:** select

**Options:**

- Menu program
- Report
- Interface
- Trigger
- Screen change
- Utility
- Other

#### Business use

**Key:** business_use

**Type:** text

#### Last used

**Key:** last_used

**Type:** date

#### Complexity (1 to 5)

**Key:** complexity

**Type:** number

**Format:** integer

#### Base hours per complexity point

**Key:** base_hours

**Type:** number

**Format:** number

#### Rebuild hours

**Key:** rebuild_hours

**Type:** number

**Expr:** complexity * base_hours

**Format:** number

#### Decision

**Key:** decision

**Type:** select

**Options:**

- Retire
- Replace with standard
- Rebuild
- Rewrite as extension
- Undecided

**Rows:**

**Program:** Custom pick list report

**Type:** Report

**Business use:** Warehouse pick sheets

**Last used:** 2026-09-30

**Complexity:** 2

**Base hours:** 8

**Decision:** Replace with standard

**Program:** EDI 850 inbound loader

**Type:** Interface

**Business use:** Customer orders via EDI

**Last used:** 2026-10-15

**Complexity:** 4

**Base hours:** 8

**Decision:** Rebuild

**Program:** Item cost roll variance

**Type:** Report

**Business use:** Month end costing review

**Last used:** 2026-10-01

**Complexity:** 3

**Base hours:** 8

**Decision:** Rebuild

**Program:** Legacy label print

**Type:** Utility

**Business use:** Old label format

**Last used:** 2022-03-04

**Complexity:** 2

**Base hours:** 8

**Decision:** Retire

**Program:** Sales order validation trigger

**Type:** Trigger

**Business use:** Credit and tax checks

**Last used:** 2026-10-16

**Complexity:** 5

**Base hours:** 8

**Decision:** Rewrite as extension

**Totals:**

#### Total rebuild hours if all rebuilt

**Key:** rebuild_hours

**Agg:** sum

**Format:** number

#### Customizations listed

**Key:** program

**Agg:** count

**Format:** integer

**Summary:**

#### Average hours per customization

**Key:** avg_hours

**Expr:** if(gt(count,0), sum_rebuild_hours / count, 0)

**Format:** number

**Primary:** true

**Notes:** The effort column is a rough planning figure. Retire and Replace decisions should reduce the real rebuild total, so filter the exported sheet by decision to size only the work you will actually do. Last-used dates should come from usage logs, not memory.

## Content

**Intro:** Before any QAD upgrade or move to Adaptive ERP, the real question is how much custom code you have and how much of it still matters. This worksheet inventories each customization, scores complexity and records a retire, replace or rebuild decision.

**Sections:**

#### How to use the inventory

**Body:** Pull a list of custom programs, reports, interfaces, triggers and screen changes from your source code library and your menu configuration. Add the business use and, from logs or user interviews, the date it was last used. Score complexity from 1 for a simple report to 5 for deep logic touching many tables. Set the base hours per point from your team's experience and the sheet computes rebuild hours. Then record a decision for each item.

#### Retire first, rebuild last

**Body:** In most customization audits a meaningful share of items has not been used for years or duplicates a function in the standard product. Retiring those is free. Replacing with standard saves rebuild effort and ongoing maintenance. Only what is both used and genuinely differentiating should be rebuilt, ideally as extension code outside the core so it survives future upgrades.

**Bullets:**

- No use in 12 to 24 months is a strong retire candidate.
- Ask whether the standard product now covers the need.
- Prefer extension patterns over modifying core objects.

#### Reading the totals

**Body:** Compare the all-rebuilt total with the total after filtering to Rebuild and Rewrite decisions. The gap is the effort you avoid by rationalising. If most hours sit in a few complexity 4 and 5 items, those deserve their own design and test plan, because they carry the upgrade risk. Review the list with business owners, not only developers.

#### Common mistakes

**Body:** Teams inventory only programs and miss reports built in external tools, spreadsheets that read the database directly, and scheduled jobs. Another mistake is estimating from lines of code instead of complexity and test effort. Finally, skipping the usage check leads to carrying dead code into the new platform.

**Cta:** Netray can help analyse custom ERP code with on-prem AI to summarise what each program does and flag likely duplicates of standard functions, without sending source code outside your network.

**Faq:**

#### Does this cover QAD Adaptive ERP specifics?

**Answer:** It is platform neutral: it lists whatever custom objects you have and records your decision. Which patterns suit Adaptive ERP, and how existing customizations map, should be confirmed with QAD or your implementation partner.

#### How do I find last-used dates?

**Answer:** Use menu usage logs, database audit data, scheduler history or report server logs where available. If none exist, ask the owning department and treat the answer as unverified until a trial retirement period passes.

#### What base hours should I use?

**Answer:** Use your own history of similar work, including design, build, test and documentation. The sample value of 8 hours per point is only a placeholder for illustration.

#### Should reports be included?

**Answer:** Yes. Custom reports are often the largest group by count, and many can be replaced by standard reporting or a BI tool, which makes them the best retire and replace candidates.

## Search terms

qad customization inventory, qad custom code list, qad enterprise edition upgrade planning, qad progress 4gl customization, qad adaptive erp migration custom reports, qad modification tracker excel

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