# Made2Manage Private AI Layer Blueprint Generator

> Source: https://netray.co/tools/made2manage-private-ai-layer-blueprint-generator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Generate a shareable architecture plan for adding a private, on-prem AI assistant to Made2Manage, with components, security controls and a three-phase rollout.

## Category

other-erp

## Erp

Aptean Made2Manage

## Audience

- CIO
- IT manager
- ERP administrator
- ERP consultant

## Tool

**Kind:** template

**Output:** document

**Fields:**

#### Company name

**Key:** company

**Type:** text

**Default:** Summit Fabrication Co

#### System version

**Key:** version

**Type:** select

**Options:**

- Made2Manage on SQL Server (current)
- Made2Manage earlier release
- Not sure

**Default:** Made2Manage on SQL Server (current)

#### Database engine

**Key:** db

**Type:** select

**Options:**

- SQL Server 2016 or 2017
- SQL Server 2019 or later
- Older SQL Server
- Not sure

**Default:** SQL Server 2016 or 2017

#### Hosting

**Key:** hosting

**Type:** select

**Options:**

- On-prem server
- Private cloud
- Air-gapped network

**Default:** On-prem server

#### Named users

**Key:** users

**Type:** number

**Default:** 45

#### Sites or plants

**Key:** sites

**Type:** number

**Default:** 1

#### Main use cases

**Key:** usecases

**Type:** textarea

**Default:** Job status and shortages for the shop floor. Delivery date questions for sales. Search of job travelers, inspection records and supplier certs.

#### Data that must never leave the site

**Key:** never

**Type:** textarea

**Default:** Customer pricing. Job cost and margin. Customer drawings under NDA.

#### GPU available

**Key:** gpu

**Type:** select

**Options:**

- Not yet purchased
- 1 x 24 GB class GPU
- 1-2 x 48 GB class GPUs
- 2-4 x 80 GB class GPUs
- Existing GPU server

**Default:** 1-2 x 48 GB class GPUs

#### Target go-live

**Key:** golive

**Type:** date

**Default:** 2027-02-28

**Blocks:**

#### Private AI Layer Architecture Plan: Made2Manage

**Body:** Company: {{company}}
System and version: Made2Manage, {{version}}
Database: {{db}}
Hosting: {{hosting}}
Named users: {{users}}
Sites or plants: {{sites}}
GPU: {{gpu}}
Target go-live: {{golive}}

#### Context and objectives

**Body:** {{company}} wants an AI assistant over its Made2Manage data and documents that runs inside its own environment ({{hosting}}). The assistant must answer questions in natural language, show the data behind each answer, respect existing user permissions and remain read-only until approvals are in place.

Main use cases:
{{usecases}}

#### Data boundaries

**Body:** The following data must never leave the site and must stay out of any external service:
{{never}}

All processing, indexing and model inference run on infrastructure controlled by {{company}}.

#### Components

**Table:**

**Columns:**

- Layer
- Design
- Notes for {{company}}

**Rows:**

**0:** Data access path

**1:** Read-only SQL Server copy with an ai schema of views over item master, sales orders, purchase orders, jobs, routings and job BOMs

**2:** Core tables use short identifiers and f-prefixed columns; confirm on {{company}}'s {{version}} schema

**0:** Retrieval index

**1:** Vector index of job travelers, drawings, inspection records and supplier certs tagged with job, part or order number

**2:** Scoped by job and customer

**0:** Model serving

**1:** Open-weight model on vLLM or Ollama sized to {{gpu}}

**2:** Isolated VLAN when hosting is {{hosting}}

**0:** Tool server

**1:** Typed read tools such as job status, parts short for a job and open orders for a customer

**2:** Tools return rows the user can inspect

**0:** Identity and permissions

**1:** Map Made2Manage user groups to assistant roles; restrict cost, margin and pricing

**2:** Application-level security must be mirrored

**0:** Audit

**1:** Append-only log of questions, tool calls and returned row sets

**2:** Reviewed with the plant controller

#### Security controls

**Table:**

**Columns:**

- Control
- Implementation
- Driven by

**Rows:**

**0:** Network isolation

**1:** Model, index and tool server in a dedicated zone with no outbound internet route

**2:** Hosting: {{hosting}}

**0:** Data minimisation

**1:** Only approved views and document sets are exposed; excluded data is never indexed

**2:** Data that must never leave the site

**0:** Least privilege

**1:** Read-only service identity; per-user filtering of tool calls

**2:** {{users}} named users

**0:** Model governance

**1:** Open-weight model pinned by version, weights checksummed, updates via change control

**2:** GPU: {{gpu}}

**0:** Audit and retention

**1:** Append-only log of questions, tools, sources and users with an agreed retention period

**2:** Internal audit and compliance

**0:** Write-back control

**1:** No writes in phases 1 and 2; later writes only through supported APIs with named approvers

**2:** Risk appetite of {{company}}

#### Rollout plan

**Table:**

**Columns:**

- Phase
- Scope
- Exit criteria

**Rows:**

**0:** 1. Read-only questions

**1:** Approved views and documents for a pilot group; answers show their sources

**2:** Accuracy sampled by owners; no permission leaks in review; log reviewed weekly

**0:** 2. Drafts

**1:** Assistant drafts emails, summaries and suggested changes for a person to copy

**2:** Users edit less over time; no unreviewed output leaves the system

**0:** 3. Approved actions

**1:** Selected actions executed through supported APIs after human approval

**2:** Approver named per action; rollback tested; go-live target {{golive}}

#### Open questions for IT

**Body:** 1. How fresh must answers be: real time, minutes or daily?
2. Which companies, databases or libraries are in scope across {{sites}} site(s)?
3. Who owns document permissions and how are they mapped to Made2Manage roles?
4. Which customisations or custom tables must be exposed?
5. What is the backup, monitoring and patching plan for the GPU host?
6. Who approves any write-back and through which supported interface?
7. Is a pilot group of 10 to 20 users available for phase 1?

#### Approvals

**Signatures:**

- Prepared by
- IT lead
- Security / compliance
- Business sponsor

**Notes:** Starting-point document, not a final design. Confirm table names, interfaces and security behaviour for your exact release with your vendor or implementation partner. Nothing you enter leaves your browser.

## Content

**Intro:** This free generator creates a private AI architecture plan for Made2Manage on SQL Server. Enter your environment and the data that must stay on site, then export the plan for your IT team and Made2Manage administrator.

**Sections:**

#### How to use the blueprint

**Body:** Describe the questions people ask in the shop and the office: which jobs are short material, when a sales order will ship, where the inspection record for a lot is. Choose hosting and GPU honestly, because they drive the model sizing and network design. The tool turns your answers into a plan with components, controls, a three-phase rollout and questions for IT.

#### What Made2Manage specifics it assumes

**Body:** The plan assumes a SQL Server database, a reporting copy and a schema of views over jobs, routings, BOMs, sales orders, purchasing and inventory. It assumes the shop has customisations, so it asks IT to confirm table mappings. Security is application-level, so the plan mirrors Made2Manage groups in the tool layer. Writes are held back until phase 3 and use supported routes.

#### Reading the output and common mistakes

**Body:** Use the open questions to drive a short meeting with your administrator and controller. Typical mistakes are letting a model compose SQL against production, forgetting custom fields, and exposing job cost to everyone. Replace placeholder wording with your own table and group names before the plan goes to management.

**Cta:** If you want help turning this plan into a working pilot on your Made2Manage data, Netray can review it with you. The generator is free regardless.

**Faq:**

#### Will Made2Manage data leave our network?

**Answer:** Not under this plan. The reporting copy, retrieval index and open-weight model all run on your servers, and the hosting option can be air-gapped.

#### Do we need to change Made2Manage?

**Answer:** No changes are needed for read-only use. The plan reads from a SQL Server copy through views. Later write-back would use supported routes only.

#### Is this suitable for a small shop?

**Answer:** Yes. A single GPU is typically enough for a small user base. If you only need a few fixed reports, standard reporting may be simpler.

#### Can the output be edited?

**Answer:** Yes, export it to Word or PDF and edit freely. The tool runs in your browser.

## Search terms

Made2Manage AI architecture, Made2Manage private AI, Made2Manage on-prem AI plan, private AI blueprint ERP, on-prem LLM architecture template, AI architecture document generator, air-gapped AI plan template

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