Assetsmanagement/Advanced Asset Management/Depreciation And Subsidies

1. Changes in Asset Sub-Tab
   1. Usable Life-Years: remove
   2. Usable Life-Months: show (it exists but hidden), and rename it to Economic Lifetime.
   3. Depreciation Amount: rename to Depreciation Basis.
   4. Cancelled Date: rename to Date of Disposal.
   5. Residual value: rename to Scrap Value.
   6. Annual Depreciation %: show it (it's hidden now).
   7. new field!-> Change of Depreciation Amount (yes/no flag).
   8. Asset no field is not editable
   9. Associate the button "Create Amortization" to process AAM_DEPRECIATION_PLAN
   10. Add a read-only logic to all fields (in except of Depreciation Range Changed) if there exists one or more rows in AAM_DEPRECIATIONLINE table belonging to that asset. An especial case is the Economic Lifetime buttom that will also be shown if Depreciation Range Changed flag is active.
   11. Add a new button at the bottom of the tab that says "Void depreciation plan". Display logic for this button is: show if there exists one or more rows in AAM_DEPRECIATIONLINE table for the asset, and none of them has Processed='Y'. This process will delete all rows in AAM_DEPRECIATIONLINE for that asset (and AAM_DEPRECIATION also, if there is not any other AAM_DEPRECIATIONLINE row belonging to that AAM_DEPRECIATION row).
   12. Add a new button at the bottom that says Re-calculate depreciation plan. This process will remove all non-processed AAM_DEPRECIATIONLINE elements for this asset, and launch again the AAM_DEPRECIATION_PLAN process
2. Changes to subsidy WINDOW (at Financial Management || Advanced Assets || Subsidy)
   1. Add field Subsidy ID (textbox 512 characters long). Make sure the field name is subsidy id, but the column name in database do not end in ID. Use the name subsidy_identifier).
   2. Check that the subsidy id value is unique for each client (adding a unique constraint on the table for the values ad_client_id and subsidy_identifier)
3. Changes to subsidy sub-tab
   1. Two different fields (Subsidy entity and Subsidy ID) are showing same value (Subsidy Entity). Once Subsidy id field is created in previous step, make field in this tab show that value, and remove the subsidy entity field.
   2. Check that just percentage or value ar provided, but not both. Calculate the other one based on the information at subsidy window.
   3. Check that no more than total amount (or 100%) of the subsidy has been assigned to any of the available assets.
   4. Add a sub-tab under subsidy sub-tab that says "Subsidy Amortization Plan". In this tab, show for the asset in the asset sub-tab, all the rows in AAM_AMORTIZATIONLINE with that AAM_ASSET_ID, and with isSubsidy flag ='Y'.
4. Changes to AAM_DEPRECIATION_PLAN DB method
   1. Check that scrap value in (0,1)
   2. Subsidies are processed:
      1. At the beginning of the PL, sum of amounts of subsidies for this asset are retrieved (select sum(current) into v_TotalSubsidyAmount from aam_asset_subsidy where aam_asset_id=?)
      2. In each iteration where amortization lines are created, add a new insert in aam_amortizationline for v_TotalSubsidyAmount*v_Percentage/100, and set isSubsidy='Y'
5. Changes to Amortization:
   1. Instead of view AAM_AMORTIZATION table, it must show AAM_AMORTIZATIONLINE table. Filter by AAM_ASSET_ID, so it shows just amortization lines for that header.
   2. Remove from AAM_AMORTIZATION table the columns line, seqno, percentage, amount and aam_asset_id.
   3. Add a isSubsidy column to AAM_AMORTIZATIONLINE table (yes/no field with default value ='N').
   4. Show in depreciation sub-tab just those rows where isSubsidy='N'
6. Other changes:
   1. Create a new window called Depreciation for AAM_AMORTIZATION (main tab) and AAM_AMORTIZATIONLINE (sub-tab called Depreciation Line), located at Financial Management || Advanced Assets
   2. Rename Depreciation Method window to Depreciation Plan, and show Value field (only modificable when a new record is created) in the three tabs.
   3. Merge both triggers for AAM_ASSET_SUBSIDY table in one only trigger, and add this functionality: populate automatically method, type and timing according to the values present in the asset sub-tab.
   4. Merge three triggers for AAM_ASSET table into one only trigger.
   5. Merge three triggers for AAM_INVENTORY table into one only trigger.
   6. Check that current AAM_DEPRECIATION_PLAN PL/SQL acts as defined in the Rounding depreciation rules section of the functional specs
   7. Check that none of the values in the asset class window is modified if there exists one or more depreciation lines for any asset belonging to that asset class.