Re: Required fields

Jenni: Not the silver bullet here, but some less-invasive ideas for you:
     Use your Configurable User Interface to redesign the client screen to
     make this field more obvious to the user that is expecting data (i.e.
     make it the first field in the tab sequence)
     You may be able to use a combination of Oracle trigger and integration
     with e-mail to trigger the exception condition (i.e. no data) to the
     appropriate person and provide a database utility program to add it in
     after the fact.  I can refer you to one of our clients who is doing
     things like this.

Mike Hoffman
Senior Manufacturing Specialist
Crowe, Chizek & Company, LLP
http://www.crowechizek.com/scg/
phone: 440.460.1318
fax:       440.460.1302



                                                                                
                                     
                    jjpfantz@lozier                                             
                                     
                    .com                   To:     BPCS-L@midrange.com          
                                     
                    Sent by:               cc:     dslic@aol.com                
                                     
                    owner-bpcs-l@mi        Subject:     Required fields         
                                     
                    drange.com                                                  
                                     
                                                                                
                                     
                                                                                
                                     
                    09/06/2000                                                  
                                     
                    06:41 PM                                                    
                                     
                    Please respond                                              
                                     
                    to BPCS-L                                                   
                                     
                                                                                
                                     
                                                                                
                                     



We are on BPCS 6.0.04 Full Client / Server in a HP / UNIX environment.

Is there any way to make a field in A/P Invoice Entry a required field?  We
are interested in using the Reference field to analyze some purchases being
made, but the information does not reside in BPCS.  The A/P Coordinator
needs to enter the information as he/she keys the invoice, but, without the
system requiring an entry in that field, we run the risk of less than 100%
compliance.  We don't need it to be validated against anything; we just
need
to have an entry in that field.  If for some reason a purchase does not
have
this type of information available, the Coordinator will probably enter a 0
or some other character that will indicate it is not applicable.

If anyone has any information on whether this is possible, I would
appreciate your comments.

Thank you!
Jenni Pfantz
jjpfantz@lozier.com
(402)     457-3186
+---
| 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
+---



+---
| 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
+---