Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027387ModulesPayment Aging Balance Reportpublic2014-08-20 13:002014-10-14 13:45
Reporterngarcia 
Assigned Toreinaldoguerra 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Tovmromanos
Support ticket
OBNetwork customer
Regression introduced in release
Summary0027387: Generated credits are not shown in the report
DescriptionGenerated credits are not shown in the report, as the fin_payment_scheduledetail line is set as isinvoicepaid = 'N'
Steps To ReproduceAs group admin role:
   Create a Payment In leaving the amount to be used later
   Launch the Receivables Aging Schedule for a date higher or equal the payment date and check the amount is not shown in the Credits column
Proposed SolutionCheck the createObCriteria function of the AgingDao.java file
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0027388 closed AtulOpenbravo Wrong amount shown in Credits column if the credit is used in a payment with more than one line 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-20 13:00ngarciaNew Issue
2014-08-20 13:00ngarciaAssigned To => jonalegriaesarte
2014-08-20 13:00ngarciaResolution time => 1411336800
2014-08-20 13:00ngarciaIssue Monitored: networkb
2014-08-20 13:07ngarciaRelationship addedblocks 0027388
2014-08-20 13:14ngarciaProposed Solution updated
2014-09-01 16:38jonalegriaesarteAssigned Tojonalegriaesarte => AtulOpenbravo
2014-10-07 00:28reinaldoguerraAssigned ToAtulOpenbravo => reinaldoguerra
2014-10-07 00:28reinaldoguerraStatusnew => scheduled
2014-10-07 00:31reinaldoguerraNote Added: 0070757
2014-10-14 13:44hgbotCheckin
2014-10-14 13:44hgbotNote Added: 0070923
2014-10-14 13:44hgbotStatusscheduled => resolved
2014-10-14 13:44hgbotResolutionopen => fixed
2014-10-14 13:44hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/511bd6b76398affde48f68f426bf22ed790270ce [^]
2014-10-14 13:45vmromanosReview Assigned To => vmromanos
2014-10-14 13:45vmromanosNote Added: 0070924
2014-10-14 13:45vmromanosStatusresolved => closed

Notes
(0070757)
reinaldoguerra   
2014-10-07 00:31   
Test plan used:
1- Login into Openbravo ERP
2- Create a Payment In leaving the amount to be used later
3- Launch the Receivables Aging Schedule for a date higher or equal the payment date and check the amount is shown in the Credits column.
(0070923)
hgbot   
2014-10-14 13:44   
Repository: erp/mods/org.openbravo.agingbalance
Changeset: 511bd6b76398affde48f68f426bf22ed790270ce
Author: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
Date: Tue Oct 07 22:41:41 2014 -0500
URL: http://code.openbravo.com/erp/mods/org.openbravo.agingbalance/rev/511bd6b76398affde48f68f426bf22ed790270ce [^]

Fixed bug 27387: Generated credits are not shown in the report.

createObCriteria query of AgingDao was modified to obtains FIN_Payment_ScheduleDetail records with invoicePaymentSchedule field as null and invoicePaid flag as 'N'.
Then when a credit is generated for a payment in, Receivables Aging Schedule report shows the credit column as the payment is not related with a particular invoice.

---
M src/org/openbravo/agingbalance/ad_reports/AgingDao.java
---
(0070924)
vmromanos   
2014-10-14 13:45   
Code review + testing OK

Published new module version 3.1.35