Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0038050Openbravo ERPZ. Otherspublic2018-03-06 10:472018-03-22 15:09
maite 
markmm82 
urgentmajoralways
closedfixed 
5
 
3.0PR18Q2 
dmiguelez
Advanced Payables and Receivables Mngmt
No
0038050: Wrong "Paid in full date" set when a backdated invoice is registered associated to a backdated prepaid order
In 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
1. 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
No tags attached.
Issue History
2018-03-06 10:47maiteNew Issue
2018-03-06 10:47maiteAssigned To => Triage Finance
2018-03-06 10:47maiteModules => Advanced Payables and Receivables Mngmt
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