Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038050Openbravo ERPZ. Otherspublic2018-03-06 10:472018-03-22 15:09
Reportermaite 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q2 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket539
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038050: Wrong "Paid in full date" set when a backdated invoice is registered associated to a backdated prepaid order
DescriptionIn case backdated sales order is registered and prepaid, when related backdated sales invoice is completed field "Paid in full date" is set to today instead of to payment's date
Steps To Reproduce1. Register Sales Order setting date of one month ago and Invoice Terms=Immediate. Add any line and process
2. Run Add Payment process setting date of one month ago and prepaid the order
3. Register Sales Invoice setting date of one month ago. Run "Create lines from" process and select previous order. Process invoice and realize that it is properly set as Paid but "Paid in full date" has been set to today's date instead of one month ago
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-03-06 10:47maiteNew Issue
2018-03-06 10:47maiteAssigned To => Triage Finance
2018-03-06 10:47maiteOBNetwork customer => Yes
2018-03-06 10:47maiteModules => Advanced Payables and Receivables Mngmt
2018-03-06 10:47maiteSupport ticket => 539
2018-03-06 10:47maiteResolution time => 1522101600
2018-03-06 10:47maiteTriggers an Emergency Pack => No
2018-03-06 10:47maiteIssue Monitored: networkb
2018-03-06 12:23dmiguelezAssigned ToTriage Finance => markmm82
2018-03-06 15:53markmm82Statusnew => acknowledged
2018-03-07 16:41markmm82Statusacknowledged => scheduled
2018-03-12 21:47markmm82Note Added: 0103172
2018-03-22 08:29hgbotCheckin
2018-03-22 08:29hgbotNote Added: 0103406
2018-03-22 08:29hgbotStatusscheduled => resolved
2018-03-22 08:29hgbotResolutionopen => fixed
2018-03-22 08:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8486f723f504f0ff9b55089a831f368cc6cdf499 [^]
2018-03-22 08:29hgbotCheckin
2018-03-22 08:29hgbotNote Added: 0103407
2018-03-22 08:30dmiguelezReview Assigned To => dmiguelez
2018-03-22 08:30dmiguelezNote Added: 0103408
2018-03-22 08:30dmiguelezStatusresolved => closed
2018-03-22 08:30dmiguelezFixed in Version => 3.0PR18Q2
2018-03-22 15:09hudsonbotCheckin
2018-03-22 15:09hudsonbotNote Added: 0103432
2018-03-22 15:09hudsonbotCheckin
2018-03-22 15:09hudsonbotNote Added: 0103433

Notes
(0103172)
markmm82   
2018-03-12 21:47   
Test Plan:
1. Register Sales Order setting date of one month ago, for instance = 12-02-2018 and Invoice Terms=Immediate. Add any line and process
2. Run Add Payment process setting date of one month ago, for instance = 15-02-2018 and prepaid the order
3. Register Sales Invoice setting date of one month ago. Run "Create lines from" process and select previous order. Process invoice and realize that it is properly set as Paid and "Paid in full date" has been set to 15-02-2018 as it was the last payment date for the prepaid order.
(0103406)
hgbot   
2018-03-22 08:29   
Repository: erp/devel/pi
Changeset: 8486f723f504f0ff9b55089a831f368cc6cdf499
Author: Mark <markmm82 <at> gmail.com>
Date: Mon Mar 12 16:40:55 2018 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/8486f723f504f0ff9b55089a831f368cc6cdf499 [^]

Fixes issue 38050: Wrong "Paid in full date" set when a backdated invoice
is registered associated to a backdated prepaid order

If the invoice is registered associated to a backdated prepaid order and it is
paid, then "Paid in full date" is updated with the last payment date instead of
the date in wich the invoice is processed.

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
---
(0103407)
hgbot   
2018-03-22 08:29   
Repository: erp/devel/pi
Changeset: 479d562459f98ed6f495da26367e02f39aa2da2f
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Mar 21 18:52:01 2018 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/479d562459f98ed6f495da26367e02f39aa2da2f [^]

Related to Issue 38050. Changed query to retrieve last payment date
for an Invoice to follow the same logic as in Java
(FIN_AddPayment.getFinalSettlementDate())

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
---
(0103408)
dmiguelez   
2018-03-22 08:30   
Code Review + Testing Ok
(0103432)
hudsonbot   
2018-03-22 15:09   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/3e905f6a2434 [^]
Maturity status: Test
(0103433)
hudsonbot   
2018-03-22 15:09   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/3e905f6a2434 [^]
Maturity status: Test