Los Angeles Mission College

1. Los Angeles Mission College Assets Tracking Administrative Services Sr. Accountant Jerry Huang January, 2010

3. Click on the “+” sign in front of “Asset Management Reports” Double click on Assets Information and you will see a screen like the one shown in next slide

4. Always type 1 in this field Always type 100000000 in this Asset field Fill in the information, Business Area, Fund, Fund Center and Fiscal Year etc. If you leave every field blank, The system will give you every asset in the assets database of the district

5. Now assume I want to see assets in funds between 10400 and 10499 at Mission College as of 2010 After filling out all data, click on the execute clock and system will retrieve an asset report like the one shown in next slide

6. This screen shows data of each asset. The inventory number is LACCD tag number. Scroll to the right and you can see the program # used to purchase this asset.. See next slide

7. This is the fund # that used to buy the asset. You can see the fund #s are all mixed up and not in order We can group the fund # together in order to see better. See next slide

8. First click on the column heading “Fund” and highlight the column Then, click on the ascending or descending icon and you will see the screen looks like the one in next slide ( Descending order )

9. The fund #s shown here are in descending order Assume you want to see funds from 10454 to 10491 except 10491. You click on the column heading “Fund” and click on the funnel icon, see next slide

10. After clicking this funnel icon, a small window will pop up, click for the next step. Fill out 10454 to 10491 and click this right hand arrow Click on the tab with red dot which is an exclusion and fill out the fund # that you want to exclude in your report After filling out everything, just click on the green checks and you will see a screen like the one in next slide

11. Assume that you wonder when did you purchase this item and want to see the actual P.O. You double click on the asset number in the row you want to see in detail. Click for next slide This report shows all assets purchased by fund 10454 to 10491 but no assets by 10490. click for next step

12. Once you are in this screen click on “Asset value”. Click for next slide

13. Double click on the date below purchase order

15. Los Angeles Mission College This concludes this session of training in Assets Tracking Administrative Services Sr. Accountant Jerry Huang January, 2010