Skip to content

Repair Order Lines (Repair Parts)

Repair Order Lines allow technicians and managers to assign multiple items — parts, materials, and service items — to a Repair Order. Each repair order can have multiple lines, following the standard Business Central document header/lines pattern (similar to Sales Orders). This ensures all parts used during repair can be accurately recorded and tracked.

Overview

With Repair Order Lines, you can:

  • Assign any item from your inventory to a Repair Order
  • Add multiple item lines per Repair Order
  • Track quantities, units of measure, and consumption status per line
  • Benefit from automatic Unit of Measure (UoM) conversion with base quantity calculation
  • Inherit location and bin defaults from the Repair Order header
  • Automatic line creation and removal when solutions are added to or removed from a Repair Order
  • Track which solution triggered the creation of each line

Understanding Repair Parts Fields

The Repair Parts subpage is located on the Repair Order Card, below the Solutions section. Each line contains the following fields:

Visible Fields

Field Description
Item No. The item assigned to this line. When selected, automatically populates Item Description and Unit of Measure Code
Item Description Description of the item, automatically populated from the Item record
Location Code The warehouse location for this line. Defaults from the Repair Order header if not specified. Only non-transit locations are available
Bin Code The specific bin within the location. Defaults from the Repair Order header. Automatically clears when Location Code changes
Unit of Measure Code The unit of measure for the quantity. Defaults to the item's Base Unit of Measure. Changing this recalculates all base quantities
Quantity The quantity of the item in the selected unit of measure. Changing this recalculates Qty. (Base) and Qty. to Consume
Qty. to Consume The quantity to be consumed from this line. Automatically calculated as Quantity minus Qty. Consumed, but can be manually adjusted
Qty. Consumed The quantity that has already been consumed (read-only, populated by future posting functionality)

Hidden Fields (Available via Personalization)

Field Description
Solution Code The repair solution that triggered automatic creation of this line (read-only, system-managed). See Automatic Line Management
Qty. (Base) Quantity converted to the base unit of measure
Qty. to Consume (Base) Qty. to Consume converted to the base unit of measure
Qty. Consumed (Base) Qty. Consumed converted to the base unit of measure
Qty. per Unit of Measure The conversion factor between the selected unit of measure and the base unit (read-only)

Adding Parts to a Repair Order

  1. Open the Repair Order Card for the repair order you want to add parts to

  2. Navigate to the Repair Parts section below the Solutions subpage

  3. Select an Item: In the Item No. field, use the lookup to select an item from your inventory

  4. Item Description automatically populates from the item record
  5. Unit of Measure Code defaults to the item's Base Unit of Measure
  6. Qty. per Unit of Measure is set to 1 for the base UoM

  7. Enter Quantity: Specify how many units are needed

  8. Qty. (Base) automatically calculates using the conversion factor
  9. Qty. to Consume automatically equals Quantity (when nothing has been consumed yet)

  10. Adjust Unit of Measure (Optional): Change the UoM if needed

  11. Only units configured for the selected item are available
  12. Changing UoM automatically recalculates the conversion factor and all base quantities

  13. Adjust Location and Bin (Optional): Override the default location and bin if parts come from a different warehouse location

Unit of Measure Conversion

Repair Parts follow standard Business Central UoM conversion logic:

  • Base Quantity Calculation: Qty. (Base) = Quantity × Qty. per Unit of Measure
  • Rounding: Base quantities use 5-decimal precision (0.00001)
  • Default UoM: When an item is selected, the system uses the item's Base Unit of Measure as the default
  • UoM Change: When changing the Unit of Measure Code, the system looks up the conversion factor from the Item Unit of Measure table and recalculates all base quantities

UoM Conversion Example

If an item has a base UoM of PCS (pieces) and an alternate UoM of BOX with a conversion factor of 12:

  • Entering Quantity = 5 with UoM = BOX results in Qty. (Base) = 60
  • Changing UoM back to PCS recalculates Qty. (Base) = 5

Qty. to Consume Behavior

The Qty. to Consume field tracks how much of the line should be consumed during repair:

  • Automatic Calculation: When Quantity changes, Qty. to Consume is automatically set to Quantity - Qty. Consumed
  • Manual Adjustment: You can manually lower the Qty. to Consume if not all parts will be used immediately
  • Validation: Qty. to Consume cannot exceed Quantity - Qty. Consumed — the system prevents setting a value higher than what remains available
  • Base Conversion: Qty. to Consume (Base) is automatically calculated using the UoM conversion factor

Partial Consumption

If a line has Quantity = 10 and Qty. Consumed = 3, the maximum Qty. to Consume is 7. Attempting to set a higher value will result in an error.

Default Values from Header

When a new Repair Parts line is inserted:

  • Location Code: Automatically copied from the Repair Order header's Location Code (if the line's Location Code is empty)
  • Bin Code: Automatically copied from the Repair Order header's Bin Code (if the line's Bin Code is empty)

These defaults can be overridden on individual lines. If a line already has a Location Code before insertion, the header's value is not applied.

Field Behavior and Dependencies

Item No. Dependencies

  • Setting Item No. populates: Item Description, Unit of Measure Code, and Qty. per Unit of Measure
  • Clearing Item No. resets: Item Description, Unit of Measure Code, Qty. per Unit of Measure (to 1), Quantity (to 0), and all base quantities (to 0)

Location Code Dependencies

  • Changing Location Code automatically clears Bin Code to prevent invalid combinations
  • Only non-transit locations are available for selection

Quantity Dependencies

  • Changing Quantity recalculates Qty. (Base) and Qty. to Consume
  • If parts have already been consumed (Qty. Consumed > 0), the Qty. to Consume adjusts accordingly

Automatic Line Management

Repair Order Lines can be automatically created and removed based on the solutions applied to a Repair Order. When a solution is added to the Repair Order Solutions subpage, the system checks for items linked to that solution (via Item Repair Solutions) and creates lines automatically. When a solution is removed, the related lines are cleaned up.

Automatic Line Creation

When a solution is added to a Repair Order:

  1. The system looks up all items linked to the solution in the Item Repair Solution table
  2. For each linked item, a new Repair Order Line is created with:
  3. Item No. set to the linked item
  4. Quantity set to 1
  5. Solution Code set to the solution that triggered the creation
  6. If an item is marked as Unique on Order and a line for that item already exists on the order, the item is not added again (preventing duplicate lines)
  7. Items not marked as Unique on Order create a new line for each solution, even if the same item already appears on the order

Bulk Adding Solutions

Use the Add Item Solutions action on the Repair Order Solutions subpage to select and add multiple solutions at once from the item's predefined solution list. You can select multiple solutions in the dialog by holding Ctrl while clicking.

Automatic Line Removal

When a solution is removed from a Repair Order, the system handles related lines as follows:

  1. Lines with no consumption (Qty. Consumed = 0): These lines are candidates for removal
  2. Lines with consumption (Qty. Consumed > 0): These lines are always preserved — they are never automatically removed because they represent consumed parts
  3. Unique on Order items shared by multiple solutions: If another solution on the order still references the same unique item, the line is reassigned to that solution (the Solution Code is updated) rather than deleted
  4. Unique on Order items with no remaining solutions: If no other solution on the order references the unique item, the line is deleted

Consumed Lines Are Preserved

Lines where quantities have already been consumed are never removed automatically, even when the associated solution is deleted. This ensures that consumption records are not lost.

Solution Code Traceability

The Solution Code field on each Repair Order Line provides traceability between lines and the solutions that created them:

  • The field is automatically populated when a line is created through solution management
  • It is read-only and cannot be manually edited
  • It can be used to understand why a particular item was added to the repair order
  • The field is available via personalization on the Repair Parts subpage and via the API

Cascading Delete

When a Repair Order is deleted, all associated Repair Parts lines are automatically deleted. No orphaned line records remain in the database.

Permissions

Role Line Permissions Description
Manager Read, Insert, Modify, Delete Full access to manage repair parts
Technician Read, Insert, Modify, Delete Full access to manage repair parts
Read Only Read Can only view repair parts

API Integration

Repair Parts are accessible through the Repair Order Line API page for integration with external systems:

  • API Group: quickRepair
  • Entity Name: repairOrderLine / repairOrderLines
  • OData Key: SystemId
  • All fields are exposed including base quantities, conversion factors, and solutionCode

Troubleshooting

Q: Item Description is not populating when I select an item A: Verify that the item exists in the Item table and has a description defined.

Q: I can't change the Unit of Measure Code A: Ensure the item has alternate units configured in the Item Unit of Measure table. Only units defined for the selected item are available.

Q: Qty. to Consume shows an error when I try to change it A: The value cannot exceed Quantity minus Qty. Consumed. Check if parts have already been consumed from this line.

Q: Location or Bin didn't default from the header A: Defaults only apply when the line's Location Code or Bin Code is empty at the time of insertion. If you set a location before inserting, the header value is not applied.

Q: I can't select a specific location A: In-transit locations are excluded from the selection. Only standard warehouse locations are available for repair parts.

Q: Base quantities seem incorrect after changing the Unit of Measure A: Verify that the Item Unit of Measure record has the correct conversion factor (Qty. per Unit of Measure) configured for the selected UoM.

Q: Lines were automatically added to my repair order — where did they come from? A: When a solution is added to the Repair Order Solutions subpage, the system automatically creates lines for items linked to that solution via Item Repair Solutions. Check the Solution Code field (enable it via Personalization) to see which solution triggered each line.

Q: I deleted a solution but some lines were not removed A: Lines with Qty. Consumed > 0 are never automatically removed to protect consumption records. Additionally, lines for items marked as "Unique on Order" may be reassigned to another solution on the order instead of deleted. See Automatic Line Removal for details.

Q: I expected only one line for an item but see multiple lines A: The item may not be marked as "Unique on Order" in the Item Repair Solutions setup. Without this flag, a separate line is created for each solution that references the item.

Q: The Solution Code field is empty on a line I manually added A: The Solution Code field is only populated for lines created automatically through solution management. Manually added lines do not have a Solution Code.


For additional support or questions about Quick Repair, contact BC4All support or consult the community forums.