Projects:Asset Report Depreciation Schedule/Functional Specifications
Contents |
Functional Specification of Asset Report for Depreciation Schedule
Purpose
The Depreciation Schedule for Fixed Assets report is a new report which will show the depreciation schedule for a specific fixed asset by showing below information:
- Fixed asset name
- Asset Description
- Fiscal year
- Amortization start date
- Amortization end date
- Depreciation amount
- Currency
- Total Amount
The new asset report for depreciation schedule can be found on the application path as below.
Scope
The Asset Depreciation Schedule report is a new report which will help the end-user to get detailed information about the depreciation amount of a specific fixed asset for a specific period of time entered by the end-user.
The result of the report will be shown based on the filters applied by the end-user.
FOR EXAMPLE
If the end-user tries to get information about depreciation schedule report for a specific fixed asset, he/she should enter some value in the search key field or some value in the description field or select the other filters to get the information about the specific fixed asset he/she is looking for.
- SPECIFIC FIXED ASSET
- The report result can be shown to the end-user based on the filters chosen/selected by the end-user.
- For Example : If the end-user tries to get the asset report information by applying asset name, search key value and description as filter, then the result should be shown for specific fixed asset based on the asset name, search key value and asset description.
- The report result can be shown to the end-user based on the filters chosen/selected by the end-user.
The asset report has the output columns as listed below.
- FIXED ASSET NAME
- Displays the Asset name.
- ASSET DESCRIPTION
- Displays the Asset description
- AMORTIZATION START DATE
- Displays the "from date" when the end-user needs to get depreciation schedule information from for a specific fixed asset.
- AMORTIZATION END DATE
- Displays the "to date" when the end-user needs to get depreciation schedule information to for a specific fixed asset.
- DEPRECIATION AMOUNT
- Displays the depreciation amount of the asset for a specific period of time entered by the end-user.
- CURRENCY
- Displays the accounting schema currency from the organization in which the fixed asset was created.
- TOTAL AMOUNT
- Displays the total depreciation amount of the asset within a specific period of time entered by the end-user.
Setup
The Depreciation schedule asset report do not require any specific setup but to get Fixed Asset module setup and working as normal, therefore no specific configuration needs to be done.
Feature Behavior
In-order to work with this report, a few "filters" need to be entered/selected by the end user as showed below. It is important to note that none of them are mandatory but "Organization".
If the end-user selects/enters Organization as the only one filter entered, then result should show all the assets which belongs to that organization selected by the end-user which could be also filtered in case the end-user enter another not mandatory filter.
As said, the result of depreciation schedule asset report can be displayed to the end-user based on filters described below.
- FILTER PARAMETERS
- From Date [ Amortization start date ]
- Searches and displays report output based on the "From Date" entered by the user
- EXAMPLE
If the end-user selects/enters the only "From Date" and "To Date" as filters, then the report will show the result with all the asset information which meets the criteria ("from date" and "to date") selected by the end-user.
- To Date [ Amortization end date ]
- Searches and displays report output based on the "To Date" entered by the user.
- Asset Search value.
- Searches and displays report output based on the "Asset search" value entered by the user.
- EXAMPLE
If the end-user creates an asset with a search value as "green field" by example, then, when the end-user tries to generate this report he will enter that value in the "Asset search value" field as search filter.
- Asset Description
- Searches and displays report output based on the "Asset description" value entered by the user which should match the existing asset to be shown in the report.
- EXAMPLE
- If the end-user creates the asset with asset description value as "vehicle for pamplona office" then when the end-user tries to generate this report he will enter that value in the "Asset Description" field as filter.
- Asset Category
- Searches and displays report output based on the "Asset Category" selected by the user.
- EXAMPLE
If the end-user selects/enters the "Asset Category" as filter, then the result displays the data of all the asset belongs to the category selected by the end-user.
- Accounting Schema
- Searches and displays report output based on the "Accounting Schema" selected by the user which should match the accounting schema used to depreciate a given asset shown in the report
- EXAMPLE
- If the end-user selects/enters the "Accounting Schema" as filter, then the result displays the data of all the asset which belongs to accounting schema select by the end-user.
- Organization (Mandatory)
- Searches and displays report output based on the "Organization" selected by the user.
- From Date [ Amortization start date ]
It is important to understand that the Deprecation amount displayed on the report should be the amount which are posted on the below application path.
>> Financial Management >> Asset >> Amortization
Output Format
The Depreciation schedule fixed asset report should have two different output formats HTML and PDF.
Openbravo has some standard way for generating report as below
- SEARCH
- The Result of the report will be show (shown) on the sample page itself.
- HTML FORMAT
- Result of the report will be show on the separate page
- PDF FORMAT
- Result of the report will be shown on the separete page and let the user to save the output for PDF format.
In our case, we have "Search" and "PDF Format". So, When the user clicks on "Search" button, result will be shown on the same page under the "View Results" section on the same report page itself and Clicking on "PDF Format" button will popup the separate window and let the user to save the pdf version of report.
- HTML FORMAT
- There will be a button called "Search" available on the asset report, so the end-user can generate an html report which should be shown on the asset report page itself.
- PDF FORMAT
- There will be a button called "PDF Format" available on the asset report, so the end-user can generate a PDF version of the report.
Depreciation schedule fixed asset report content
The Output of the Asset Report of Depreciation schedule should contain fields below:
- FIXED ASSET NAME
- Displays the Asset name.
- ASSET DESCRIPTION
- Displays the Asset description
- AMORTIZATION START DATE
- Displays the "from date" when the end-user needs to get depreciation schedule information from for a specific fixed asset.
- AMORTIZATION END DATE
- Displays the "to date" when the end-user needs to get depreciation schedule information to for a specific fixed asset.
- DEPRECIATION AMOUNT
- Displays the depreciation amount of the asset for a specific period of time entered by the end-user.
- CURRENCY
- Displays the accounting schema currency from the organization in which the fixed asset was created.
- TOTAL AMOUNT
- Displays the total depreciation amount of the asset within a specific period of time entered by the end-user.
Use Case
The asset depreciation schedule report is a report which can be used by the end-user to get information about the depreciation scheduled for a giver asset/assets based on some filters (From date, To date, Asset Name, Asset search key value, Asset Description and so on) selected by the end-user.
To get information for depreciation schedule for specific fixed asset, below steps should be followed.
STEP 1 ( ASSET CREATION )
CREATION OF ASSET # 1
- End-user need to navigate to below "Application Path" to create the asset as shown on the image below.
- [ Financial Management || Assets || Assets || Assets ]
- Important information end-user has to take into account while creating an asset is shown below:
- Asset name = Super Computer
- Asset category= Machinery
- Asset search key = scomputer
- Asset description = Super Computer for research
- Annual depreciation % = 20.00
- Amortization start date= 01-07-2009
- Amortization end date= [ No need to select the "Amortization end date", because based on the "Annual Percentage" selected/entered by the end-user, the system will automatically calculate the "Amortization end date".]
- Depreciation amount = 1450000.00
- And residual asset value= 550000.00
[ The asset value is : 2.000.000 with a residual value of : 550000.00, so the total depreciation amount is 1450000.00 and the overall annual depreciation amount is 290000.00. ]
CREATION OF ASSET # 2
- End-user need to navigate to below "Application Path" to create the asset as shown on the image below.
- [ Financial Management || Assets || Assets || Assets ]
- Important information end-user has to take into account while creating an asset is shown below:
- Asset name = Desktop computer
- Asset category= Machinery
- Asset search key = dcomputer
- Asset description = Desktop computer for document printing
- Annual depreciation % = 50.00
- Amortization start date= 01-01-2010
- Amortization end date= [ No need to select the "Amortization end date", because based on the "Annual Percentage" selected/entered by the end-user, the system will automatically calculate the "Amortization end date".]
- Depreciation amount = 60000.00
- And residual asset value= 25000.00
[ The asset value is : 85000.00 with a residual value of : 25000.00, So the total depreciation amount is : 60000.00 and overall annual depreciation amount is : 30000.00 ]
CREATION OF ASSET # 3
- End-user need to navigate to below "Application Path" to create the asset as shown on the image below.
- [ Financial Management || Assets || Assets || Assets ]
- Important information end-user has to take into account while creating an asset is shown below:
- Asset name = Maruthi Suzuki Van
- Asset category= Vehicles
- Asset search key = delivery van
- Asset description = Van for product delivery
- Annual depreciation % = 33.33
- Amortization start date= 01-08-2009
- Amortization end date= [ No need to select the "Amortization end date", because based on the "Annual Percentage" selected/entered by the end-user, the system will automatically calculate the "Amortization end date".]
- Depreciation amount = 300000.00
- And residual asset value= 300000.00
[ The asset value is : 600000.00 with a residual value of : 300000.00, So the total depreciation amount is : 300000.00 and overall annual depreciation amount is : 99999.00 ]
STEP 2
- After the asset has been created the end user clicks the "Create Amortization" button and then click ok in the pop up window to generate the depreciation plan for the just created asset. He would need to check depreciation has been properly created by navigating to the "Asset Amortization" tab.
STEP 3
- After completion of "STEP 2", end-user can process and post the first depreciation line by navigating to [ Financial Management || Assets || Amortization ], once there he selects the correspondent line, process it and post it. After doing that the correspondent depreciation amount already posted will be shown in the column "Total amortization", in our example the amount must be 145.796,70 ( First line of amortization for Asset # 1 )
STEP 4
- The user can repeat step 1 to 3 for as many assets he/she needs to create. We will take into account that at least 3 new assets has to be created having in mind that 2 of them should belong to the same asset category and the 3rd one to a different one (category).
STEP 5
- To generate the asset report end-user needs to navigate to path as below.
Now the user has enough information in the system to generate the Depreciation Schedule Asset report so he must go to [ Financial Management || Assets || Analysis Tools || Depreciation Schedule ]
It is important to understand that the Deprecation amount displayed on the report should be the amount which are posted on the below application path.
>> Financial Management >> Asset >> Amortization
USE CASE EXAMPLES
USE CASE 1
- Select/enter the "from date" & "to date" as the only filters, then the result should shown data taking into account "from date" and "to date" entered.
- In our case "from date" is : 2010 and "to date" is : 2011. Refer the screen shot below.
USE CASE 2
- Select/enter the "asset search value" as the only one filter, then the result will be shown taking into account of "asset search value".
- In our case "asset search value " is: 'scomputer'. Refer the screen shot below.
USE CASE 3
- Select/enter the "asset description" as the only filter, then the result will be shown taking into account "asset description" value entered as filter.
- In our case asset description is : "Van for product delivery". Refer the screen shot below.
USE CASE 4
- Select/enter the "asset category" as the only filter, then the result will be shown taking into account "asset category" value entered as filter.
- In our case asset category could be : "Machinery". Refer the screen shot below.
USE CASE 5 [MULTIPLE FILTERS]
- Select/enter the "Asset Category","Amortization Start Date" and "Amortization Start Date" as the filters, then the result will be shown taking into account "Asset Category", "Amortization Start Date" and "Amortization Start Date" values entered as filter.
- In our case, We have selected the "Asset Category" as "Machinery", "Amortization Start Date" as : 09-07-2009 and "Amortization End Date" as : 31-12-2012. So, The result will be show as below.
USE CASE 6 [MULTIPLE FILTERS]
- Select/enter the "Asset Description " and "Asset Search key" as the filters, then the result will be shown taking into account "Asset Description" and "Asset Search key" values entered as filter.
- In our case, We have selected/entered the "Asset Description" value with : "%research%" and "Asset Search key" value with :"scomputer". So, The result will be show as below.
Open Discussion Items
Purpose
I'm in doubt whether this report is a schedule report or not. We need to make sure this term is used in the right way because my understanding now is that this report is showing a "photo" of the depreciation plan for a give fixed asset. In case we understand schedule as the "planned" depreciation for a given fixed asset along its year of live, we should be fine.
"Depreciation amount" should replace "Amount" column and I would specify that the "total amount" is not a column but a total line per asset.
Can you please attach a mock-up of where to find this new report in the application?
Scope
Please find below and compare how I would write Scope section as there are some English terminology which is not easy to understand:
"The Asset Depreciation Schedule report is a new report which will help the end-user to get detailed information about the depreciation amount of a specific fixed asset for a specific period of time entered by the end-user.
The result of the report will be shown based on the filters applied by the end-user. For example, if the end-user tries to get depreciation schedule report for a specific asset, he/she should enter some value in the search key field or some value in the description field to get the systems shows depreciation data for the particular asset he/she is looking for.
This report has below output columns:
- FIXED ASSET NAME - Displays the Asset name
- ASSET DESCRIPTION - Displays the Asset description
- FROM DATE - Displays the "from date" when the end-user needs to get depreciation amount information for a specific fixed asset.
- TO DATE - Displays the "to date" when the end-user need to get depreciation amount information for a specific fixed asset.
- AMOUNT - Displays the depreciation amount of the asset for a specific period of time entered by the end-user.
- CURRENCY -Displays the currency information from the accounting schema used to depreciate the asset.
The system does not require any setup for Asset report for depreciation schedule, therefore no configuration needs to be done.
and a sum line which shows the TOTAL (depreciation) AMOUNT
- Displays the total depreciation amount of the asset within a specific period of time entered by the end-user."
Scope
Please find below and compare how I would write Scope section as there are some English terminology which is not easy to understand:
Depreciation Schedule Asset report do not require any specific setup but to get Fixed Asset module setup and working as normal, therefore no specific configuration needs to be done.
Feature Behavior
Please find below and compare how I would write Scope section as there are some English terminology which is not easy to understand:
In-order to work with this report, a few "filters" need to be entered/selected by the end user as showed below. (Please specify wit an example what the report must show in case non filters but organization is selected). It is important to note than non of them are mandatory but "Organization".
FILTER PARAMETERS
- "From Date" => Searches and displays report output based on the "From Date" entered by the user (Please specify with an example what the report must show in case From date and To date are the only filters entered)
- "To Date" => Searches and displays report output based on the "To Date" entered by the user.
- "Asset Search Key value" => Searches and displays report output based on the "Asset search" value entered by the user which should match the existing asset to be shown in the report (Please specify an example).
- "Asset Description" => Searches and displays report output based on the "Asset description" value entered by the user which should match the existing asset to be shown in the report (Please specify an example).
- "Asset Category" => Searches and displays report output based on the "Asset Category" selected by the user (Please test what the report would show in case asset category is entered as a filter. would that mean report would show data for all the Asset belonging to that category?)
- "Accounting Schema" => Searches and displays report output based on the "Accounting Schema" selected by the user which should match the accounting schema used to depreciate a given asset shown in the report (Please specify an example).
- "Organization" (Mandatory)=> Searches and displays report output based on the "Organization" selected by the user.(Please specify
Output Format
(I'm afraid I do not understand here what you mean by default page, please be more specific and show an example of the output depending on whether the end user click default page or PDF buttons). I guess what you mean is that the result of the report is going to be shown to the user as a new page in the application and as a PDF file? Why the button is called Search and not "new page" by example?
See below what I would say:
The Asset Depreciation Schedule report should have two different output formats as a application page?? and as a pdf file.
-Application page?? - There will be a button called "New page" to get this output format. If the end-user choose this option report output format will be a new application page or view.
- *.pdf file - There will be a button called "pdf format" to get this output format. If the end-user choose this optino report output format will be a pdf file
In the image below I do not understand why the report is showing for different years (2009, 2010, where is 2011 for the first one?, 2012, 2013 and 2014), the same date 26/06/2019 as from date and to date????
I would expect the below. if as an end user I enter 01/07/2009 as from date and enter 01/08/2012 as to date, I would expect to see years 2009, 2010 and 2012 scheduled or planned depreciation as shown below in case depreciation is annual and each month depreciation amount = 100 € for a given asset (please check with Eduardo):
2009 - 01/07/2009 - 31/12/2009 - 600,00 €
2010 - 01/01/2010 - 31/12/2010 - 1200,00 €
2011 - 01/01/2011 - 31/12/2011 - 1200,00 €
2012 - 01/01/2012 - 01/08/2012 - 800,00 €
Database Information
I would say that:
The asset depreciation schedule report implementation retrieve data required from accounting, which means the FACT_ACCT table and it is also based on asset and asset accounting schema data.
Depreciation schedule fixed asset report content
(please use feedback already provided in relation to Scope section)
Use case
I would say:
The asset depreciation schedule report is a report which can be used by the end-user to get information about the depreciation scheduled for a giver asset/assets based on some filters ....
STEP1
I would say:
The end-user Peter creates a new asset with the setup showed in the image attached below. For doing that he needs to navigate to Financial Management /Asset /Asset and create a new record and select the field "Depreciate" :
image
I would say that:
The important information to take into account is that :
1.- annual depreciation is a 20%
2.- Depreciation start date is 01/072009 and end date 30/06/2014 which means 5 years
3.- Asset value is 2.000.000 with a residual value of 550.000 which means a depreciation amount of 1.450.000 and that leads in an "overall" annual depreciation of 290.000
STEP 2
I would say:
After the asset has been created Peter clicks the "Create Amortization" button and then click ok in the pop up window to generate the depreciation plan for the just created asset. He would need to check depreciation has been properly created by navigating to the "Asset Amortization" tab.
STEP 3
I would say:
After doing step 2 Peter needs to post the first depreciation line so he navigates to Financial Management / Assets / Amortization, and in the header he selects the correspondent line, process it and post it. After doing that the correspondent depreciation amount already posted will be shown in the column "Total amortization", in our example the amount must be 145.796,70
STEP 4
I would say:
Peter repeats step 1 to 3 for at least 3 new assets which he has to create having in mind that 2 of them should belong to the same asset category and the 3rd one to a different one (category).
STEP 5
I would say:
Peter is able now to generate the Asset depreciation schedule report for doing that he needs to follow below sub-steps:
- He must go to Financial Management / Asset / Analysis Tools / Depreciation schedule report
Starting from here I'd like you to test below scenarios with the real data (3 assets) you have created in STEP 4.
You should show as a mock-up which is the result of each scenario listed below:
Use case 1 Generate the report by entering a from date and to date; in this case we want to verify that report output result (which at the end are the assets shown in the report) takes into account the depreciation start and end dates we entered for each of the 3 assets created.
Use case 2 Generate the report and show it by entering a value on the asset name field. Report output amounts and dates should be the right ones depending on the asset selected and its depreciation setup and the dates (depreciation start and end date) setup by default for the asset
Use case 3 Generate the report and show it by entering a search key. You could here referred to use case 2 above in case you choose the same asset to make it easy to document as the purpose here is mainly to verify that the filter works.
Use case 4 Generate the report and show it by entering a value in the description field. You could here referred to use case 2 and 3 result above in case you choose the same asset to make it easy to document as the purpose here is mainly to verify that the filter works.
Do the same for: asset category (in this case only 2 assets belonging to the same category should be entered in the report), accounting schema, organization (in this case all assets will be shown as all belong to the same organization)
Last use case should be a combination of filters with basic but real examples.
New feedback
You need to analyze what should be the right "From date" and "To date" report columns behavior because now it is not clear, that's my opinion.
Every single report output you have copy/paste in the spec shows as from date the "Depreciation start date" for a given asset and as To date the "Depreciation end date", see below "Super computer example", is that right?
Fiscal year From date To date
2009 01-07-2009 30-06-2014
2010 01-07-2009 30-06-2014
2011 01-07-2009 30-06-2014
2012 01-07-2009 30-06-2014
2013 01-07-2009 30-06-2014
2014 01-07-2009 30-06-2014
If that is the case I would rename those columns as showed below:
From date should be named "Depreciation start date" and
To date should be named "Depreciation end date".
In case the above is not right, From date and To date should have into account which is the 1st date of a given fiscal year and in relation to the to date which is the last day of the fiscal year depending on the calendar being used within an organization and having into account depreciation start and end dates for a give asset.
An example is shown below for the "super computer" asset having into account that depreciation start date is 01-07-2009 and depreciation end date is 30-06-2014 and organization calendar is a yearly calendar starting 01-01-xxxx and ending 31-12-xxxx:
Fiscal year From date To date
2009 01-07-2009 31-12-2009
2010 01-01-2010 31-12-2010
2011 01-01-2011 31-12-2011
2012 01-01-2012 31-12-2012
2013 01-01-2013 31-12-2013
2014 01-01-2014 30-06-2014
It would be great to know what is the basic data you have entered for each of the 3 fixed assets you have created, so please fill-in below information for each of the asset you have created in STEP 4 in STEP 4 section (same as described in STEP 1 for the 1st create asset) so we can better understand each report output for each use case
asset name =
asset category=
asset search key =
asset description =
annual depreciation % =
depreciation start date=
depreciation end date=
depreciation amount =
and residual asset value=
use case 1
Please enter as From date = 01-01-2009 and To date = 31-12-2010 and let us know what report output is. The dates you have entered do not help to test date filters works properly as those dates (from 2009 to 2014) cover whole data set you have entered and we should filter data somehow.
Final scenario
I'm missing a final use case scenario showing a combination of filters, by example from date 01-01-209 to date 31-12-2010 and asset category machinery.
New feedback (July 8th)
There are 3 important open topics left and described below which should be handled by the IN team:
1st From date and To Date report columns should reflect the proper dates as per last feedback sent by Victor and I..(now those columns are just depreciation start and end dates and that is not correct). I have removed the mock-ups which are reflecting wrong data...please be aware that once some feedback is given you should take into account that it could affect more than only 1 section in the Spec.
2nd It should be clearly stated in the FS that only those depreciation amounts posted should be the ones shown in the report (please remember that data is retrived from FACT_ACCT table). Please make this point clearly stated in sections: Feature behaviour and use cases.
3rd There should be a final scenario based on a combination of filters. Please make it happen as I already provide this feedback twice.