A small C#/WPF Windows desktop application to track and manage paint inventory.
Cedar Siding, Inc. needs to track stain usage for a number of production and quality related reasons. From a production standpoint we need to have trackability on how and when totes and barrels of coating are being used. From a quality control standpoint this is useful for years later in the event of a coating failure in the field. Batch/LOT information can be captured and recorded for later use in warranty claims with the coating manufacturer.
- Windows 7 SP1 or greater
- .NET Framework 4.6.1 or greater
- Create personnel (operators) to assign to receiving and implementation records
- Receive PO's with paint color, quantities, and batch numbers
- Log used batches in an implementation ledger
- Automatic merging of batches with the same batch number
- Live updating of on-hand inventory
- Reconciliation and error-checking process to ensure receiving and implementation ledgers are consistent after a PO receive/edit session
- Tracking of avialable inventory to ensure a batch is not implemented more than it has been received
- Garner a variety of historical data including:
- Specific batches
- Specific PO's
- PO's in set timeframes or specific date ranges
- See average vessel usage in a 30-day period from most recent record in the implementation ledger
- Show all batches connected to dispensing system on a given date
- Local SQLite database
- Easy backup of existing database and creation of clean database
- Automatic and manual database backups
- Contains installer project to build a software installer (removing previous versions in the process) on other PC's.
Below are a handful of the more used windows that provide functionality to the user.
The primary dashboard of the application. Inventory information is at the ready and batches can be quickly added to the implementation ledger.
Receiving and editing of batches are done from this window.
Find previous PO's for informational purposes or editing.
Get all history on a specific batch - from the date it was added to the date it was used.
Batches are used and connected as needed. The connected history window shows which batch was connected to the dispensing system, for all colors, on a given date.
