0027932: [Costing] Costing Background process is assuming a negative shipment as a voided shipment

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0027932

Openbravo ERP

09. Financial management

public

2014-10-21 13:47

2014-11-03 13:40

Reporter

plujan

Assigned To

umartirena

Priority

normal

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

no change required

Platform

OS Version

Product Version

main

Target Version

3.0PR14Q4

Fixed in Version

main

Merge Request Status

Review Assigned To

umartirena

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Packaging and release

Regression date

Regression introduced in release

main

Regression introduced by commit

Triggers an Emergency Pack

Summary

0027932: [Costing] Costing Background process is assuming a negative shipment as a voided shipment

Description

When creating a negative shipment to calculate the initial cost of a product, the process monitor shows an error that seems to be caused by wrongly assuming the shipment is voiding a positive shipment (that does not actually exist)

Steps To Reproduce

1. Login as:
Username: QAAdmin
Password: QAAdmin

2. Modify Document Types
Go to Financial Management || Accounting || Setup || Document Type:
Select the record with Name: "RFC Order"
Set "Organization": *
Select the record with Name: "RFC Receipt"
Set "Organization": *
Select the record with Name: "RTV Order"
Set "Organization": *
Select the record with Name: "RTV Shipment"
Set "Organization": *

3. Schedule the Costing Process
Go to General Setup || Process Scheduling || Process Request:
Click New and select:
"Client": QA Testing
"Organization": *
"Process": Costing Background process
"Timing": Run Immediately
Click on "Schedule Process".
A popup should appear with the message:
"Process completed succesfully"

4. Create the Product
Go to Master Data Management || Product:
Click New and select:
"Organization": USA
"Search Key": CostingProduct
"Name": CostingProduct
"UOM": Unit
"Product Type": Item

5. Create the Price List for Purchase and Sales
Go to Master Data Management || Pricing || Price List:
Click New and select:
"Organization": USA
"Name": Costing Price List
"Currency": USD
Move to Price List Version and create a new row:
"Name": Costing Price List
"Valid from Date": 01-01-2012
Move to Product Price and create a new row:
"Product": CostingProduct
"Net Unit Price": 50.00
"Net List Price": 50.00

Click New and select:
"Organization": USA
"Name": Costing Price List Sales
"Currency": USD
"Sales Price List": Checked
Move to Price List Version and create a new row:
"Name": Costing Price List Sales
"Valid from Date": 01-01-2012
Move to Product Price and create a new row:
"Product": CostingProduct
"Net Unit Price": 50.00
"Net List Price": 50.00

6. Create a Business Partner:
Go to Master Data Management || Business Partner:
Click New and select:
"Organization": *
"Search Key": Costing Business Partner
"Commercial Name": Costing Business Partner
Move to Customer.
"Price List": Costing Price List Sales
"Payment Method": 1 (USA)
"Payment Terms": 90 days
"Financial Account" USD - USA Cashbook
Move to Vendor/Creditor.
"Vendor": Checked
"Purchase Price List": Costing Price List
"PO Payment Method": 1 (USA)
"PO Payment Terms": 90 days
"PO Financial Account" USD - USA Cashbook
Move to Location/Address
"Location / Address":
"1st line": Street
"Postal Code": 0123456
"City": City
"Country": United States
"Region": AK

7. Create a Tax Rate:
Go to Financial Management || Accounting || Setup || Tax Rate:
Click New and select:
"Organization": USA
"Name": Costing Tax Rate
"Valid From Date": 01-01-2012
"Tax Category": Exempt
"Default": Checked

8. Create Negative Goods Shipment.
Go to Sales Management || Transactions || Goods Shipment:
Click New and select:
"Organization": USA
“Business Partner”: Costing Business Partner
Move to Lines. Click new and select:
“Product”: CostingProduct
“Movement Quantity”: -50
"Storage Bin": USA111
Click the “Complete” button. Click OK.

9. Reschedule the Process
Go to General Setup || Process Scheduling || Process Request:
Select the process Costing Background Process.
Click on "Reschedule Process"

Expected result:
A popup should appear with the message:
"Process completed succesfully"

Actual result:
"Index: 0, Size: 0"

Log message
2014-10-21 10:44:53,575 [DefaultQuartzScheduler_Worker-6] ERROR org.openbravo.costing.CostingBackground - Index: 0, Size: 0
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
        at java.util.ArrayList.rangeCheck(ArrayList.java:571)
        at java.util.ArrayList.get(ArrayList.java:349)
        at org.hibernate.collection.PersistentBag.get(PersistentBag.java:446)
        at org.openbravo.costing.CostingAlgorithm.getOriginalInOutLineCost(CostingAlgorithm.java:326)
        at org.openbravo.costing.CostingAlgorithm.getShipmentVoidCost(CostingAlgorithm.java:200)
        at org.openbravo.costing.CostingAlgorithm.getTransactionCost(CostingAlgorithm.java:109)
        at org.openbravo.costing.AverageAlgorithm.getTransactionCost(AverageAlgorithm.java:45)
        at org.openbravo.costing.CostingServer.process(CostingServer.java:104)
        at org.openbravo.costing.CostingBackground.doExecute(CostingBackground.java:106)
        at org.openbravo.service.db.DalBaseProcess.execute(DalBaseProcess.java:80)
        at org.openbravo.scheduling.DefaultJob.execute(DefaultJob.java:58)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)

Proposed Solution

Additional Information