Recommended ERP, SQL and Planning Tools

Quick access to key tools from Tools, ERP, AI, Workspaces, and Portal Directory pages.

ERP Planning Lab

ERP-style planning, demand-supply review, planned order release, PO/job output, score validation, and registers.

Open ERP Planning Lab

SQL / PL-SQL Explainer

Explain Oracle SQL/PLSQL, review joins, identify tables, and improve code quality. Sign-in may be required.

Open SQL / PL-SQL Tool

Oracle SQL Workbench / Executor

Connect to Oracle, write formatted SQL, browse objects, extract DDL, run read-only SQL, and load CSV data.

Open Oracle Workbench

🏠 Back to ERP Home ← Back

Create Item

Item ID

Item Number *

Description *

Item Type *

Make / Buy *

UOM *

Selling Price

Standard Cost

Lead Time Days

BOM Type

Supplier

BOM Enabled

Option Class

Parent Model

Planning Method

Items

Item ID	Item Number	Description	Item Type	Make / Buy	Supplier	BOM Type	BOM Enabled	Planning Method	Selling Price	Standard Cost	Action
1001	MODEL-SPEAKER	Configurable Speaker Model	Model	Make		Model BOM	Yes	ATO / Configure-to-Order	220	120	Update
1002	OC-SPEAKER-SIZE	Speaker Size Option Class	Option Class	Make		Option Class BOM	Yes	ATO / Configure-to-Order	0	0	Update
1003	OPT-WOOFER-6	6 Inch Woofer Option	Option	Buy	SUP-ELECTRONICS	None	No	Buy Planned	45	18	Update
1004	CFG-SPK-BASIC	Configured Speaker Basic	Configuration Item	Make		Configuration BOM	Yes	ATO / Configure-to-Order	240	145	Update
1005	FG-SPEAKER-STD	Standard Speaker Finished Good	Finished Good	Make		Standard BOM	Yes	MTO	185	95	Update
1006	CMP-CAB-WOOD	Cabinet Wood Set	Component	Buy	SUP-WOOD	None	No	Buy Planned	16	9	Update
1007	CMP-CAP-KIT	Capacitor Kit	Component	Buy	SUP-ELECTRONICS	None	No	Buy Planned	2	0.8	Update
1008	CMP-PCB-AMP	Amplifier PCB	Component	Buy	SUP-ELECTRONICS	None	No	Buy Planned	14	8	Update
1009	CMP-PACK-BOX	Speaker Packaging Box	Component	Buy	SUP-PACKAGING	None	No	Buy Planned	3	1.2	Update