Production Planning Materials

The Materials view shows the materials needed for the jobs currently in production. The planning fields on this view are part of the materials section of the estimate. This page explains the buttons, filters and fields of the Materials list view.

Navigation Example

… Work Orders > Menu (button) > Materials

The path depends on where you added Work Orders to your menu.

Production planning Materials list view, listing the materials required for Work Orders
Production Planning Materials View

Buttons Explained

Button Description
ViewLists the entries that match the selected filters.
Arrow on View ButtonReset Data Filter: Resets all the data filters.
Output

Prints, previews or emails the output if Output Templates are set up for the module.

Export: Exports the list in .xlsx, .htm or .csv format.

EditEdits the entry.
Actions

Lets you change several records at once (select them with Ctrl + left-click). The options are:

  • Batch Update: Changes all the selected records when you click Update (button). The options are:
    • Location: Sets the location to the one selected from the dropdown list.
    • Required: Sets the required date (for the materials) to the one selected on the calendar.
    • Resolve: Sets the resolve option to the one selected from the dropdown list. The options are Purchase or Reserve. If Purchase is set, any inventory location is cleared.
    • Status: Sets the status of the item to the one selected from the dropdown list.
    • Supplier: Sets the supplier to the one selected from the dropdown list.
  • Copy to Purchase Orders: Materials: Creates a Purchase Order.
    • The option might have a different name: it is the copy command created under Copy Rules.
    • You can select several records.
    • If the items belong to different suppliers, or no supplier is filled in, an error appears.
    • Whether the purchase order opens depends on the Copy Rules setting.
  • Copy to Goods Issued: Creates a Goods Issued transaction.
    • The option might have a different name: it is the copy command created under Copy Rules.
    • You can select several records.
Menu

Settings

Views – Transaction

Views – Production

Layout

Filters Explained

Filter Description
SetSelect a date option (e.g. No Date, Today, This Year).
ArrowsAdjusts the date in the direction of the arrow.
Date … to …Set your own dates (based on the selection under Set).
Due Date (radio button)Applies the selected date to filter the records by their due dates (the job’s due date as per the transaction).
Req Date (radio button)Applies the selected date to filter the records by their required dates (the job’s required date as per the transaction).
Required (radio button)Applies the selected date to filter the records by the date on which the material is required.
Pending (checkbox)Shows the Pending jobs.
Active (checkbox)Shows the Active jobs.
Completed (checkbox)Shows the Complete jobs.

Fields Explained

Info

Fields marked in blue (✎) can be edited.

Field Description
IDThe system-generated number for the entry.
TransItem IDThe system-generated number of the transaction item.
Trans IDThe system-generated number for the transaction.
Trans ID (Resolved)The system-generated number for the resolve transaction.
Status (Status Trans)The status of the transaction.
Trans No.The transaction and item number.
DateThe transaction date.
Req Date

The required date. If the date is before today, it appears in red.

  • Required dates are typically used to indicate the date by which the customer requires the goods.
  • The caption may differ: it is set on the Transaction Type.
Due Date

The due date.

  • This date appears in red if it is later than the required date.
  • Due dates are typically used to indicate when the goods must be ready.
  • The caption may differ: it is set on the Transaction Type.
CompanyThe name of the customer or supplier.
ReferenceThe reference entered on the transaction.
ProductThe name of the product.
Status (Item)The status of the item.
Status (Status Mat)

The status of the material.

  • The Materials % complete on the Jobs view is calculated from this status.
  • Statuses are created here: Edit Transaction Type (e.g. Work Order) > Menu (button) > Edit Statuses (Production Materials).
TypeThe type of item.
MaterialThe name of the material.
Description

Read-only.

The description of the linked item. Custom routing without an item (TSK (CNSTR), TSK (C) and OWK (C)) shows the routing description.

SupplierThe name of the supplier if the material is purchased.
Required (Date Req (Mat))The date on which the material is required.
Resolve

The material item’s Resolve.

These options are specific to the production module and are not the resolve options selected for the Transaction Type.

If the material is in stock, the resolve is automatically set to Reserve. If it is not in stock, it is set to Purchase.

Location

The location for the material item.

  • A dropdown list of locations is available if the item has Fixed or All Locations selected next to Inventory (Item Header).
  • If the item is not a material item, or N/A was selected next to Inventory, you cannot select a location.
  • If the Transaction Type has a default location (setting Inventory > Default – Inventory Location (Production Materials)), it is filled in automatically.
  • If the material item has only one fixed location, that location is selected and you cannot select another. This location overrides the Transaction Type’s default location.
In StockThe quantity that is currently in stock.
ReservedThe quantity that is reserved for current orders.
On OrderThe quantity ordered, but not yet received.
AvailableThe quantity that is available.
Unit (Stock)The stock item’s unit.
Qty (Req)The quantity that is required.
Qty (Out)The quantity that is still outstanding.
UnitThe unit of the outstanding quantity.
Resolved

The code, number and date of the resolve transaction.

The cell is colour-coded to match the status of the purchase order.

For example, if the resolve is Purchase and you click Actions (button) > Copy to Purchase Order, this field shows PO (for Purchase Order), the number of the purchase order and the date on which it was created. This purchase order is the resolve transaction.

CreatedThe date on which the entry was created.
UpdatedThe date on which the entry was updated.
Updated ByThe user who last updated the entry.
Widget

A menu that also opens when you right-click the entry. The options are:

  • Open Transaction: Opens the related Work Order.
  • Open Resolve Transaction: Opens the resolve transaction, if there is one (see Resolved).
  • Open Linked Item: Opens the linked item.
  • View Item Summary: Shows the item summary on the right.
  • Copy to Purchase Orders: Materials: Creates a purchase order to purchase materials that have the resolve Purchase.

Report an issue with this page

For more useful feedback, select the text on the page you are reporting on, then click Feedback again — or continue without selecting anything.