Business

User Tools

Site Tools

Trace: • Enter Records in Asset Management • Mass Delete Zero Balance Accounts - BUD7400 • Verify Extract Reports tab • Create New Accounts by Fund - FIN6100 • Reverse PO by Fund - REQ6300
general:assetmanagementsummary_quickchecklist

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
general:assetmanagementsummary_quickchecklist [2022/02/21 21:46] – emorenogeneral:assetmanagementsummary_quickchecklist [2022/02/22 16:54] (current) – emoreno
Line 4: Line 4:
 </WRAP> </WRAP>
  
-ASSET RECORD MAINTENANCE  (done throughout the year) +===== Asset Record Maintenance (done throughout the year) =====
-FINANCE MODULE +
  
-|VCV|Ensure all Object/SubObject codes are present in the Asset Management Cross-Reference Table| +==== Finance ==== 
-|VCV|Execute Extract utility: 1) print PDF report and 2) save to file, recording filename for future step:Finance Module Extract Filename|+ 
  
-ASSET MANAGEMENT MODULE  +|VCV|Verify the necessary object/subobject codes exist in the Asset Management Cross-Reference table.| 
 +|VCV| Run the Extract to Asset Management utility to extract data from Finance to Asset Management.<div indent>Print the PDF report.\\  Save the file and record the file name as it is needed it in a later step.\\  Finance Module Extract File Name:       </div>|
  
 +====Asset Management====
  
-|VCV| Verify that “Automatic Item Numbering” is checked if this option is desired| +<WRAP center round alert> 
-|VCV|Import any Asset items from the Finance Module using the Filename recorded above and manually enter any other Asset items you wish to add|  +**CAUTION**: Prior to initiating end-of-year procedures, use the Asset Management > Utilities > Export by File ID page to perform an export of all current year data. Do not proceed until a valid export of all current year data exists. 
-|VCV|Optional:  Run and distribute the Campus Room Inventory Report for hand notations\\  \\  Update any Asset items in the database with changes from the Inventory Report\\  \\  Do a Mass Update of the “Last Inventory Date”| +</WRAP>
  
-DEPRECIATION CALCULATION AND EOY REPORTS 
-ASSET MANAGEMENT MODULE 
  
  
-|VCV|Run Report : Status Report to show any Asset items Entered in Error, for Sold, or Deleted|  +|VCV| (Optional) Verify that **Automatic Item Numbering** is selected.| 
-|VCV|Ensure required information for the sale of any Capital Assets is entered| +|VCV|Import asset items using the file that you previously created in Finance on the Extract to Asset Management pages. Or, manually add asset items as needed.|  
-|VCV|Run Reports : Capital Assets/Inventory Listing, Auditor Analysis and Property Class Listing|  +|VCV|(Optional) Generate and distribute the Campus Room Inventory Report.<div indent>Use the report to track and update asset changes in the system.\\  Perform a Mass Update to update the **Last Inventory Date** on the Inventory Records tab.</div>| 
-|VCV|Verify the data and balances in the Reports; Totals should match|  +
-|VCV|If Report totals match, perform the Depreciation Calculations| +
-|VCV|Run Report: Depreciation Detail Schedule if desired or required by Auditor|+
  
-PREPARE DATABASE FOR NEW YEAR PROCESSING + 
-ASSET MANAGEMENT MODULE +=====Depreciation Calculations and EOY Reports===== 
-|VCV|Verify the current fiscal year 2015 and the next fiscal year 2016 are listed in the FY Table| + 
-|VCV|Copy Current FileID (C) into new FileID for history; ensure you are in FileID (C) for following:| +====Asset Management==== 
-|VCV|Rollover the Depreciation Distibution Funds | + 
-|VCV|Perform a Mass Delete of all Asset Items that have status of Entered in Error, Deleted, or Sold| + 
-|VCV|After the Auditor has completed their review, perform the Initialize Audit Tables process | +|VCV|Generate the BAM1050 - Status Report to review any asset items that were sold, deleted, or entered in error.|  
-|VCV|Do an Export  by FileID (C) to have a clean backup of the beginning new year database; give            meaningful filename and record for future reference if needed: Export Asset Management Tables Filename:  i.e. “Export FileID(C) Beginning Year 21-22”  |  +|VCV|Verify that the required information is entered for the sale of any Capital Assets.| 
 +|VCV|Generate the following reports: <div indent>BAM1100 - Auditor Analysis Report\\  BAM1150 - Capital Assets/Inventory Listing\\  BAM1650 - Property Class Listing Reports</div>|  
 +|VCV|Verify the data and balances on the reports. The totals should match.|  
 +|VCV|If report totals match, perform the Depreciation Calculations.| 
 +|VCV|If requested by auditor, generate the Depreciation Detail Schedule report.| 
 + 
 + 
 + 
 +=====Prepare for New Year Processing===== 
 + 
 +====Asset Management==== 
 + 
 + 
 +|VCV|Verify the current and next fiscal years exist in the fiscal year table.| 
 +|VCV|Copy the current file ID (C) to a new file ID for historical purposes. | 
 + 
 +<WRAP center round important> 
 +Verify that you are in file ID C before completing the following steps. 
 +</WRAP> 
 + 
 +|VCV|Roll over depreciation distribution funds. | 
 +|VCV|Perform a Mass Delete of all asset items that have been deleted, sold, or entered in error. | 
 +|VCV|After the auditor has completed their review, run the Initialize Audit Tables utility. | 
 +|VCV|Create an export of file ID C for a clean backup of the beginning new year database. Save the file and record the file name for future reference if needed (e.g., Export File ID (C) Beginning Year XX-XX.|   
 + 
 +<WRAP center round info > 
 +After completing the above steps, you are now ready to begin the new fiscal year for Asset Management. 
 +</WRAP> 
 + 
  
general/assetmanagementsummary_quickchecklist.1645480000.txt.gz · Last modified: 2022/02/21 16:46 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.