RE: Month End 920 and 903

My fax number is 610-341-7919.  Would appreciate a copy of your month end
stuff.  THANKS!

        -----Original Message-----
        From:   Lacelle, Marc [SMTP:LACELLE@rcmint.ca]
        Sent:   Friday, February 04, 2000 10:52 AM
        To:     'bpcs-l@midrange.com'
        Subject:        Month End 920 and 903

        Hi Ho

                Been rather busy for the last few days. Sorry for the delay
in
        response time.

        Break time: What does a fish say when he hits a cement wall "Dam"

                Back to business

        Many things have been said on this subject. 

                Users signed on when job running
                Client Server
                Reorg Programs
                SSA 

        1. Users signed on when INV903,INV920 running
                SSA advised of 14 files to verify when month end run. BAD
NEWS, what
        about ZPA, HPC,         ZXU, ZMA, ZSC and so on.
                You can't rely on the 14 files they gave you. What if a user
is
        signed on to BPCS but sitting   on a main menu. You submit month end
process
        and this user decides to post transactions      using INV500. Month
end
        dies. 
                
                How to Fix. WRKOBJLCK OBJ(BPCSXXXF/ZSC) OBJTYPE(*FILE)  
                        
                The ZSC file is the Security Master File, all users logged
on to
        BPCS use this file. If you      need to know who is on BPCS use the
ZSC
        file.

                Client Server: No problem use the ZQWS or the ZQWR file to
find out
        who is on the Client    side.

        2. Reorg Programs.
                                        
                IN THIS ORDER

                INV970 the most destructive program ever written by SSA.
Only run
        this after month end. I have deleted this program and written an SQL
to
        replace it. (Users can't run SQL statements)
                INV972  
                INV973
                SFC990
                ORD990
                INV971
                SYS990
                SYS994
                MRP990
                SFC971
                ACR970

        3. Automated Month End
                When I respond to automated month ends, I though you were
talking
        about INV903. I replied         that I had an Asset program and CL's
to
        submit INV920. Sorry I don't. We don't run INV920
here. I felt
        bad so I wrote a program this morning. Works like a charm.  

        4. Month End taking 18-20hrs
                So sorry
                It's either the size of your AS/400 or Data related. 

        For those interested in my Asset program and CL's that submit month
end and
        reorgs forward me your fax numbers.  
          
                
         

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