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

  • InsertImage Added

  • In the Order field enter 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 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. Previously, it was never matching anything for a blank account dimension.


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

...

  • Object code has already been changed to 2XX code for board benefit before it gets to read the “from” account mapping entries

Account on right is “to” account

  • Final account used for distribution

Adding mapping lines

Use modify, enter number one less where you want the entry inserted

For example:

      • If you want to add a new order 14, enter as order 13
      • Think of it as add after 13

Delete mapping lines

  • Space over order number

...

Implementation of mapping

  • First see what BRDDIS/BRDRET Employer Distributions/Employer Retirement Share are doing with accounts before mapping

...

  • Add mapping lines to accomplish what districts want
  • Rerun BRDDIS/BRDRET Employer Distributions/Employer Retirement Share

Create a Mapping Account Entry

...