We have a workflow on our production line where Garment X has to go through Lining Inspection, Shell Inspection and Final Inspection. It can't go to Final without first hitting the other 2. That being said, at any point Garment X may fail due to a quality defect and have to go to Rework/Repair In and then Rework/Repair Out or Non-Conforming if it's an irregularity that cannot be fixed. Once it's done with Rework/Repair IN and OUT it will need to go back to the failing station. This is what I have so far:
Virtual Field 1: SELECT MAX(StationNumber) FROM Test WHERE Barcode=target.[@field: Barcode]
Virtual Field 2: CASE WHEN '[@cbParamVirtual1]' = 'Lining Inspection'
WHEN '[@cbParamVirtual1]' = 'Shell Inspection'
Virtual Field 3: CASE WHEN [@field:StationNumber] = 'Lining Inspection'
WHEN [@field:StationNumber] = 'Shell Inspection'
Virtual Field 4: CASE WHEN '[@cbParamVirtual1]' = ''
WHEN '[@cbParamVirtual4]' + 1 != '[@cbParamVirtual6]' THEN 1/[@cbParamVirtual7]
Virtual Field 5: 0
What currently happens, is if you enter Serial 123456 into Lining Inspection, it will pass. When you enter Serial 123456 into Final Inspection instead of Shell Inspection, it will be rejected as it should. The issue I'm running into, is I need to be able to make lateral movements. If Serial 123456 fails Lining Inspection, I need to be able to send it to Rework/Repair IN and then OUT before sending it back to Lining Inspection.
Please let me know if I didn't explain this well enough. Thanks in advance!