Day End

Day end is a procedure that should be run daily to back up files to a tape, update aging, reorganize files and report daily sales and cash. There are additional reports that run during Day End. Click here to see a list of all Day End Reports. This procedure can be run immediately or scheduled to run at a time when there are no users on the system (to back up data).

If you are NOT using a different back up procedure, you should run a Day End with a backup through i-Pak (this is set in the Systems Control Master in the Company Master). e-Pak customers  - a back up is automatically done by Soft-Pak every night.

 

How to Run

From the System Tasks menu select the DAY-END Processing option in the Day End/Month End section. The Day End Processing Options screen will be displayed.

day_end_select.jpg

Fill in the screen with your selections by clicking in the box to answer Yes, leave box empty to answer No

File Reorganization

Do you want to reorganize files

 Do you want the files to be reorganized?  This is a basic file clean up option that assists in improving response time.  Soft-Pak suggests you do this once a month.

Days since last reorganization

 This is a display only field - telling the number of days since the last file reorganization was done.

Run in Dedicated Mode

 Do you want to run the Day End in dedicated mode (no users on the system)?  You should say Yes to this at least one time a week so all updates can be performed.

Batch / Interactive Mode

Run Day End in Batch

 Do you want to run the Day End procedure in batch so that the computer used to submit the Day End can be used for other functions?  Soft-Pak suggests that  you always answer this as Yes.

 

Click or press to accept and continue, the schedule time screen will be displayed.

 

day_end_select_pg2.jpg

 

Instructions

Start time

 If you want to schedule Day end to run at a later time, enter the time here (in military time).  If you want to run Day End immediately, leave the time blank.

Should Day End wait for all TP jobs to finish

 We suggest you say Yes to wait until the Transaction Processor jobs are complete before running Day End.  If you say Yes, Day End will automatically be submitted to run after the last TP job is completed.

System status

 This field tells how many users are signed onto this dataset at the current time.  If running Day End in dedicated mode, these users will be given a message to sign off.  If they don't sign off within 3 minutes, then their sessions will be ended so Day End can continue.  Go to the System Administration menu, option # 44 to see any users that are signed on.  This field also tells if i-Pak is Stopped (in dedicated mode) or not.  

Transaction Processor Status

Batch Counts

 Displays the status of Batches in the Transaction Processor.

 

Enter your selections and click or press . The system will prompt you to confirm your selections and continue: . Click or press to accept and continue with Day End processing.

 

What Exactly Does Day End Do?

Day End performs many functions in addition to printing ‘daily’ type reports. Listed below are the ‘steps’ or procedures that Day End performs.

When Day End is ready to start, the system will send a message to any User currently signed on:

  1. Updates a flag to indicate Day End or Month End has begun. Should an abnormal end occur, this flag helps Soft-Pak determine where in the procedure it ended.

  2. Clears the Transaction Processor Screen.

  3. Backup procedure is run (including a tape initialization) - Saves All i-Pak Data Set files ONLY. (This is controlled in the Company Master file-Systems Control Master-System tab-Back up Media option.)

  4. Populates the Landfill Reconciliation file (LFRC) with any new SALE records that haven't been uploaded yet.

  5. Performs all scheduled Prorations and deletes any canceled Bins/Containers from the Services tab as well as any vacation prorations that have reached their To date.

  6. Updates aging for NON Balance Forward (Open Item O/I and Summary Invoices O/S) customers.

  7. Creates Daily Sales GL entries if you have that option turned on.

  8. Removes any Start or Stop Action codes if the number of effective days has been reached.

  9. Changes or Deletes any Notepad Codes based on the notepad master.

  10. Creates Interactive C/R GL entries.

  11. Prints Charges Processed-Prorations Report – (TRANLIST)

  12. Runs 1st custom Day End procedure if one exists (CSTEOD1). This may be a custom procedure Soft-Pak wrote for your company, or query reports that you set up to run. Call Support Services for information.

  13. Updates the Collection Status fields if a payment was made.

  14. Updates the Collector Calling file with Current $'s.

  15. Prints Daily Cash Receipts Summary Report (LSTCSHP) & Deletes the daily cash file (CASD).

  16. Prints Daily Deposits Summary Report (LSTDEPP) & Deletes the daily deposits file (DEPD).

  17. Prints Daily Deposit Refunds Report (LSTREFP) & Deletes the daily refund file (REFD).

  18. Moves Effective Quotes into customer service from Sales Management.

  19. Recalculates Bin Average Weights

  20. Prints the Daily Sales Report (ARW544P) and deletes the daily sales file (SALD).

  21. Updates the Customer Financial Information for Daily Sales in the CFIN file.

  22. Updates B/F Sales records as paid based on payments applied that day which are held in the unapplied bucket.

  23. Updates National Accounts Variable fields with new aging if your system has this option turned on.

  24. Prints the Credit Limit Exception Report (CRDLMTP).

  25. Removes the active Work Orders Status (Red Work Order tab) on the Customer Profile screen if all work orders are ‘posted’.

  26. Renumber all Bins/Containers on the Services tab (if set to do so in the Company Master-Systems Control Record).

  27. Rebuilds the Open Invoice total file (INVT).

  28. Reorganize Files (removes deleted records) – assists in providing a more efficient response time.

  29. Performs Scale-Pak Daily Processing if turned on.

  30. Prints Charge Card Log report if Credit Card Module is turned on (AC0020P).

  31. Performs Webpak updates.

  32. Applies Unapplied $'s for O/I and O/S if the option is turned on.

  33. Applies Credit $'s for O/I and O/S if the option is turned on.

  34. Runs Veh Mgmt Day End if active.

  35. Performs Accounting Interface updates if any are active.

  36. Updates files used for Dash-Pak and/or Graph-Pak.

  37. Runs 2nd custom Day End procedure if one exists (CSTEOD2).

  38. Performs a ‘PURGE’ if scheduled. The system will perform a separate back up from the one in step 3, and will prompt for a new tape.

  39. Does a File Reorg if requested on the Day End selection screen.

  40. Performs any global updates that have been scheduled to run.

  41. Releases any ‘locked’ customers or work orders.

  42. Prints Locked Customers/Locked Work Orders Released Report (ARWRELP).

  43. Clears any locked files from the day.

  44. Updates flag that Day End was completed.

  45. End of Process.