Story

As an admin, I would like to be able to run a script that deactivates entity items if the discontinue date of the corresponding vendor entity item is in the past. This will help me to maintain my list of entity items more accurately.

Details

Based on the request made by CFA to remove inventory items from the site-level inventory item list if the item does not have a current valid vendor item relationship, we need to be able to determine what existing entity items should be disabled and disable them.

The request is to write a script that can be manually run by an admin that:

• Searches the vendor entity items (VEI) list and finds all VEIs with a discontinue date before today.
• Associates those expired VEIs with their corresponding Entity Item.
• Determines if the corresponding Entity Item is not associated with a valid, unexpired, VEI.
  • If the Entity Item is not associated with a valid VEI, deactivate the Entity Item.
  • If it is associated with a valid VEI, do nothing.

This script should include a start and end date range so that we can run it in chunks if processing time requires that.

Acceptance Criteria

Confirm

1. Once the script has been manually run, the correct Entity Items have been disabled and are not present in the UI.
2. Entity items with an expired VEI and a also a valid VEI persist as active.