Materials and Inventory Workflow

Overview

This workflow covers how you build and maintain your materials catalogue, keep stock levels accurate, and review what is on hand. MyApprentice is a web-based app that uses two connected pages for physical stock: Materials (your catalogue, where you add and edit materials and adjust stock) and Inventory (where you view stock levels, value, and transaction history). Reusable line items are managed separately on the Items page. As a sole trader you manage all of this yourself with full access — there are no role handoffs. Accurate materials and stock data feed quotes, jobs, invoices, and supplier invoices.

Who This Workflow Is For

This guide is for a sole trader — a single operator who runs the business alone and manages their own materials, items, and stock with full access.

Before You Start

Decide on the categories you want for organising materials (for example, Electrical, Plumbing, Fasteners). To use the Inventory page, the Inventory feature must be enabled in Business Settings. If the Inventory feature is disabled, the Inventory page is hidden and stock transaction history is unavailable; the Materials page may still be available depending on your feature settings.

End-to-End Workflow

Step 1: Add a material

Build your catalogue so materials are available across the platform.

1. From the left sidebar under INVENTORY, select Materials to open your catalogue.
2. Select Add Material and enter the material name (required), a description if needed, the unit of measure (such as each, m, kg, sqm, L), the cost price, a markup percentage if you use one, and the selling price charged to clients.
3. Select or add a category.
4. Optionally add a storage location and the quantity held there — multiple locations per material are supported.
5. Select Create.

The material is now available for quotes, jobs, supplier invoices, and inventory.

Step 2: Edit a material

Use this when a price, unit, description, or category changes.

1. Open Materials, locate the material, and open its row or edit action.
2. Update the required fields and select Update or Save Changes.

Editing a material’s price affects only future records — it does not change the price on existing draft quotes or jobs already created.

Step 3: Create reusable line items (optional)

Line items are managed on the Items page. A line item defines what you sell to the client — a name, type, selling price, and description.

1. Open the Items page, select Add Line Item, enter the name, type, price, and description, and link any associated materials from your catalogue. Associated materials support internal costing and stock awareness; the line item price determines what the client is charged.
2. Select Save Line Item.

Saved line items can be selected when creating a quote.

Step 4: Adjust stock

Use this when actual stock differs from the system count.

1. Open the adjust-stock process from the Materials page (find the material and select Adjust Stock) or from the Inventory page — both routes open the same adjust-stock process with the same options.
2. Choose the transaction type — Restock, Usage, Waste/Damage, Adjustment, or Return — enter the quantity, and add a reason for corrections or unrecorded movements.
3. Select Update Stock.

The adjustment updates the quantity and is recorded in stock transaction history.

Step 5: Review low stock

During inventory review, identify the materials that need reordering.

1. Open Materials or Inventory and use the Stock Status column to sort materials by stock status.
2. Review items showing low stock (the low stock threshold is currently set at below 5 units) and record the materials that need reordering.

This workflow identifies reorder needs; it does not create a purchase order.

Step 6: Review the Inventory page

Check current stock levels and movement history.

1. From the sidebar under INVENTORY, select Inventory.
2. On the Overview tab, view current stock levels, low-stock alerts, and total stock value (stock on hand value and potential sale value).
3. On the Transactions tab, view the history of all stock movements — materials used on jobs, restocking events, and manual adjustments — with dates and quantities.

Step 7: Review stock transactions

Reconcile and investigate stock movements.

1. On the Transactions tab, review incoming and outgoing movements. When a job is completed, the material usage confirmed during completion writes back automatically to stock transactions, linked to its job number.
2. Filter or sort by type (restock, waste/damage, usage, adjustment, return), source (manual or supplier invoice), date range, or material to investigate discrepancies or reconcile supplier invoice movements.

Common Issues & Limitations

• Inventory feature disabled. If the Inventory feature is turned off in Business Settings, the Inventory page is hidden and stock management and transaction history are unavailable. The Materials page may still be available depending on feature settings.
• Stock adjustments need a transaction type. An adjustment cannot be recorded without a selected transaction type and a quantity. A reason is optional but should be added for corrections or unrecorded movements.
• Manual adjustments only for genuine discrepancies. Use a manual adjustment only when actual stock differs from the system count.
• Low stock threshold. Low stock is currently flagged at below 5 units.
• Editing prices. Editing a material’s price applies only to future records — it does not update prices on existing draft quotes or jobs.

What Happens Next

Materials feed directly into quotes, jobs, and invoices, and into the supplier invoice matching process. Materials needing reorder can be purchased and then captured back into MyApprentice through the Supplier and Supplier Invoice Workflow, which updates stock levels and posts new transactions.

Related Guides

• Supplier and Supplier Invoice Workflow
• Creating a Job and Completing the Work
• Client Enquiry to Accepted Quote