Tuesday, August 25, 2009

Oracle Assets - Business Scenarios for CRP's

ADDITIONS :
Create Mass Addition via EPI AP (eg: Computer Equipment, vehicle, land, Office furniture)
Create Mass Addition via PA (EPI)
Create Mass Addition via ADI
Mass Addition (via PO with unit # greater than 1)
Mass Addition (via PO with item #)
Create Mass addition : Split a single invoice line to multiple assets
Create Mass Addition : Merge different invoice line to one asset
Create Mass Addition : Add to existing asset
Update mass addition information : serial number, tag number
Create Assets (post mass addition)
Add assets to subledger in detail
Add assets to subledger with quick addition
Additions of monthly Service Units and Metres (length of Services line) -

New units and metres
Relay units and metres
Adding Inactive Service record

ADJUSTMENT
Update descriptive information (eg description, serial number, model number, manufacturing number)
Updating quantity and costs for Mass Property accounts through AP.
Updating quantity for Mass Property accounts through other interfaces
Process adjustments to prior year asset costs
- asset-detail accounts e.g 472
- mass property accounts units and amount e.g. 475
Adjust NBV and accumulated depreciation

TRANSFER :
Transfer assets between LOB
Transfer assets between FA Book
Transfer assets between Employee
Transfer assets between Location
Mass Transfer between LOB
Mass Transfer between Employee
Mass Transfer between Location

RECLASSIFICATION
Reclassification (category)


RETIREMENT
Retirement on single asset (by cost)
Retirement on single asset with vintage pool
Retirement on single asset (by unit)
Mass Retirement by date place in service /vintage year
Mass Retirement by location
Mass Retirement by category
Mass Retirement from spreadsheet (ECG)
Mass Retirement by asset number
Retirement reversal of a single asset by cost
Retirement reversal of a mass property asset by units.
e.g: 475
Asset-detail partial retirement
FIFO retirement of mass property account
Mass retirement of asset-detail
- retire small tools and work equipment over 15 years
Retiring Inactive Service record

DEPRECIATION
Monthend closing – Depreciation Run
Change Depreciation rate
Review catch up depreciation calculation
Run/review journal entry reserve report
Add multiple depreciation rates
- 3 decimal places
Amortization of lease-hold account and computer software assets
Perform back-dated depreciation


PROCESS JOURNAL ENTRIES
Generate GL journal entries
Review Asset Addition JE, Transfer JE, Adjustment JE, Retirement JE, Depreciation JE

REVALUATION
Set up revaluation book
Run Revaluation (Midcoast/LPL)

INQUIRE ASSETS
Inquire assets based on category
Inquire assets based on location
Inquire assets based on employee
Inquire assets based on asset number
Inquire assets based on FA Book
Inquire assets based on historical project # (ie serial #)
Inquire assets based on storage tank unit # (ie. Manufacturer information)
Drill down to asset source detail
Cross referencing asset group
e.g. Land and building,
Calculate life-to-date, year-to-date and current month depreciation

YEAR END
Plant Asset year-end Allocations
Asset-detail Accounts:

1. allocate all miscellaneous costs within each
2. asset-detail account for current fiscal year.

Plant Asset year-end Allocations
Mass Property Asset Account Allocations

1. allocate all current year miscellaneous costs to current year installed service sizes within regions.
2. allocate all current year miscellaneous costs to current year installed main sizes within regions.
3. allocate all current year miscellaneous costs to current year installed sales stations within regions

Option: Use Project Accounting to handle the costs. (common cost)

6 comments:

dallas cpa said...

Managing your business financial procedure can be the most complicated part of running any business . Every business man wants his business to be the most successful, but it is very difficult to know where to begin. It is no matter how big your organization may be, Dallas CPA services guarantee you of all the accounting and financial services for your company.

Accountants in London said...

This is good site to spent time on .I just stumbled upon your informative blog and wanted to say that I have really enjoyed reading your very well written blog posts. I will be your frequent visitor, that's for sure.

Organic Supplements said...

I agree with you. This post is truly inspirational. I like your post and all you share with us is up to date and quite informative, i would like to bookmark the page so i can come here again to read you, as you have done a wonderful job……

Buy sildenafil said...

Thanks for sharing this great article! I feel strongly about it and love learning more on this topic. It is extremely helpful for me. I hope you post again soon

Natural Minerals said...

Interesting things to read about a variety of subjects, but I manage to include your blog among my reads every day because you have interesting

sap upgrade project said...

I don't have any idea about this topic so I can't say much about it. But I can say one thing that your post is very informative and surely enhance knowledge of your users. One can surely use this information for the benefit of business. Thanks for the post. Keep it up.