Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0021901
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2012-10-10 17:212012-12-10 13:45
ReporterVictorVillarView Statuspublic 
Assigned ToioritzCia 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision482e5d730583
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToVictorVillar
Web browser
ModulesCore
Regression levelProduction - QA Approved
Regression date
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/f95e6cf72b42 [^]
Triggers an Emergency PackNo
Summary

0021901: Error in Asset Amortization calculation

DescriptionError in Asset Amortization calculation.
The asset amortization errors just saying 'an error occurred calculating the
amortization plan'
Steps To ReproduceGo 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,
Default checkbox = selected,
Save the record

Go to the Price List Version tab,
Create a new record,

Name = General Purchases 2012,
Valid from Date = 01-01-2012,
Price List Schema = 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,
Commercial 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 = USD - Bank - Account 1,
Tax Category = Exempt,
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,
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.
Product Type = Item,
Stocked checkbox = not selected
If you want to include the assets in your stock, this checkbox should be selected
Weight = blank,
Attribute Set = blank,
UPC/EAN = blank,
Production checkbox = not selected,
Summary Level checkbox = not selected,
Bill of Materials checkbox = not selected,
Save the record.

Go to the [Price] tab

Create a new record
Price List Version = General Purchases 2012,
Net Unit Price = 1500,
Net List Price = 1600,
Save the record.
Create a new record
Price List Version = General Sales,
Net Unit Price = 0,
Net List Price = 0,
Save the record
Note:
The above sales price list is added even though the product is not sold, for the product to be selectable in the assets screen.

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.

EXECUTION:
Go to the Purchase Order screen
Create a new record

Organization = F&B US West Coast,
Transaction Document = 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,
Tax = Sales Exempt,
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 role:
Go to the Goods Receipt screen and select the record that was created in the previous step.

Click the Generate Invoice from Receipt button
Price List Version = General Purchases 2012,
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,
Currency = USD,
Note:
The currency value is entered, because products that appear are based on the selected currency since the product needs to have a price list in the
selected currency.
Product = HP Laptop,
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 the error appears.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0053230)
dmitry_mezentsev (developer)
2012-10-10 18:05

David, Jon,

Could you dig into this issue please?

We need to understand:
1. Exactly the MP when it was introduced.
2. Impact of the issue (happens always or for some cases).
3. Your proposal about launching emergency MPs based on it and which.

Thanks.
(0053362)
hgbot (developer)
2012-10-16 09:14

Repository: erp/devel/pi
Changeset: 482e5d7305839bfa3a4d6679db5f4ea07430058f
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Thu Oct 11 10:02:06 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/482e5d7305839bfa3a4d6679db5f4ea07430058f [^]

Fixes issue 21901: Error in Asset Amortization calculation.

---
M src-db/database/model/functions/A_ASSET_POST.xml
---
(0053401)
hudsonbot (developer)
2012-10-16 18:54

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/0381663eaf40 [^]

Maturity status: Test
(0053479)
VictorVillar (developer)
2012-10-19 09:12

Verified

- Issue History
Date Modified Username Field Change
2012-10-10 17:21 VictorVillar New Issue
2012-10-10 17:21 VictorVillar Assigned To => dmiguelez
2012-10-10 17:21 VictorVillar Modules => Core
2012-10-10 17:22 VictorVillar Regression level => Production - QA Approved
2012-10-10 17:38 dmiguelez Assigned To dmiguelez => jonalegriaesarte
2012-10-10 17:46 VictorVillar Issue Monitored: networkb
2012-10-10 18:05 dmitry_mezentsev Note Added: 0053230
2012-10-10 18:16 jonalegriaesarte Assigned To jonalegriaesarte => ioritzCia
2012-10-15 09:45 ioritzCia Status new => scheduled
2012-10-15 09:45 ioritzCia fix_in_branch => pi
2012-10-16 09:14 hgbot Checkin
2012-10-16 09:14 hgbot Note Added: 0053362
2012-10-16 09:14 hgbot Status scheduled => resolved
2012-10-16 09:14 hgbot Resolution open => fixed
2012-10-16 09:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/482e5d7305839bfa3a4d6679db5f4ea07430058f [^]
2012-10-16 18:54 hudsonbot Checkin
2012-10-16 18:54 hudsonbot Note Added: 0053401
2012-10-19 09:12 VictorVillar Review Assigned To => VictorVillar
2012-10-19 09:12 VictorVillar Note Added: 0053479
2012-10-19 09:12 VictorVillar Status resolved => closed
2012-12-10 13:44 ioritzCia Status closed => new
2012-12-10 13:44 ioritzCia Resolution fixed => open
2012-12-10 13:45 ioritzCia Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/f95e6cf72b42 [^]
2012-12-10 13:45 ioritzCia Triggers an Emergency Pack => No
2012-12-10 13:45 ioritzCia Status new => scheduled
2012-12-10 13:45 ioritzCia fix_in_branch pi =>
2012-12-10 13:45 ioritzCia Status scheduled => resolved
2012-12-10 13:45 ioritzCia Resolution open => fixed
2012-12-10 13:45 ioritzCia Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker