Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0028156 | Openbravo ERP | 07. Sales management | public | 2014-11-12 12:44 | 2014-12-30 23:27 |
|
| Reporter | egoitz | |
| Assigned To | reinaldoguerra | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | 3.0PR15Q1 | Fixed in Version | pi | |
| Merge Request Status | |
| Review Assigned To | umartirena |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 32132 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0028156: When completing an invoice with grandtotal 0, the ispaid columns is filled with Y but the Finalsettlement is not filled |
| Description | When completing an invoice with grandtotal 0, the ispaid columns is filled with Y but the Finalsettlement is not filled. |
| Steps To Reproduce | -Create a sales invoice header-
-create a line with 1 qty and price 0-.
-Complete
*See that the ispaid columns is filled=Y but Finalsettlement columns is still null.
On that status the invoice is processed by the fin_paymentmonitorprocess on each execution.
that affects the performance. |
| Proposed Solution | Fill the Finalsettlement column with the date where the complete process is executed |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2014-11-12 12:44 | egoitz | New Issue | |
| 2014-11-12 12:44 | egoitz | Assigned To | => dmiguelez |
| 2014-11-12 12:44 | egoitz | OBNetwork customer | => Yes |
| 2014-11-12 12:44 | egoitz | Modules | => Core |
| 2014-11-12 12:44 | egoitz | Triggers an Emergency Pack | => No |
| 2014-11-12 12:45 | egoitz | Support ticket | => 32132 |
| 2014-11-12 12:45 | egoitz | Resolution time | => 1417647600 |
| 2014-11-12 12:45 | egoitz | Target Version | => 3.0PR15Q1 |
| 2014-11-12 12:45 | egoitz | Assigned To | dmiguelez => AtulOpenbravo |
| 2014-12-08 04:20 | reinaldoguerra | Assigned To | AtulOpenbravo => reinaldoguerra |
| 2014-12-08 04:20 | reinaldoguerra | Status | new => scheduled |
| 2014-12-09 13:59 | reinaldoguerra | Note Added: 0072362 | |
| 2014-12-16 18:47 | hgbot | Checkin | |
| 2014-12-16 18:47 | hgbot | Note Added: 0072572 | |
| 2014-12-16 18:47 | hgbot | Status | scheduled => resolved |
| 2014-12-16 18:47 | hgbot | Resolution | open => fixed |
| 2014-12-16 18:47 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/2661c5291828b36aefdc2b3ee09b245b26aee406 [^] |
| 2014-12-16 18:48 | umartirena | Review Assigned To | => umartirena |
| 2014-12-16 18:48 | umartirena | Note Added: 0072573 | |
| 2014-12-16 18:48 | umartirena | Status | resolved => closed |
| 2014-12-16 18:48 | umartirena | Fixed in Version | => pi |
| 2014-12-30 23:27 | hudsonbot | Checkin | |
| 2014-12-30 23:27 | hudsonbot | Note Added: 0073226 | |
|
Notes |
|
|
|
Test plan used:
1- Login into Openbravo ERP
2- Go to sales invoice window and create a new header
3- Create a line with qty 1 and price 0, for example leaving empty product selector field.
4- Complete it
5- Check table c_invoice and note that ispaid field is set to Y and finalsettlement takes the actual date which is when the document is being completed. |
|
|
|
(0072572)
|
|
hgbot
|
|
2014-12-16 18:47
|
|
Repository: erp/devel/pi
Changeset: 2661c5291828b36aefdc2b3ee09b245b26aee406
Author: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
Date: Mon Dec 08 18:15:02 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/2661c5291828b36aefdc2b3ee09b245b26aee406 [^]
Fixed bug 28156: Completing invoice with 0 grandtotal, finalsettlement is null.
Extension point executed when completing invoices stored procedure is finished, was modified to not only update isPaid field as Y, but also to fill the finalsettlement with the current date which is when the document with grandtotal as 0, is being completed.
Now when completing an invoice with grandtotal as 0, also the finalsettlement field will be filled, avoiding the invoice is processed by the fin_paymentmonitorprocess unnecessarily. This change affects purchase and sales flows.
---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
---
|
|
|
|
(0072573)
|
|
umartirena
|
|
2014-12-16 18:48
|
|
|
Code Review and Testing Done. |
|
|
|
|
|