email messaging for BPCS (reply on mail Bob Benton 30-11-2000)

Dear Bob,

I agree that there are several tools on the market to send out email
messages and warnings, but most of these tools convert the spool file data.
These tools require a lot of additional set-up work or even programming or
difficult configuration.
One of the most integrated email solutions for BPCS at this moment is
ECS/integrated email. This product is already fully integrated with the
BPCS/ECM module and with the TLE/400 EDI software. This product can send out
ANY AS/400 spool file out as e-mail in TXT, PDF or HTML format, and can do
direct email-to-fax.
Additional the product provides; 1) pro-active error notification for
TLE/400 and ECM as email, SMS or pager messages, 2) digital spool file
archiving, 3) direct AS/400 messaging, 4) AS/400 MSGQ and system monitoring,
5) Spool file distribution to specific printers, based on spool file
content, 6) div other functions for BPCS users that you can find on
www.ecsie.com

Regards,

Ben Rinkel
Electronic Commerce Solutions Int. B.V.
P.O.Box 22
1687 ZG  WOGNUM
The Netherlands

Office:      (+31) 229 574331
Fax:          (+31) 20 5241642
Mobile:    (+31) 65317 4449
email:      ben.rinkel@ecs-europe.com
Internet:  www.ecs-europe.com

From: bbenton@ssax.com
Subject: referential integrity

From: BOB BENTON@SSA on 11/28/2000 02:50 PM


To:   BPCS-L@midrange.com
cc:
Subject:  referential integrity

Yesterday Mitch Damon from Agrilink Foods posed a question about referential
integrity (please see his e-mail below).  Mitch explained that his problem
is
that he wanted to ensure that under certain situations in BPCS, that certain
data relationships existed, and be notified if they do not.   For example,
if a
forecast or customer order exists at a Distribution Center and a
Distribution
Relationship did not exist for that same item / to facility combination, he
wanted to be notified.  Often this problem went undiscovered until they were
late shipping the customer order.

There are a number of solutions that can solve this problem.  They could
include:
1.   An report that will list when this situation exists.
2.   An automatic notification that is e-mailed to someone for resolution.

SSA Global Technologies has a solution offering from our Global Development
Center (GDC) in Toronto called Lotus Notes Messaging.  It is characterized
by:
1.   Queries are preformed against the BPCS (or any database) can be done on
demand or scheduled to run automatically at defined     intervals.
2.   When a condition is discovered that meets the selection criteria, a
customized e-mail message is sent to predefined users notifying them of the
condition and need for resolution.
3.   Though the solution utilizes Lotus Notes, it can send the customized
messages to any e-mail address / software (MS Outlook, Yahoo, for
example)
4.   There are countless applications for this type of notification
solution.
Some of the existing messages we have done for other BPCS clients
include:
     Order Acknowledgements
     Credit Hold notifications
     Purchase Order and Requisition approval notifications
     Credit Dunnings
     Electronic Commerce Manager (ECM) error notifications
     Items approaching inventory reorder points
     Inventory transaction notifications
5.   The Lotus Notes Messaging solution does require a  version of Lotus
Notes
loaded on a PC Server.
6.   It utilizes Lotus Domino (a widely used development environment)
     Which you do not need a license for.  If you do, you may be able to
further
customize this solution to meet your business needs.


The business benefits of this solution are:
1.   Users are notified of business conditions automatically (they don't
have to
remember to run a report or read it).
     Which allows them to react quickly to key business events or
situations.
2.   It allows customized messages.  A different messages can be sent to
different users when the same database condition is discovered.
3.   The solution is easily deployed centrally or decentralized

If anyone has a desire to discuss this solution in more detail, please do
not
hesitate to contact me (my phone number is listed below) or your Account
Manager.  We will be happy to discuss it with you in more detail and if
sufficient interest exists, put you in contact with our developers at the
GDC in
Toronto.  There we can discuss your specific business issues, formulate a
solution plan, and provide an estimate for the solution plan.

Thank you and I hope you find this information beneficial.

Sincerely,
Bob Benton



+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---