Screenshots
Inventory Management for Metallurgy
System developed for a Bolivian metallurgical industry that needed precise control
over its raw materials inventory. The system manages aluminum billets,
finished products, and scrap, with daily movement records.
The system's differentiator is the automated monthly closings that generate complete
consumption, loss, and production efficiency reports, essential for industrial management.
Separate management for each material type with specific characteristics and units.
Simplified interface for quick movement recording with real-time validations.
Automatic daily summary generation with input totals, output, and current balance.
Closing process that freezes month data and generates efficiency and consumption reports.
Monthly closings couldn't have rounding errors that accumulated over time.
Used PostgreSQL decimal type with 6 decimal places precision and implemented consistency validations that verify if inputs - outputs = balance before allowing closing.
Management needed to track who made each record and when for auditing purposes.
Implemented a complete audit log system using paper_trail that records all changes with user, timestamp, and previous/new values.
Get in touch to discuss how I can help with your next project.