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
ERP Home Items Suppliers Customers Resources BOM / Model BOM Sales Orders Purchase Orders Discrete Jobs Planning Registers
🏠 Back to ERP Home ← Back

Update Item

Cancel Edit

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