0018542: Asset: The currency can been updated in the main tab while the Asset Amortization is already created

Description

The currency of the Asset can be changed after the Amortization lines were created already.

Steps To Reproduce

Using the F&B US, Inc. - Finance & HR role:
For the execution of the exercise the following configurations are required:

    Go to the Product Category screen
    Create a new record
        Organization = F&B US, Inc.
        Search Key = Asset,
        Name = Asset,
        Save the record
    The accounting defaults were populated in the [Accounting] tab.
    Go to the Price List screen
    Create a new record,
        Organization = F&B US, Inc,
        Name = General Purchases,
        Currency = USD,
        Sales Price List checkbox = not selected,
        Save the record
    Go to the Price List Version tab,
    Create a new record,
        Name = General Purchases 2011,
        Valid from Date = 01-01-2011,
        Price List Schema = Default Price List Schema,
        Base Version = blank,
        Save the record
    You leave the [Product Price] tab empty. When the product gets entered, you add it to this price list.
    Go to the Business Partner screen
    Create a new record
        Organization = F&B US, Inc.,
        Search Key = Computer Shop,
        Name = Computer Shop,
        Business Partner Category = Supplier
        Save the record
    Go to the [Vendor/Creditor] tab
        Vendor checkbox = selected,
        Purchase Pricelist = General Purchases,
        PO Payment Method = Wire Transfer,
        PO Payment Terms = 30 days,
        PO Financial Account = US Bank - Account 1,
        Tax Category = blank,
        Save the record
    Go to the [Location/Address] tab
        Create a new record
        Location/Address: in the selector:
        1st Lines = Lombard street 235,
        City = San Francisco,
        Country = United States,
        Region = CA,
        Click the OK button
        Name = leave blank (the system will populate the information when you save the record)
        Save the record
    Go to the Product screen
    Create a new record
        Organization = F&B US West Coast,
        Search Key = HP Laptop,
        Name = HP Laptop,
        UOM = Unit,
        Product Category = Asset,
        Tax Category = US State Sales Tax,
        Product Type = Item,
        Stocked checkbox = not selected
        if you want to include the assets in your stock, this checkbox should be selected
        Purchase checkbox = selected
        Sale checkbox = not selected
        if you intend to sell the asset at some point, this checkbox should be selected. In this case we do not sell the laptop. After it is depreciated, we will either continue using it or dispose of it.
        Cost type = Standard,
        Standard Cost = 1500,
        Save the record.
    Go to the [Price] tab
        Create a new record
        Price List Version = General Purchases 2011,
        Net Unit Price = 1500,
        Net List Price = 1600,
        Save the record.
    Go to the Asset Group screen
    Create a new record
        Organization = F&B US, Inc.,
        Name = Computer Hardware,
        Save the record
    The information in the [Accounting] tab is generated.
    Due to an issue, the amortization table is not activated for posting, so you have to execute an extra step for that:
    Using the F&B International Group Admin role:
    Go to the Accounting Schema screen,
            Select F&B US, Inc. US/A/US Dollar
        Go to the [Account Schema Tables] tab
            Select the A_Amortization (FinancialMgmtAmortization) table
            Select the Active checkbox
            Save the record

Steps to execute
Using the F&B International Group Admin, Organization F&B US West Coast role:

    Normally you would have the finance person enter the request for the laptop in a requisition. Since you have seen that functionality already in the Procure to Pay section, you skip this step here and have the purchase manager enter a purchase order directly.
    Go to the Purchase Order screen
    Create a new record
        Organization = F&B US West Coast,
        Transaction Document = US Purchase Order,
        Order Date = today's date,
        Business Partner = Computer Shop,
        Warehouse = US West Coast,
        Scheduled Delivery Date = today's date,
        Payment Method = Wire Transfer,
        Payment Terms = 30 days,
        Price List = General Purchases,
        Save the record
    Go to the [Lines] tab
    Create a new record,
        Product = HP Laptop,
        Ordered Quantity = 1,
        Net Unit Price = 1,500,
        Save the record
    Go back to the main tab and complete the order:
        Click the Book button,
        Click the OK button
    Go to the Pending Goods Receipts screen
        Business Partner = Computer Shop,
        Organization = F&B US West Coast,
        Click the Search button
    Select the line for the laptop
        Reception Date = today's date,
        Storage bin = WC-0-0-0,
        Click the Process button,
    The completion message displays the number of the created goods receipt.
    Using the F&B US, Inc. - Finance & HR role:
    Go to the Goods Receipt screen
        Click the Generate Invoice from Receipt button
        Price List Version = General Purchases 2011,
        Click the OK button
    The completion message displays the number of the created purchase invoice.
    Go to the Purchase Invoice screen
        Select the created purchase invoice and complete it:
        Click the Complete button
        Click the OK button
    Now that the laptop has been bought and received, you enter the asset:
    Go to the Assets screen
    Create a new record
        Organization = F&B US West Coast,
        Search Key = Laptop,
        Name = Laptop,
        Asset Category = Computer Hardware,
        Product = HP Laptop,
        Currency = EUR,
        Depreciate checkbox = selected,
        Depreciation Type = Linear,
        Calculate Type = Time,
        Amortize = Yearly,
        Usable Life - Years = 3,
        Purchase Date = today's date,
        Cancellation Date = blank,
        Depreciation Start Date = today's date,
        Depreciation End Date = blank,
        Asset Value = 1500,
        Residual Asset Value = 0,
        Depreciation Amount = 1500,
        Previously Depreciated Amt = 0,
        Save the record
    To create the amortization periods:
        Click the Create amortization button
        Click the OK button

At this point I realize that the currency on the Asset should be USD, not EUR.
I go back to the main section of the screen, change the currency from EUR to USD and save. The application allows this even though there are the Asset Amortization lines with a EUR currency (see snapshot).

Proposed Solution

I spoke with Patricia about this and it should not be allowed to change the currency without deleting the Amortization lines (and accounting tab lines I assume?) first.

Tags

No tags attached.

Attached Files

160911Assetissue.png [^] (78,446 bytes) 2011-09-16 13:07

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on	backport	0019150	2.50MP37	closed	ioritzCia	Asset: The currency can been updated in the main tab while the Asset Amortization is already created
related to	design defect	0019174		new	dmiguelez	Asset Amortization process does not recalculate amortizations

Notes
(0042391) jonalegriaesarte (reporter) 2011-10-31 10:55	Actually working on it. It is planned to be included in MP6.

(0043142) hgbot (developer) 2011-11-24 10:35	Repository: erp/devel/pi Changeset: e3c5594a2f2f064c3ad0391febc2e7a86b815d82 Author: Ioritz Cia <ioritz.cia <at> openbravo.com> Date: Wed Nov 23 13:34:12 2011 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/e3c5594a2f2f064c3ad0391febc2e7a86b815d82 [^] Fixes issue 18542: Asset: The currency can be updated in the main tab while the Asset Amortization is already created. --- M src-db/database/sourcedata/AD_AUXILIARINPUT.xml M src-db/database/sourcedata/AD_COLUMN.xml ---

(0043163) ioritzCia (developer) 2011-11-24 13:57	Testing Plan: - Follow the steps to reproduce. Other information: - The reported issue has been resolved but a design defect has been found. Se the related design defect.

(0043435) hudsonbot (developer) 2011-11-30 12:29	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/01809c7b3135 [^] Maturity status: Test

(0043604) jonalegriaesarte (reporter) 2011-11-30 20:03	Now the currency in the asset can not be changed and the amortization lines are correctly created.

Issue History
Date Modified	Username	Field	Change
2011-09-16 13:07	RenateNieuwkoop	New Issue
2011-09-16 13:07	RenateNieuwkoop	Assigned To	=> jonalegriaesarte
2011-09-16 13:07	RenateNieuwkoop	File Added: 160911Assetissue.png
2011-09-16 13:07	RenateNieuwkoop	Modules	=> Core
2011-10-17 19:37	jonalegriaesarte	Target Version	=> 3.0MP6
2011-10-31 10:55	jonalegriaesarte	Note Added: 0042391
2011-10-31 10:55	jonalegriaesarte	Severity	major => minor
2011-11-17 16:11	jonalegriaesarte	Assigned To	jonalegriaesarte => ioritzCia
2011-11-23 13:57	ioritzCia	Status	new => scheduled
2011-11-23 13:57	ioritzCia	fix_in_branch	=> pi
2011-11-24 10:35	hgbot	Checkin
2011-11-24 10:35	hgbot	Note Added: 0043142
2011-11-24 10:35	hgbot	Status	scheduled => resolved
2011-11-24 10:35	hgbot	Resolution	open => fixed
2011-11-24 10:35	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/e3c5594a2f2f064c3ad0391febc2e7a86b815d82 [^]
2011-11-24 13:57	ioritzCia	Note Added: 0043163
2011-11-24 13:57	ioritzCia	Relationship added	related to 0019174
2011-11-30 12:29	hudsonbot	Checkin
2011-11-30 12:29	hudsonbot	Note Added: 0043435
2011-11-30 20:03	jonalegriaesarte	Note Added: 0043604
2011-11-30 20:03	jonalegriaesarte	Status	resolved => closed
2011-11-30 20:03	jonalegriaesarte	Fixed in Version	=> 3.0MP6