The tables behind Pharma ERP

Batch Release Reviews for ERP for Pharma.

Stability Studies for ERP for Pharma.

A quantity received or made together: supplier lot, receipt date and expiry, traced through issue, production and shipment.

People for ERP for Pharma.

Users

Certificates of conformance, material test reports and calibration certificates, attached to a supplier lot or an instrument.

Catalog of all items: finished goods, sub-assemblies, raw materials, components, and consumables.

BOM header - the recipe for producing a given product.

Each raw or sub-assembly consumed to build the parent product.

Routing header - the sequence of operations required to build a product.

Each operation in the routing sequence.

An engineering change order groups the item, bill and routing edits that land together, carries its approvals, and applies on an effective date.

One decision on a requisition, purchase order, count variance, change order or supplier invoice: who decided, when, and the reason on the record.

Shop-floor orders to produce a specific product in a specific quantity.

Exploded BOM demand for a work order - what raw material is needed and from where.

Exploded routing steps for a work order - what runs where, in what sequence.

A cost rollup run: it walks the bill and routing into a pending standard, is reviewed, and activates with a revaluation entry.

Customer orders driving finished-goods demand.

Line items of a Sales Order.

Forecast demand by item and period, entered or imported, consumed by actual orders as they arrive.

The master production schedule: what finished goods will be built, in what quantity, in which period, at which plant, inside its time fences.

A proposal from the MRP run: a planned work order or planned purchase, pegged to the demand that caused it.

The action list from the planning run: expedite, de-expedite, cancel, past due and the shortage list, sorted by need date.

Shop-floor orders to produce a specific product in a specific quantity.

Exploded BOM demand for a work order - what raw material is needed and from where.

Exploded routing steps for a work order - what runs where, in what sequence.

Shop-floor time/qty transactions against a work-order operation.

Machines, cells, and assembly stations where operations are performed.

Working calendars for the plant and its work centres: working days, hours per day, holidays and planned downtime the planning run respects.

A shift on a calendar: when it starts and ends, and the work centre it runs at.

A shop-floor operator: the employee, the work centre they run, their shift and how they report time and quantity.

Every physical movement of stock - receipt, issue to WIP, completion, transfer, scrap.

A request to buy: item, quantity, need date, cost centre and reason, from the MRP run or from a person.

Orders to vendors for raw materials and components.

Line items of a Purchase Order.

Physical receipt of raw materials against a purchase order.

The supplier record: the contact, terms, currency, lead time, whether receipts need inspection and whether the supplier is on the approved list.

An item a supplier is approved to supply: their item number, the agreed price, minimum order and lead time.

Master list of business contacts (customers, vendors).

A request for quotation sent to several suppliers for an item, with the replies compared on one screen and the award recorded.

One decision on a requisition, purchase order, count variance, change order or supplier invoice: who decided, when, and the reason on the record.

What to check for an item at a point, incoming, in-process at an operation or final, with the sampling rule; versioned.

Quality inspections on incoming material, in-process, and final release.

The measured value or pass and fail per characteristic on one inspection.

A difference the three-way match found between the invoice, the order and the receipt, with the amount and who it is with.

A supplier's invoice, matched line by line to the purchase order and the goods receipt within tolerances before it becomes payable.

A quantity received or made together: supplier lot, receipt date and expiry, traced through issue, production and shipment.

On-hand stock per product per warehouse.

Every physical movement of stock - receipt, issue to WIP, completion, transfer, scrap.

Stock reserved against a sales order or work order need date, hard to a lot or soft to a quantity.

One record per serialised unit: its lot, the work order that made it and the delivery it left on.

Physical storage locations including raw stores, WIP buffers, and finished-goods warehouses.

Bins, racks, line-side positions and docks inside a warehouse, with the zone an item may be restricted to.

A cycle count or a full physical inventory: the warehouse, the ABC class it picks, when it runs and who approves the variances.

One counted item and location: the book quantity, the counted quantity and the variance waiting for approval.

Catalog of all items: finished goods, sub-assemblies, raw materials, components, and consumables.

A shipment to a customer against a sales order: picked, packed and sent with the carrier reference, and the lots and serials on it.

A hold on a lot, a receipt or a work-order operation: nothing on hold can be issued, shipped or completed until the disposition lifts it.

What to check for an item at a point, incoming, in-process at an operation or final, with the sampling rule; versioned.

One characteristic on a plan: what is measured, how, with which instrument, and the limits.

Quality inspections on incoming material, in-process, and final release.

The measured value or pass and fail per characteristic on one inspection.

Gauges and instruments with calibration intervals; an overdue instrument cannot be selected on an inspection.

Certificates of conformance, material test reports and calibration certificates, attached to a supplier lot or an instrument.

A hold on a lot, a receipt or a work-order operation: nothing on hold can be issued, shipped or completed until the disposition lifts it.

A failed inspection, a customer complaint or a floor observation, pointing at the lot, supplier, machine and operator, with its root cause.

The action that closes a non-conformance: an owner, a due date, and a verification by someone else before it closes.

Physical receipt of raw materials against a purchase order.

A supplier's invoice, matched line by line to the purchase order and the goods receipt within tolerances before it becomes payable.

A difference the three-way match found between the invoice, the order and the receipt, with the amount and who it is with.

A payment run releasing matched invoices: who prepared it, who authorised it, and the bank account it draws on.

One supplier payment inside a run: the invoice it settles, the amount and the reference the bank returns.

The customer invoice a shipment raises at the order price; partial shipments invoice partially.

Money received from a customer and applied to its invoices.

A cost rollup run: it walks the bill and routing into a pending standard, is reviewed, and activates with a revaluation entry.

The standard cost of an item by element, material, labour, overhead and outside processing, pending or current, activated on a date.

Accounting chart of accounts.

Accounting journal entries auto-posted from stock movements, work-order closures, receipts, and shipments.

Line items of a journal entry.

The fiscal periods postings land in; a locked period takes a posting only after a named role reopens it.

One decision on a requisition, purchase order, count variance, change order or supplier invoice: who decided, when, and the reason on the record.

Read-only effective exchange rates for this app.

Organizational departments (Production, Quality, Procurement, Finance, HR, IT).

Plant employees including operators, planners, buyers, and QC inspectors.

Line items of a quote.

A priced offer to a customer: items, quantities, the price from the list or a configuration, and the requested date.

Per receipt, the facts the supplier scorecard rolls up: on time, quantity accurate, the inspection result and the price variance.