The following scenario happened :
1. I added a serial number to inventory using Inventory Adjustment :
- Item = Item_A
- Serial Number = Serial_Number_A
- Location = Location_A
- Bin = Bin_A
2. Did an Inventory Transfer ( # Inventory Transfer_A ) :
- Item = Item_A
- Serial Number = Serial_Number_A
- From location = Location_A
- To location = Location_B
- To Bin = Bin_B
3. Another Inventory Transfer back to Location_A ( # Inventory Transfer_B ) :
- Item = Item_A
- Serial Number = Serial_Number_A
- From location = Location_B
- To location = Location_A
- To Bin = Bin_A
4.Entered a Sales order for ( # Sales_order A ):
- Item = Item_A
- Serial Number = Serial_Number_A
5. The first Inventory Transfer was deleted ( # Inventory Transfer_A ).
6. As a result of the deletion on the item record ( Item_A), under Inventory Detail> Inventory Detail there are duplicate rows of Serial_Number_A. One with Bin_A and the second with Bin_B.
7. Fulfill the # Sales_order A ( from Location_A, Bin_A).
8. After the SO was invoiced there are still the duplicate rows Inventory Detail> Inventory Detail and the Serial_Number_A still shows available under Inventory Numbers.
Any idea on how I can fix the data ?