Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Example: A teacher is paid through a grant. This grant allows pay for the teacher's salary. When a sick day is taken it will be charged to the sick leave account which corresponds to the salary account. This would not be correct as the grant should not have leave charged to it. Account mapping could be used in this case to charge all leave against the regular teacher's salary account.

Field Definitions

  • To add additional lines, click on Insert.

  • In the Order field enter The Order Image Addedoption is the number in which the information should be entered and processed. When assigning order numbers, it is important to assign the more detailed accounts with lower order numbers (e.g. 1, 2, 3 ...) and the less detailed accounts a higher order number. Once an account matches a line of mapping, the account can not be charged again.
  • On the left side, the Original Account field, enter the original account number. The account code may be entered using wildcards. The % symbol represents a single digit while the * represents multiple digits. For example, to specify all SCC's beginning with 90 and ending with 0, the SCC would be entered as 90%0. To specify all Functions ending with 30, enter the Function code as *30. Any account code dimensions that are left blank on the "map into account" portion of the screen will be filled with the value of that same dimension from the original account.
  • On the right side, or the Mapped Account field, enter the account number to be charged. The account code may be entered using wildcards. The % symbol represents a single digit while the * represents multiple digits. For example, to specify all SCC's beginning with 90 and ending with 0, the SCC would be entered as 90%0. To specify all Functions ending with 30, enter the Function code as *30. Any account code dimensions that are left blank on the "map into account" portion of the screen will be filled with the value of that same dimension from the original account.

    Make sure it specifically states that NOTE** spaces are treated the same as "*" wildcards.  Ensure that account codes with spaces on the left-hand side are matched with spaces. For instance, an account with a function code of " " should match all functions and act the same way as if they had entered an "*" for that field**.  Any account code dimensions that are left blank on the "map into account" portion of the screen will be filled with the value of that same dimension from the original account.


Account Mapping is used to 'reroute' accounts that board amounts are being distributed to

...

Mapping lines are not changed by USAS programs ACTCHG Account Change or FNDCHG Fund Change 

Implementation of mapping

...

  1. From the Utilities menu select Account Mapping
  2. Click on 
  3. Enter in the Original Account and the Mapped Account too
  4. Click on 'Save'

Image RemovedImage Added

Edit Mapping Account Entry

  1. Select Account Mapping 
  2. Go to Account that needs changing and enter in new Mapping Account number
  3. Click on 'Save'

Image RemovedImage Added

Delete Mapping Account Entries

...

  1. Click on the 'Remove  option next to the desired account. 

...

  1. Click on 'Save'

Image Added

To 'Reorder' the sequence of the mapping accounts

  1. Click on the  option option at the end of the account row.  Click and Drag to the new order line and click .
  2. Click on 'Save'

Image Removed

Image Removed

 

 Image Added

Image Added