Difference between revisions of "Information Systems:IBM i Periodic Administrative Tasks"

From uniWIKI
Jump to navigation Jump to search
Line 103: Line 103:
 
YEAR END 043016
 
YEAR END 043016
 
 
==Make Sure Opening Balances for Analyser are Correct==
+
==Make Sure Opening Balances for Analyser are Correct==

Revision as of 09:20, 15 October 2015

Month

Calendar Year

Set up Courier Schedule for the Year

From the warehouse manager, get the list of days that the warehouse will not be open. Enter these days into file ATLDATEP. Program PLZIU511 (PLZ -- build shipment file for Atlas) will not run if the current date is in this file.

whse menu / configuration / stat holidays no pickups

Change Transmission Times When Friday is a Statutory Holiday

Atlas does a late pickup on Fridays, to take to their depot, and distribute to the drivers on Saturday morning (for Saturday delivery). If the warehouse is closed on Friday, this late pickup will have to be done on Thursday. Which means we will have to do a late transmission as well.

We cannot change the transmission schedule ahead of time, so put reminders in your calendar.

Key in the command WRKJOBSCDE and press enter.

                        Work with Job Schedule Entries                BART     
                                                            10/14/15  16:53:30 
                                                                               
 Type options, press Enter.                                                     
  2=Change   3=Hold   4=Remove   5=Display details   6=Release                 
  8=Work with last submission    10=Submit immediately                         
                                                                               
                                                                   Next        
                         -----Schedule------             Recovery  Submit      
Opt  Job         Status  Date       Time      Frequency   Action   Date        
_    ATLAS01      SCD    USER DEF   06:15:00  *WEEKLY    *NOSBM    10/15/15    
_    ATLAS02      SCD    USER DEF   13:15:00  *WEEKLY    *NOSBM    10/15/15    
_    ATLAS03      SCD    USER DEF   13:35:00  *WEEKLY    *NOSBM    10/15/15    
2    ATLAS04      SCD    *FRI       19:15:00  *WEEKLY    *NOSBM    10/16/15    
_    DHLINV       SCD    USER DEF   22:00:00  *WEEKLY    *NOSBM    10/14/15    
_    ECUREGULAR   SCD    *THU       21:30:00  *WEEKLY    *NOSBM    10/15/15    
_    EDI_PO       SCD    *ALL       07:00:00  *WEEKLY    *SBMRLS   10/15/15    
                                                                       More... 
Parameters or command                                                          
===>                                                                           
F3=Exit   F4=Prompt          F5=Refresh   F6=Add    F9=Retrieve                
F11=Display job queue data   F12=Cancel   F17=Top   F18=Bottom                 
                                                                               

Use option 2 to change job ATLAS04.

                    Change Job Schedule Entry (CHGJOBSCDE)                     
                                                                               
Type choices, press Enter.                                                     
                                                                               
Job name . . . . . . . . . . . . > ATLAS04       Name                          
Entry number . . . . . . . . . . > 309408        000001-999999, *ONLY          
Command to run . . . . . . . . .   CALL PGM(PLCIU511) PARM('AM')               
                                                                                
Frequency  . . . . . . . . . . .   *WEEKLY       *SAME, *ONCE, *WEEKLY...      
Schedule date  . . . . . . . . .   *NONE         Date, *SAME, *CURRENT...      
Schedule day . . . . . . . . . .   *FRI          *SAME, *NONE, *ALL, *MON...   
               + for more values                                               
Schedule time  . . . . . . . . .   '19:15:00'    Time, *SAME, *CURRENT         
                                                                                 
F3=Exit   F4=Prompt   F5=Refresh   F10=Additional parameters   F12=Cancel      
F13=How to use this display        F24=More keys                               
                                                                               

Change the schedule day from *FRI to *THU, and press enter. Don't forget the change this back for the following week.

Copy of Warehouse Balance File

When program EOMASW runs on January first for December, it creates a copy of SROSRO, and names it SROSROyyyy where yyyy is the calendar year just ending. It also builds the logical file SRBSROyyyy. This allows us to run reports for the auditors.

Confirm that this has been done.


Fiscal Year

Correct Last Day of February

ASW does not handle leap year when setting period end dates - it simply adds one to the year. This means that February 29th is not in any fiscal period, and the system does not know how to deal with it.

At the beginning of a leap year, we must manually change February 28 to 29. Then, the year following, we must change it back.

The G/L Control File can only be changed by a user profile connected to the group profile ASW4ADM. An ASW administrator can change tables that affect the way ASW functions. They can also update an out of balance journal that would put the G/L out of balance - so use it with care!.

Sign on as user FINADMIN with our favorite password.

Key ASW and press enter.

Key GO GLSET and press enter.

Select option 2 Work with G/L control file, and correct the last day in February.

*VA/480B*  G/L control file maintenance             10/15/15 09:16:16 GDMD0911 
-------------------------------------------------------------------------------
                                       Period name          End date           
Actual year/period.. 1609              FEBRUARY             022815             
                                       MARCH                033115             
Last closed period.. 1607              APRIL                043015             
First stored period. 0812              MAY                  053115             
                                       JUNE                 063015             
                                       JULY                 073115             
                                       AUGUST               083115             
                                       SEPTEMBER            093015             
                                       OCTOBER              103115             
                                       NOVEMBER             113015             
No of normal periods 12                DECEMBER             123115             
Total no of periods. 13                JANUARY              013116             
                                       YEAR END             043016             
                                                                               

Make Sure Opening Balances for Analyser are Correct