Proration Utility

This document is an example checklist of how a user could use it to assist in calculating premium amounts for Worker's Compensation payments and posting them as Purchase Order to the system. 

Running this utility requires an account filter to be selected. Account filters should be created prior to running the utility via the Account Filters page. Account Code Mapping may be desired. The Account Code Mappings should be pre-configured on the Account Code Mapping grid to appear in the drop down. (ex. Can be used to map salary account codes to benefit account codes)

This checklist assumes an Account Filter, BWC, was created containing all 1xx object codes and an Account Code Mapping was created, bwc. 

Any changes needed to the account filter or account code mapping must be done before running the program and creating the PO CSV. Both Account Filters and Account Code Mapping are found under the Utilities Menu.

  1. Go to Utilities/Proration Utility
  2. Update the screen:
    1. Time Period: select your time frame
    2. Account Filter should be set to BWC
    3. Enter a File Name: (i.e. March BWC Payment)

  3. Click on Create

  4. Enter the Proration Amount in Cell B1 and hit enter 

  5. Click on Create PO CSV
    1. File Name: March BWC Purchase Order
    2. Account mapping: bwc
    3. Purchase Order #: enter desired PO # or let it auto assign
    4. Vendor: choose vendor  #/name in USAS 
    5. Purchase Order Date
    6. Click on download

  6. Go to Transaction/Purchase Orders
  7. Click on Import
  8. Click on Choose File - to find your CSV file that was created above
  9. Click on Load

  10. If it is error free continue on with the expenditure process of invoicing and posting payables. If errors are encountered, update as needed and start again at the beginning.