Greetings Everyone. I have worked with a close coding friend to develop a spreadsheet which handles requests from a sales department to add new items to an existing database. The current process is as follows:
- Sales Department user opens and completes 'New Item Upload Form' spreadsheet.
- Upon completion and validations passed, form emailed to the "Parts" Department.
- Parts Department does final review and imports into Oracle Database.
The issue to be addressed now pertains to the 'type' of item to be added. Currently the only indicator that an item is a Kit is a listbox indicating Yes or No. I'd like to modify this current spreadsheet to specify the Kit the Bill of Materials which belong to that Kit item. I have added a second tab which attempts to break out this information. I am open to new ideas and any constructive criticism. If there is a better way to approach this, I am all ears.
The concept I have now includes the population of a userform when an item is indicated as a kit 'Yes' in the specified listbox. This userform would allow a user to complete the required information for each item belonging to that kit, the quantity of each item per kit, the cost of the item, and so forth. Once this has been completed, the 'New Item Upload Form' would be submitted to the Parts Department like normal and the Kit BOM would be submitted to Kit's and Components Department and have the Parts Department CC'd on that email.
The BOM tab on this spreadsheet includes the information required for each item. It can be modified if needed. If the item does not currently exist in the Oracle database, then it would be included on both spreadsheets. It would be included on the 'New Item Upload Form' in order to be imported into the Oracle database and also included on the Bill Of Materials spreadsheet in order to have the Kits and Components Department to assign the BOM items to the Kit Part Number within the Oracle Database.
Thanks for the assistance and support with this one.
Link To Previous Questions:
- Previous Question Concerning Spreadsheet