Overview
The Traceability Report is a key feature of the BrewersInsight platform, offering brewers the ability to monitor and manage the journey of resources throughout their brewery. From malt and hops to various raw materials, this tool ensures complete visibility of how these components move from suppliers to the brewery and ultimately to the customer. Effective traceability is essential for optimal beer production quality and compliance.
Tech Used
Brewer's Insight is a web application developed using Angular and ASP.NET Core.
Challenges
One of the primary challenges in developing this feature was consolidating data from multiple databases to create four tab-separated tables: Materials on Hand, Materials in Production, Finished Goods, and Shipped Products. This involved establishing connections between materials and their corresponding products. Additionally, I implemented several filters to further refine the results displayed in these tables, including Batch ID, Lot Code, Material, and Supplier.