# Sage Customization and Report Inventory Worksheet

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

## Short answer

List every custom report, script and integration in your Sage system, score its value and effort, and decide what to keep, replace or retire.

## Category

erp-migration

## Erp

Sage

## Audience

- IT manager
- ERP consultant
- Business analyst

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Customization

**Key:** item

**Type:** text

#### Type

**Key:** type

**Type:** select

**Options:**

- Custom report
- Screen change
- Script
- Integration
- Import/export job
- Custom table

#### Business owner

**Key:** owner

**Type:** text

#### Uses per month

**Key:** runs

**Type:** number

**Format:** integer

#### Business value (1-5)

**Key:** value

**Type:** number

**Help:** 1 low, 5 critical

#### Rebuild hours

**Key:** rebuild_hours

**Type:** number

**Format:** integer

#### Hourly rate

**Key:** rate

**Type:** number

**Format:** currency

#### Rebuild cost

**Key:** rebuild_cost

**Type:** number

**Expr:** rebuild_hours * rate

**Format:** currency

#### Priority index

**Key:** priority

**Type:** number

**Expr:** value * min(runs, 100) / max(rebuild_hours, 1)

**Format:** decimal

#### Decision

**Key:** decision

**Type:** select

**Options:**

- Keep as is
- Replace with standard
- Rebuild
- Retire
- Undecided

**Rows:**

**Item:** Open order margin report (Crystal)

**Type:** Custom report

**Owner:** Sales manager

**Runs:** 60

**Value:** 5

**Rebuild hours:** 16

**Rate:** 120

**Decision:** Rebuild

**Item:** Nightly EDI 850 import script

**Type:** Integration

**Owner:** Customer service

**Runs:** 30

**Value:** 5

**Rebuild hours:** 60

**Rate:** 140

**Decision:** Rebuild

**Item:** Custom lot label print

**Type:** Script

**Owner:** Warehouse

**Runs:** 400

**Value:** 4

**Rebuild hours:** 12

**Rate:** 120

**Decision:** Replace with standard

**Item:** Legacy commission spreadsheet export

**Type:** Import/export job

**Owner:** Finance

**Runs:** 1

**Value:** 2

**Rebuild hours:** 24

**Rate:** 120

**Decision:** Retire

**Item:** Extra UDF on item master (heat number)

**Type:** Custom table

**Owner:** Quality

**Runs:** 200

**Value:** 4

**Rebuild hours:** 8

**Rate:** 140

**Decision:** Keep as is

**Totals:**

#### Total rebuild hours

**Key:** rebuild_hours

**Agg:** sum

**Format:** integer

#### Total rebuild cost

**Key:** rebuild_cost

**Agg:** sum

**Format:** currency

#### Items inventoried

**Key:** item

**Agg:** count

**Format:** integer

**Notes:** Priority index = value x monthly uses (capped at 100) divided by rebuild hours. Higher means more value for the effort. Use it to sequence work, not to decide alone.

## Content

**Intro:** Before a move off Sage 100, Sage 300 or an older X3 release, you need to know what has been customized. This worksheet inventories each custom item, scores value against effort and records a decision.

**Sections:**

#### How to use it

**Body:** Walk each department and list the custom reports, screen changes, scripts, integrations and import jobs that they rely on. Record the business owner, how often the item is used, a value rating from 1 to 5 and a rough rebuild estimate in hours. The worksheet calculates the cost and a priority index. Then set a decision for each row. Items nobody owns or uses are candidates to retire before you spend anything on them.

**Bullets:**

- Include Crystal or SSRS reports and Excel macros
- Include integrations that run on someone's PC
- Ask users, not only IT, what they actually run
- Check scheduled jobs and task scheduler entries

#### Keep, replace, rebuild or retire

**Body:** A useful rule is to prefer the standard feature of the target ERP when it meets about 80 percent of the need, rebuild only what is genuinely differentiating, and retire what has no active owner. Cloud ERPs also limit certain kinds of customization, so scripts that touch the database directly usually need a redesign using supported APIs or reporting tools. Record the reason for each decision so you can defend scope later.

#### Reading the totals

**Body:** Total rebuild hours are a first order sizing figure for the project plan, not a quote. Compare it with the number of items you marked Rebuild rather than the whole inventory. Sort by priority index to find quick wins: high value, high use and low effort. Review the lowest index items with their owners to confirm they can be dropped.

#### Common mistakes

**Body:** The usual miss is shadow customization: Excel files that pull from ODBC, Access databases and local scripts that never appear in the system. Another is rating everything value 5 because every owner defends their report. Ask what decision the report supports, and what the team would do if it vanished.

**Cta:** Reports and customizations can often be recreated faster with AI assisted generation under human review. If that interests you, we can talk through what it would take for your stack.

**Faq:**

#### How do I find all the custom reports?

**Answer:** Check the report folders on the server, the report designer's custom list, scheduled tasks, and ask each department for the files they open every month. Also search file shares for Crystal and Excel files that connect via ODBC.

#### Are the rebuild hours reliable?

**Answer:** They are only as reliable as your estimate. Use ranges early on, then refine after the first rebuilt item. The worksheet is for sequencing and rough budgeting, not for fixed price commitments.

#### What about customizations in Sage X3?

**Answer:** X3 customizations include custom screens, fields, processes and reports built in its development environment. List them by type and note the folder they live in. The same keep, replace, rebuild, retire logic applies.

#### Can the inventory support a fit gap analysis?

**Answer:** Yes. Add a column in Excel for the matching standard feature in the target ERP, then mark gaps. The decision column already separates standard replacements from true gaps.

## Search terms

sage 100 customization inventory, sage custom reports list template, erp fit gap analysis worksheet, legacy customization assessment template, sage crystal reports inventory, erp custom report rationalization

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