Incorrect sorting by VVM status on Fulfill Order screen

Description

As per the primary sort for lots is by VVM status and then by expiry date. Stage 2 lots should appear before Stage 1 or undefined lots. This does not seem to be the case, and No stage + No expiry date lots appear before stage 2 lots.

Repro steps:
1. Log in as divo1
2. Start physical inventory for EPI program
3. For MRK-ROTA-1-1234 product and lot ROTAM2017B select VVM status stage 2
4. Go to order fulfillment screen
5. Start fulfillment for any order
6. Notice the no VVM status + no expiry date goes first for MRK-ROTA-1-1234

Open questions:
Is it expected that No VVM + No expiry date goes first? If so, needs to be rewritten.

 

Update:

Stage1 VVM Status and No VVM Status should be treated as the same in a sort order, so a lot with a smaller available Stock on Hand should come first. However, a lot with VVM Stage 1 status comes before a lot with no VVM Status when expiry dates are the same, even if it's Stock on Hand is higher.

Expected state according to the test:

  • Primary Sort is by VVM Status. Lots with VVM status 2 sort first ahead of VVM status 1 or n/a. (N/a = No associated VVM status.) Within the VVM status 1 or n/a, system sorts by the next sort criteria below, Expiry date.

  • Secondary Sort is by the following fields:

  1. Expiry date - recommend products/lots with an earlier expiry date (nearest expiry lots come first);

  2. Close out a product/lot - recommend products/lots with a smaller quantity remaining, to close out a product/lot.

 

Environment

None

Attachments

2

Activity

Aleksandra Hinc 
February 9, 2023 at 2:40 PM

This issue is still valid.

Szymon Rujner 
February 16, 2022 at 10:57 AM

The issue is still possible to reproduce

Dominika Bieńkowska 
November 4, 2021 at 8:47 AM

Joanna Bebak 
December 31, 2019 at 12:57 PM

The issue is still valid.

Paweł Pinker 
December 9, 2019 at 5:27 PM

Tested again. Now the sorting order is still confusing. Check out the picture below. Lot with no VVM Status / lowest SoH goes last even though according to VVM Stage 1/no status should be treated as the same and lower SoH should go first.

 

Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Labels

Story Points

Components

Priority

Time Assistant

Created August 6, 2018 at 12:17 PM
Updated March 20, 2025 at 1:34 PM