We are beginning a new project to manage a warehouse process involving compliance shipments (i.e. Wal-Mart, Target, Amazon, etc.). We're running a legacy ERP system that works just fine for Order Entry and Shipping, etc. We have the source code and have been building on top of that for quite some time.
Currently this process is "managed" manually via two spreadsheets (used by way too many people and corrupted way too often). Most of the information in the spreadsheets can be derived from our current database. Huge amounts of time is spent updating the sheet, or looking for the person who has it open.
This project is going to require some new files (tables) etc. to replace the spreadsheets. Most of the data can be programmatically created/driven from our ERP data, while some of it must be entered/updated. While I could design and write this application using the standard green screen approach, I'd rather not. We use a lot of radio frequency devices (including ipads) to do other things on the i.
So I'm looking for some suggestions...
1. Should I search out a "canned" application? I'd rather it run on DB2/400
2. Should I just create the tables necessary and try to learn PHP or something to serve this as an HTTP application?
3. Should I just create the thing using the 20-year-old green screen approach?
I welcome all opinions.
Thanks,
Greg
Currently this process is "managed" manually via two spreadsheets (used by way too many people and corrupted way too often). Most of the information in the spreadsheets can be derived from our current database. Huge amounts of time is spent updating the sheet, or looking for the person who has it open.
This project is going to require some new files (tables) etc. to replace the spreadsheets. Most of the data can be programmatically created/driven from our ERP data, while some of it must be entered/updated. While I could design and write this application using the standard green screen approach, I'd rather not. We use a lot of radio frequency devices (including ipads) to do other things on the i.
So I'm looking for some suggestions...
1. Should I search out a "canned" application? I'd rather it run on DB2/400
2. Should I just create the tables necessary and try to learn PHP or something to serve this as an HTTP application?
3. Should I just create the thing using the 20-year-old green screen approach?
I welcome all opinions.
Thanks,
Greg
Comment