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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0019150

Openbravo ERP

09. Financial management

public

2011-09-16 13:07

2011-12-15 11:43

Reporter

RenateNieuwkoop

Assigned To

ioritzCia

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

2.50MP37

Fixed in Version

2.50MP37

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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.

Additional Information