How Issue and Return of Plain Items Affect Material Transactions

Plain items refer to those that are neither serial nor lot-controlled. Plain items returned to a subinventory or locator can be returned for a replacement and not always returned for being excess. To track the returned and replaced items separately, use the Replace check box at the row level on the Report Material Transactions page. If this check box isn't selected, the entire quantity of plain components will continue to remain in the hierarchy.

When updating inventory, components that are issued or returned aren't separately tracked because on-hand quantities are added to the same subinventory and locator. For instance, let's say you have 10 plain items installed on the hierarchy and 10 on-hand quantity in inventory. If you issue 5 to the hierarchy, then you have 5 in inventory and 15 in the hierarchy; panels of 5 and 10 each. Later, if you return 10 from the hierarchy, the on-hand quantity becomes 15. In such scenario, the application won’t know which components were returned as excess from those that were added to the inventory for the first time.

To differentiate returns and replacements, use the Replace check box at the row level on the Report Material Transaction page. The Replace check box works alongside the return transaction type and lets you to control whether the return transactions are meant for replacement of the component. When the check box is left blank, it means that the previously issued component is returned for being excess. On the other hand, if the check box is selected, the return component replaces the existing one. Selecting the Replace check box updates the existing panel quantities on the hierarchy, whereas leaving the check box blank won’t.

Your selection for the Replace check box decides the recorded transaction in the back end, as shown in this table:

# Use Case Material Requirement Material Quantity First Transaction (UI) First Transaction Saved on Transaction History Material Quantity After Issue Second Transaction (UI) Second Transaction Saved in Transaction History Material Quantity After Return
1

Issue first and then Return Item

Replace Check Box = Un checked

Yes (10 Ea )

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 10

Org on Hand Balance: 10

Including in Planning: Checked

Issue

Qty = 5 Ea

Material Issue

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 5

Open Quantity: 5

Org on Hand Balance: 5

Including in Planning: Checked

Return

Qty = 3 Ea

Material Return

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 2

Open Quantity: 8

Org on Hand Balance: 8

Including in Planning: Checked

2

Return first and then Issue Item

Replace Check Box = Un checked

Yes (10 Ea )

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 10

Org on Hand Balance: 10

Including in Planning: Checked

Return

Qty = 4 Ea

Miscellaneous Receipt

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 10

Org on Hand Balance: 14

Including in Planning: Checked

Issue

Qty = 4 Ea

Material issue

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 4

Open Quantity: 6

Org on Hand Balance: 10

Including in Planning: Checked

3

Issue first and then Return Different

Replace Check Box = checked

Yes (10 Ea )

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 10

Org on Hand Balance: 10

Including in Planning: Checked

Issue

qty = 5 Ea

Material Issue

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 5

Open Quantity: 5

Org on Hand Balance: 5

Including in Planning: Checked

Return

qty = 4 Ea

Miscellaneous Receipt

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 5

Open Quantity: 5

Org on Hand Balance: 9

Including in Planning: Checked

4

Return first and then Issue Different

Replace Check Box = checked

Yes (10 Ea )

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 10

Org on Hand Balance: 10

Including in Planning: Checked

Return

qty = 5 Ea

Miscellaneous Receipt

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 10

Org on Hand Balance: 15

Including in Planning: Checked

Issue

Qty = 7 Ea

Material Issue

Required Quantity: 10

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 7

Open Quantity: 3

Org on Hand Balance: 8

Including in Planning: Checked

5

Issue first and then Return

Replace Check Box = Un checked

No

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 0

Org on Hand Balance: 10

Including in Planning: Un-Checked

Issue

qty = 8 Ea

Material Issue

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 8

Open Quantity: -8

Org on Hand Balance: 8

Including in Planning: Un-Checked

Return

Qty = 5 Ea

Material Return

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 3

Open Quantity: -3

Org on Hand Balance: 13

Including in Planning: Un-Checked

6

Return first and then Issue item

Replace Check Box = Un checked

No

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 0

Org on Hand Balance: 10

Including in Planning: Un-Checked

Return

Qty = 25 Ea

Miscellaneous Receipt

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 0

Org on Hand Balance: 35

Including in Planning: Un-Checked

Issue

Qty = 20 Ea

Material Issue

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 20

Open Quantity: -20

Org on Hand Balance: 15

Including in Planning: Un-Checked

7

Issue first and then Return Different

Replace Check Box = checked

No

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 0

Org on Hand Balance: 10

Including in Planning: Un-Checked

Issue

Qty = 5 Ea

Material Issue

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 5

Open Quantity: -8

Org on Hand Balance: 5

Including in Planning: Un-Checked

Return

Qty = 8

Miscellaneous Receipt

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 5

Open Quantity: -8

Org on Hand Balance: 13

Including in Planning: Un-Checked

8

Return first and then Issue Different

Replace Check Box = Un checked

No

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 0

Org on Hand Balance: 10

Including in Planning: Un-Checked

Return

Qty = 10 Ea

Miscellaneous Receipt

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 0

Open Quantity: 0

Org on Hand Balance: 20

Including in Planning: Un-Checked

Issue

Qty = 8 Ea

Material Issue

Required Quantity: 0

Reserved Quantity: 0

Allocated Quantity : 0

Picked Quantity: 0

Issue Quantity: 8

Open Quantity: -8

Org on Hand Balance: 12

Including in Planning: Un-Checked