Home / Technology Projects / Material Status Management: @SpiceWorks

Material Status Management: @SpiceWorks

Front End Application incorporating MS Access, SAP & SQL Server – SQL scripting an Visual Basic scripting


Material Status Management – Finished Goods and Direct Materials

An audit management system for the Data Management area that identifies products and materials that need to be discontinued from production and purchase. The application audits product and material data housed in SAP against eligibility criteria – sales, forecast, inventory, – to identify items that need to be placed in a discontinued status. It was developed using MS Access – SQL Server connection.