0019150: 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.

Notes
(0043642) hgbot (developer) 2011-12-01 11:53	Repository: erp/stable/2.50 Changeset: 62d26f486d4b138e4245a017e3ae07b7606af102 Author: Ioritz Cia <ioritz.cia <at> openbravo.com> Date: Wed Nov 23 13:58:16 2011 +0100 URL: http://code.openbravo.com/erp/stable/2.50/rev/62d26f486d4b138e4245a017e3ae07b7606af102 [^] Fixes issue 19150: 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 ---

(0043892) jecharri (developer) 2011-12-15 11:43	Verified

Issue History
Date Modified	Username	Field	Change
2011-11-23 13:57	ioritzCia	Type	defect => backport
2011-11-23 13:57	ioritzCia	fix_in_branch	=> 2.50
2011-11-24 16:52	ioritzCia	Target Version	3.0MP6 => 2.50MP37
2011-12-01 11:53	hgbot	Checkin
2011-12-01 11:53	hgbot	Note Added: 0043642
2011-12-01 11:53	hgbot	Status	scheduled => resolved
2011-12-01 11:53	hgbot	Resolution	open => fixed
2011-12-01 11:53	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.50/rev/62d26f486d4b138e4245a017e3ae07b7606af102 [^]
2011-12-15 11:43	jecharri	Note Added: 0043892
2011-12-15 11:43	jecharri	Status	resolved => closed
2011-12-15 11:43	jecharri	Fixed in Version	=> 2.50MP37