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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0042492
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2019-12-09 15:062019-12-20 10:28
ReporterngarciaView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionfixedFixed in Version3.0PR20Q1
StatusclosedFix in branchFixed in SCM revision462c35e38ba5
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0042492: Fix Backdated From finishes with an empty error if the ending date of a calculated cost is manually edited

DescriptionFix Backdated From finishes with an empty error if the ending date of a calculated cost is manually edited

The problem is in the following line of extendPreviousCosting function of AverageCostAdjustment:

    lastCosting.setEndingDate(bdCosting.getEndingDate());

bdCosting is null because it does not exist any costing entry with an ending date equal to the starting date of the current costing entry
Steps To ReproduceAs group admin role:
   Create a new product
   Set it as stocked
   Add a purchase price list to it
   Create three goods receipts with the following dates:
      1st: 09-12-2019
      2nd: 12-12-2019
      3rd: 11-12-2019
   Add previously created product in the three of them and complete them
   Schedule the Costing Background Process to be run immediately
   Change the ending date of the costing entry related to the transaction of the 12-12-2019 to yesterday (one day before the transaction process date)
   Go to Costing Rules window and launch the Fix Backdated Transactions process
   Select 01-01-2019 as Fix Backdated From
   Check an empty error message is shown

   The log shows:
      ERROR org.openbravo.costing.FixBackdatedTransactionsProcess - null
java.lang.NullPointerException: null
    at org.openbravo.costing.AverageCostAdjustment.extendPreviousCosting(AverageCostAdjustment.java:957) ~[classes/:?]
    at org.openbravo.costing.AverageCostAdjustment.calculateBackdatedTrxAdjustment(AverageCostAdjustment.java:592) ~[classes/:?]
    at org.openbravo.costing.CostingAlgorithmAdjustmentImp.searchRelatedTransactionCosts(CostingAlgorithmAdjustmentImp.java:148) ~[classes/:?]
    at org.openbravo.costing.CostAdjustmentProcess.calculateAdjustmentAmount(CostAdjustmentProcess.java:238) ~[classes/:?]
    at org.openbravo.costing.CostAdjustmentProcess.processCostAdjustment(CostAdjustmentProcess.java:86) ~[classes/:?]
    at org.openbravo.costing.CostAdjustmentProcess.doProcessCostAdjustment(CostAdjustmentProcess.java:342) ~[classes/:?]
    at org.openbravo.costing.FixBackdatedTransactionsProcess.doExecute(FixBackdatedTransactionsProcess.java:143) [classes/:?]
    at org.openbravo.client.application.process.BaseProcessActionHandler.execute(BaseProcessActionHandler.java:150) [classes/:?]
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0116449)
AtulOpenbravo (developer)
2019-12-20 06:27

 Test Plan

- Login as F&B International Group admin role
- Create a new product
   - Set it as stocked
   - Add a purchase price list to it
- Create three goods receipts with the following dates:
      1st: 09-12-2019
      2nd: 12-12-2019
      3rd: 11-12-2019
   Add previously created product in the three of them and complete them
- Schedule the Costing Background Process to be run immediately
- Change the ending date of the costing entry related to the transaction of the 12-12-2019 to yesterday (one day before the transaction process date)
- Go to Costing Rules window and launch the Fix Backdated Transactions process
  - Select 01-01-2019 as Fix Backdated From
  - Realize that process is completed successfully and end date of modified costing record is set correctly.
(0116456)
hgbot (developer)
2019-12-20 10:27

 Repository: erp/devel/pi
Changeset: 462c35e38ba5c680442dfcba905e5d3a80e10d68
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Dec 19 19:21:43 2019 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/462c35e38ba5c680442dfcba905e5d3a80e10d68 [^]

Fixes BUG-42492:Fix Backdated From finishes with an empty error if
the ending date of a calculated cost is manually edited

**In extendPreviousCosting method of Average Cost Adjustment class
get costing record by addiin condition <= enddate, sort costing record
with enddate desc order in extendPreviousCosting, set fetch size to 1

---
M src/org/openbravo/costing/AverageCostAdjustment.java
---
(0116457)
dmiguelez (developer)
2019-12-20 10:28

 Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2019-12-09 15:06 ngarcia New Issue
2019-12-09 15:06 ngarcia Assigned To => Triage Finance
2019-12-09 15:06 ngarcia Modules => Core
2019-12-09 15:06 ngarcia Resolution time => 1577660400
2019-12-09 15:06 ngarcia Triggers an Emergency Pack => No
2019-12-10 18:55 dmiguelez Assigned To Triage Finance => AtulOpenbravo
2019-12-17 12:41 AtulOpenbravo Status new => scheduled
2019-12-20 06:27 AtulOpenbravo Note Added: 0116449
2019-12-20 07:42 AtulOpenbravo Review Assigned To => dmiguelez
2019-12-20 10:27 hgbot Checkin
2019-12-20 10:27 hgbot Note Added: 0116456
2019-12-20 10:27 hgbot Status scheduled => resolved
2019-12-20 10:27 hgbot Resolution open => fixed
2019-12-20 10:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/462c35e38ba5c680442dfcba905e5d3a80e10d68 [^]
2019-12-20 10:28 dmiguelez Note Added: 0116457
2019-12-20 10:28 dmiguelez Status resolved => closed
2019-12-20 10:28 dmiguelez Fixed in Version => 3.0PR20Q1

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker