ERP — Manufacturing template

A plant-wide ERP: employees and the gate entry system, shifts and vacation, working stands, SOPs, items, BOM, warehouses and inventory, suppliers, purchase orders, customers, sales and production orders, quality, repairs, forwarders and shipments — with lot-traced goods receipts, 22 built pages and 17 workflows.

24 tables · 45 views · 8 forms · 17 automations · sample rows included, so it opens looking like a working app

Use this template

Tables

Departments

Code, Department, Plant, Manager, Cost centre, Shift model, Annual budget, Spend to date, Planned headcount, Team, Headcount, Monthly payroll, Building, Phone and 7 more

Employees

Personnel number, Name, Department, Department code, Position, Contract, Skills, Shift, Hired on, Gross salary, Hourly rate, Vacation days left, Appraisal, Badge and 6 more

Shift patterns

Code, Shift, Starts, Ends, Working days, Department, Plant, Shift supervisor, Rotation, Planned headcount, Minimum to run, Shift premium, Break, Paid hours and 7 more

Entry system

Entry, Employee, Badge, Name, Day, Week, Clock in, Clock out, Time on site, Gate, Shift, Status, Terminal IP, Terminal MAC and 3 more

Vacation planner

Request, Employee, Name, Type, Period, First day, Last day, Working days, Status, Approver, Submitted at, Cover, Department, Shift and 8 more

Working stands

Code, Working stand, Type, Department, Operating procedure, Status, Operator on duty, Shift, Capacity per hour, OEE, Availability, Hours since service, Machine serial, PLC address and 5 more

Standard operating procedures

Document, Title, Revision, Status, Category, Owning department, Author, Approved by, Effective from, Review due, Hazard level, Useful votes, Tags, Intranet link and 3 more

Items

SKU, Item, Type, Unit, EAN-13, UPC, HS code, UNSPSC, Standard cost, List price, Lead time (days), Minimum stock, Weight (kg), Quality critical and 5 more

Bill of materials

Line, Assembly, Assembly item, Component, Component item, Quantity per unit, Unit, Scrap allowance, Position, Operation, Supply, Component cost, Revision, Critical part and 6 more

Warehouses

Code, Warehouse, Type, Address, City, Country, Timezone, Opens, Warehouse keeper, Capacity (m³), Occupied (m³), Bin locations, Dock doors, Climate controlled and 7 more

Inventory

Lot, SKU, Item, Item name, Warehouse, Bin, Quantity, Unit, Status, Unit cost, ABC class, Reorder point, Responsible, Received and 8 more

Suppliers

Code, Supplier, Country, VAT number, DUNS, IBAN, BIC, Currency, Incoterm, Contact, E-mail, Phone, Website, Rating and 6 more

Purchase orders

Purchase order, Supplier, Supplier name, Status, Buyer, Ordered on, Promised, Received on, Incoterm, Currency, Order lines, Lines, Ordered quantity, Net amount and 7 more

Purchase order lines

Line, Purchase order, Order reference, Item, SKU, Description, Ordered, Received, Unit, Unit price, Discount, VAT rate, Line status, Deliver to and 7 more

Customers

Code, Customer, Country, VAT number, LEI, Delivery address, Contact, E-mail, Phone, Segment, Payment terms, Credit limit, Open balance, Account manager and 8 more

Sales orders

Sales order, Customer, Customer name, Status, Priority, Ordered on, Requested date, Confirmed date, Customer reference, Order value, Discount, Currency, Payment terms, Incoterm and 7 more

Production orders

Production order, Item, Item record, Item name, Sales order, Sales order reference, Working stand, Stand code, Status, Priority, Shift, Supervisor, Quantity ordered, Quantity produced and 16 more

Quality inspections

Inspection, Production order, Order reference, Lot number, Lot, Inspection type, Result, Inspector, Checked at, Sample size, Defects found, Measured value, Lower limit, Upper limit and 6 more

Nonconformities

Nonconformity, Inspection, Inspection reference, Item, Lot number, Lot, Severity, Status, Disposition, Owner, Opened, Due, Closed, Quantity affected and 6 more

Repairs and maintenance

Repair order, Working stand, Stand code, Type, Status, Priority, Technician, Reported at, Scheduled for, Completed, Downtime, Labour hours, Labour rate, Parts cost and 5 more

Forwarders

Code, Forwarder, Mode, Hub, Hub clock, DUNS, VAT number, Contact, E-mail, Phone, Tracking, Currency, Rating, On-time delivery and 3 more

Shipments

Shipment, Direction, Status, Sales order, Order reference, Forwarder, Forwarder name, From warehouse, Origin, Destination, Delivery address, Incoterm, Dispatched at, ETA and 10 more

Goods receipts

Receipt, Order line, Order line reference, Supplier, SKU, Item, Quantity received, Received on, Supplier batch, Lot number, Lot, Held in, Incoming inspection, Inspection and 2 more

Lot movements

Movement, Type, Lot, SKU, Item, Quantity, Document, Supplier or customer, When

Views

Forms

Automations

It is a starting point, not a fixed product

Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.

More Supply chain & logistics templates

All templates