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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0011097
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2009-10-22 17:502011-10-28 12:57
ReporterOlliJTView Statuspublic 
Assigned Tovmromanos 
PriorityhighResolutionout of dateFixed in Versionpi
StatusclosedFix in branch2.40Fixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.40MP10SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011097: Error in handling write-offs when cancelling payments in settlement

DescriptionIf the write-off is left empty, processing of the settlement fails. Follow the steps.
Steps To Reproduce1. Create a new settlement.
2. Open the pop-up window to select payments to cancel.
3. Select a payment and make the write-off field empty.
4. Create a corresponding payment in the created side.
5. Try to process the settlement.

The last step fails because the write-off field of the canceled payment is empty, which is not taken into account by the procedure.
Proposed SolutionChange in one row in the c_settlement_post function.

Original:
SELECT COALESCE(SUM(C_Currency_Round( C_Currency_Convert((Amount - WriteOffAmt), C_Currency_ID, v_Currency, v_Date, NULL, v_AD_Client_ID, v_AD_Org_ID), v_Currency, NULL)), 0),

Fixed:
 SELECT COALESCE(SUM(C_Currency_Round( C_Currency_Convert((Amount - COALESCE(WriteOffAmt, 0)), C_Currency_ID, v_Currency, v_Date, NULL, v_AD_Client_ID, v_AD_Org_ID), v_Currency, NULL)), 0),
     
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0011095 closedvmromanos Error in handling write-offs when cancelling payments in settlement 

-  Notes
(0042223)
dmitry_mezentsev (developer)
2011-10-28 12:57

Openbravo provides community support only for the latest Openbravo version, which is Openbravo 3. This version has significantly improved financial flow and this issue is not present there. Upgrade path from Openbravo 2.50 to latest Openbravo version is available so we recommend to upgrade your instance to get this issue fixed.

Life cycle guarantee (backporting bug fixes to the previos to latest releases (Openbravo 2.40, 2.50)) is available for Professional Edition subscribers only. Please register your ticket through Openbravo Support Portal (http://support.openbravo.com/ [^]) if you have valid Professional subscription.

You can find more details about our Support policy in the following blog post
http://paolojuvara.blogspot.com/2009/12/maintenance-policy-for-openbravo-250.html [^]

- Issue History
Date Modified Username Field Change
2009-10-23 06:54 rafaroda Type defect => backport
2009-10-23 06:54 rafaroda fix_in_branch => 2.40
2011-10-28 12:57 dmitry_mezentsev Note Added: 0042223
2011-10-28 12:57 dmitry_mezentsev Status scheduled => closed
2011-10-28 12:57 dmitry_mezentsev Resolution open => out of date
2011-10-28 12:57 dmitry_mezentsev Fixed in Version => pi


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker