RE: BPCS Month-end close processes

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.  


> ----------
> From:         Wayne.Sheehan@powerbar.com[SMTP:Wayne.Sheehan@powerbar.com]
> Reply To:     BPCS-L@midrange.com
> Sent:         Thursday, February 03, 2000 10:53 AM
> To:   BPCS-L@midrange.com
> Cc:   Jeffrey.Morris@powerbar.com; buug@mitylite.com
> Subject:      RE: BPCS Month-end close processes
> 
> 
> 
> 
> We are currently running the following BPCS month end jobs with the total
> elapsed time for all these job of approximately 18 - 20 hrs. The list is
> as
> follows:
> 
>    Inventory Month End Close (INV903)
>    Accounts Receivable Period Close (ACR900)
>    Accounts Payable Month-End Close (ACP900)
>    Purchasing Month-End Close (PUR900)
>    Lot, Location, Container Records without Inventory (INV970)
>    Update IIM from ILI file (INV972)
>    Cleanup FMA and FOD files (SFC990)
>    Cleanup ECL and ECS files (ORD990)
>    Cleanup Allocations (SYS990)
>    Reset On Order Allocated (INV971)
>    Delete IWI Records (INV973)
>    Reorganize Notes Files (SYS994)
> 
> Since our fiscal month-end is the same as the calendar month-end and this
> sometimes falls outside of the weekend, the total processing time affects
> system
> availability. Has anyone tried or been successful with running any of
> these jobs
> simultaneously. We are planning on running some tests this month and
> welcome any
> input from others that might have already tried this.
> 
> Regards,
> Wayne Sheehan
> 
> 
> +---
> | 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
+---