On this page

Material tracking line inquiry

You can inquire on tracked material issues on the Material issue inquiry page and on this page.

Use this page when you need visibility of all your material tracking data at line level.

User type	Admin Manager
Permissions	Full rights: Admin, Manager
Prerequisites	Work order Material tracking
Tip	Select an Error status to view the reason the material tracking or component posting failed.

The main view displays a stock status error for material issues that failed to post. You can re-post failed tracking records from this page after resolving the error.

Analyze material tracking data

The information in the main list is display-only and cannot be modified. It provides visibility of all material tracking data at line level.

You can take advantage of standard grid options like sorting, by displaying table filters, and selecting which columns you want to display to filter or to analyze the material tracking data.

Check the status of each material tracking. If the Stock status displays Draft or Error, the material receipt failed. You need to edit the stock receipt details for the material tracking reference and post the tracking record again.

From the results you can open the following:

The tracking documents
The work order documents
The bills of material: To view the list of components in the finished items

In the Stock status field, select Error to view the reason the material tracking failed to post the material issue.

Select the Costs icon for a line to view additional work in progress costs associated with the tracked item.

Export

When you export the main list, only those lines displayed in the search or filtered results are included in the export. This includes all lines across multiple pages if you have a large data set.

There are 2 export options: Excel or CSV. The default file name is $navigationPanel.

After exporting the data, you can rename the file and edit the Excel spreadsheet or CSV file if needed before uploading to your accounting solution.

Stock status: Error

In the main list, if the Stock status displays Error, select the Material tracking link.

In the material issue details, select Error to view the reasons the material tracking posting failed.
In the Components grid, in the Stock status column for a component number, select Error to view the reason the component stock item posting failed.

You need to resolve the issue and re-post the tracking record so that your work order and stock records are updated. Select Post from the material issue document.

Example Stock status errors

Stock transaction error	Solution
Any stock transaction is forbidden for the [component] item on the [production site] site because a count is in progress.	This error is displayed if a stock count is in progress for the component at the stock site. When a stock count is started, all stock movement transactions for the items on the stock count record are blocked. You can only issue component stock for the work order after the count quantity is entered on the stock count and the stock count is posted.
The number of serial numbers assigned needs to match the quantity for the line. Add serial numbers to match the quantity.	This error is displayed if there is a discrepancy between the component quantity issued to the work order and the issued quantity of serial numbers. You need to allocate and post more serial numbers. Select the More actions icon for the component line then select Allocate stock. Each line in the Stock allocation grid displays serial number entry instructions if the component is serial numbered. If the serial number entry instructions display To select or Partially allocated, you need to add the serial numbers of the issued components. You can issue and track ad hoc serial numbers or a range of sequential serial numbers. From the Serial numbers grid, select Add line. Select the From serial number. To issue ad hoc serial numbers, leave the Quantity as 1. To issue sequential serial numbers, edit the Quantity of sequential serial numbers to include. The To serial number is updated automatically. You do not need to select it. Repeat a, b, and c until you have issued the required quantity of component serial numbers and the serial number entry instructions display Selected. Save the stock allocations, then Post the material issue.
The sum of the stock detail or allocation quantity must be equal to the line quantity.	Material tracking only updates work orders and issues the components from stock when the material tracking is generated. This error is displayed if the material tracking posting failed to register the stock allocations. This might be because the stock allocations on the material tracking were used for a different stock allocation transaction between entering the material tracking allocations and saving the material tracking. Select the More actions icon for the component line then select Allocate stock. In the Detailed stock allocation window, check the storage and inspection status details of the stock and the serial numbers that were issued for production are correct, or edit the details if any are different. Save the stock allocations, then Post the material issue.

Stock transaction error

Solution

Any stock transaction is forbidden for the [component] item on the [production site] site because a count is in progress.

This error is displayed if a stock count is in progress for the component at the stock site. When a stock count is started, all stock movement transactions for the items on the stock count record are blocked. You can only issue component stock for the work order after the count quantity is entered on the stock count and the stock count is posted.

The number of serial numbers assigned needs to match the quantity for the line. Add serial numbers to match the quantity.

This error is displayed if there is a discrepancy between the component quantity issued to the work order and the issued quantity of serial numbers. You need to allocate and post more serial numbers.

Select the More actions icon for the component line then select Allocate stock.
Each line in the Stock allocation grid displays serial number entry instructions if the component is serial numbered.

If the serial number entry instructions display To select or Partially allocated, you need to add the serial numbers of the issued components.

You can issue and track ad hoc serial numbers or a range of sequential serial numbers.
1. From the Serial numbers grid, select Add line.
2. Select the From serial number.
3. To issue ad hoc serial numbers, leave the Quantity as 1.
  
  To issue sequential serial numbers, edit the Quantity of sequential serial numbers to include.
  
  The To serial number is updated automatically. You do not need to select it.
4. Repeat a, b, and c until you have issued the required quantity of component serial numbers and the serial number entry instructions display Selected.
Save the stock allocations, then Post the material issue.

The sum of the stock detail or allocation quantity must be equal to the line quantity.

Material tracking only updates work orders and issues the components from stock when the material tracking is generated. This error is displayed if the material tracking posting failed to register the stock allocations. This might be because the stock allocations on the material tracking were used for a different stock allocation transaction between entering the material tracking allocations and saving the material tracking.

Select the More actions icon for the component line then select Allocate stock.
In the Detailed stock allocation window, check the storage and inspection status details of the stock and the serial numbers that were issued for production are correct, or edit the details if any are different.
Save the stock allocations, then Post the material issue.