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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0020729
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Payment Aging Balance Reportmajoralways2012-06-12 11:382012-06-12 17:05
ReporterngarciaView Statuspublic 
Assigned Tongarcia 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision9c1d10fd609a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0020729: Negative receivables do not appear in the Receivables Aging Schedule report

DescriptionNegative receivables do not appear in the Receivables Aging Schedule report
Steps To ReproduceAs Group Admin Role:
   Go to the "Sales Invoice" screen
   Create a Invoice with a negative amount
   
   Go to the Receivables Aging Inquiry
   Click on the Search button
   Click on the Business Partner link to go to the Receivables Aging Schedule Details
   Notice that the invoice does not appear
Proposed SolutionChange the following line in AgingDAO.java file:

    // orig_paym_scheddetail is not fully paid
    hsqlScript.append(" and ( opsv.outstanding > 0 ");

with the following one:

    // orig_paym_scheddetail is not fully paid
    hsqlScript.append(" and ( opsv.outstanding <> 0 ");

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0049758)
hgbot (developer)
2012-06-12 12:33

Repository: erp/mods/org.openbravo.agingbalance
Changeset: 9c1d10fd609a7f811c6cdafdea32eab64d42da85
Author: Naiara Garcia <naiara.garcia <at> openbravo.com>
Date: Tue Jun 12 12:20:18 2012 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/9c1d10fd609a7f811c6cdafdea32eab64d42da85 [^]

Fixed issue 20729: Negative receivables do not appear in the Receivables Aging Schedule report

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/agingbalance/ad_reports/AgingDao.java
---
(0049777)
dmiguelez (developer)
2012-06-12 17:04

Test Plan:

Login as Openbravo/openbravo

Create a new Sales Invoice.
Organization: F&B US
Business Partner: Moon Light Restaurants
With a Line:
Product: Ale Beer
Invoiced Quantity: -100
And complete it.

Go to the Receivables Aging Inquiry
Organization: F&B US
As of Date: Today
Click on Moon Light Restaurants.

Realize that the Invoice created before is shown in the Detailed version of the Report.

- Issue History
Date Modified Username Field Change
2012-06-12 11:38 ngarcia New Issue
2012-06-12 11:38 ngarcia Assigned To => ngarcia
2012-06-12 12:33 hgbot Checkin
2012-06-12 12:33 hgbot Note Added: 0049758
2012-06-12 12:33 hgbot Status new => resolved
2012-06-12 12:33 hgbot Resolution open => fixed
2012-06-12 12:33 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/9c1d10fd609a7f811c6cdafdea32eab64d42da85 [^]
2012-06-12 12:44 ngarcia Issue Monitored: networkb
2012-06-12 17:04 dmiguelez Note Added: 0049777
2012-06-12 17:05 dmiguelez Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker