PDA

View Full Version : Master data check



ErosOlmi
09-10-2006, 16:55
Problem:

master data consistency and alerts.
Every night a company has to check master data (customer, supplier, goods, transactions) consistency and, in case of errors or warning, a mail is sent to relevant responsible in order to take actions. Among other checks: data is complete? no important field missed? Is stock under minimum values? are supplier requested to deliver goods tomorrow?

Solution:

thinBasic.
Using ODBC module to connect to each master data. Perform relevant checks.
Use SMTP module to prepare emails to be sent to responsible people