I'm currently working for distributor of liquid admixture for concrete in 1000lt. packs, some clients stack packs for months without sending it back, and it gets hard to trace and monitor the exact count packs that went there.
I wanted to make things better and created a Java application with database where my colleagues can write pack's ID and location when sending to keep track of each pack.
The app was tested and launched six months ago and since then is used daily. Some of the advantages are: preventing duplicate records and human mistake factor, fast and easy searching with specific criteria, separating duplicated records in different table, export to Excel file with table form, keyboard shortcuts and more.
Developed to replace old techniques for tracking and monitoring warehouse activity, avoiding human mistake the app turns warehouse monitoring into an easy task.
Creating new records or Updating existing.
Database file and trace are created on first start after packing an installer in the installation directory folder, easy tracking erors and activity by oppening the db.trace file.
Export to Xcel table with functionallity to export selected by search field records, ordered by columns or just all records.
When search filter is applied the excel export is only with the current table results, that by it self makes individual client monitoring easier.
Recognising duplicated pack-numbers, handling exceptions and moving duplicated numbers to different database table. Comments if some event happens to certain pack.
Duplicated packs are moved to special table where they wait to get assigned with new number. When the problem pack gets the new number it can be returned to the main table with all other packs.
