Entity Item Import - Update to support UPT

As a system admin I want the Entity Item Import to be updated to support UPT so that CFA can send us UPT values for entity items

Notes

• Stores will get UPT values either from CFA, or it will be calculated by InFORM
• When one item is imported with a UPT, the whole store should be set to getting UPT via import, the UPT source is a store based setting, not an item level setting

Acceptance Criteria

1. Confirm when a UPT value for an item is first imported into InFORM, the store is marked as UPT Source being Import, rather than using InFORM Generated UPT
2. Confirm that there is a way to revert a store back to InFORM generated UPT
3. Confirm when a store is marked as UPT Imported, and the AutoCalc (Use System Calculation) value of an item is set to TRUE, and a UPT value is imported for that entity item, the UPT is updated
4. Confirm when a store is marked as UPT Imported, and the AutoCalc (Use System Calculation) value of an item is set to FALSE, and a UPT value is imported for that entity item, the UPT is NOT updated. In this case the user has chosen to set the UPT value
5. Confirm that the UPT Field is an Optional filed in the Entity Item Import
6. Confirm that the Entity Item Import can function with only StoreNumber|ItemCode|UPTQuantity
7. Confirm when processing an Entity Item Import file, and a UPT value is provided, that value must be equal to, or greater than zero
8. Confirm when processing an Entity Item Import file, and a negative UPT value is provided, that record is skipped and audit details are written to the auto notification framework
9. Confirm that the Entity Item Import can be used to process only UPT values, if needed
   • UPT might be on its own, or come in with either YCF or SS
10. Confirm that the CSV version of the Entity Item Import supports UPT
11. Confirm that the XML version of the Entity Item Import supports UPT

1. Confirm when an entity item import containing UPT values is successfully processed by InFORM, the store is now flagged as receiving UPT via Import
2. Confirm that there is someway in the UI to determine the source of the UPT for a store (Zone Manger/Corp Rules/Etc...)

• There is a new Zone for stores that import their UPT values: "Ordering - Import UPT Quantity", stores in this zone will not AutoCalculate UPT

1. Confirm when a store has NOT processed an entity item file containing UPT, that store is still flagged as having UPT calculated by InFORM
2. Confirm that there is a way to move a store from Imported UPT back to Inform Calculated UPT

• This can be accomplished by moving a store out of the new "Ordering - Import UPT Quantity" zone

XSLT Change

The XML Entity Item Import preprocess xslt will have to be modified for the UPT Quantity field. See attached file for updated XSLT.