Inventory Checking

[joamag]

Context

Currently, performing inventory checks is a complex and time-consuming process, taking about 4 hours for each type of product check.

Description

We need to build a tool that allows importing Excel files (structured in a specific format) and exporting a report with stock inconsistencies.

UI Requirements

• File upload input for inventory values provided by the stores
• Text field to input the prefix representing the product range

Output Report

• The report should be related to the InventoryCheck entity
• Show missing stock for products with the given prefix
• Group results by store

Additional Features

• Pre-analysis of common mistakes in the provided CSV files from stores, such as:
  • The letter O was mistakenly used instead of the digit 0

Future Enhancements

• Treat Inventory Check as a first-class entity within the system
• Allow Inventory Checks to generate inventory changes with proper justification
• Extend the current inventory check context with these capabilities

Attachments

• InventárioJunho.ods