Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0018542Openbravo ERP09. Financial managementpublic2011-09-16 13:072011-11-30 20:03
RenateNieuwkoop 
ioritzCia 
normalminoralways
closedfixed 
5
 
3.0MP63.0MP6 
Core
No
0018542: Asset: The currency can been updated in the main tab while the Asset Amortization is already created
The currency of the Asset can be changed after the Amortization lines were created already.
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).
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.
No tags attached.
depends on backport 00191502.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 
png 160911Assetissue.png (78,446) 2011-09-16 13:07
https://issues.openbravo.com/file_download.php?file_id=4551&type=bug
png
Issue History
2011-09-16 13:07RenateNieuwkoopNew Issue
2011-09-16 13:07RenateNieuwkoopAssigned To => jonalegriaesarte
2011-09-16 13:07RenateNieuwkoopFile Added: 160911Assetissue.png
2011-09-16 13:07RenateNieuwkoopModules => Core
2011-10-17 19:37jonalegriaesarteTarget Version => 3.0MP6
2011-10-31 10:55jonalegriaesarteNote Added: 0042391
2011-10-31 10:55jonalegriaesarteSeveritymajor => minor
2011-11-17 16:11jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2011-11-23 13:57ioritzCiaStatusnew => scheduled
2011-11-23 13:57ioritzCiafix_in_branch => pi
2011-11-24 10:35hgbotCheckin
2011-11-24 10:35hgbotNote Added: 0043142
2011-11-24 10:35hgbotStatusscheduled => resolved
2011-11-24 10:35hgbotResolutionopen => fixed
2011-11-24 10:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e3c5594a2f2f064c3ad0391febc2e7a86b815d82 [^]
2011-11-24 13:57ioritzCiaNote Added: 0043163
2011-11-24 13:57ioritzCiaRelationship addedrelated to 0019174
2011-11-30 12:29hudsonbotCheckin
2011-11-30 12:29hudsonbotNote Added: 0043435
2011-11-30 20:03jonalegriaesarteNote Added: 0043604
2011-11-30 20:03jonalegriaesarteStatusresolved => closed
2011-11-30 20:03jonalegriaesarteFixed in Version => 3.0MP6

Notes
(0042391)
jonalegriaesarte   
2011-10-31 10:55   
Actually working on it. It is planned to be included in MP6.
(0043142)
hgbot   
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   
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   
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   
2011-11-30 20:03   
Now the currency in the asset can not be changed and the amortization lines are correctly created.