Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013643Openbravo ERP01. General setuppublic2010-06-14 13:402010-07-24 00:00
Reporternetworkb 
Assigned Tosivaraman 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP18 
Target Version2.50MP20Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013643: Not Payed DPs that are over date planned alert is not correct
DescriptionNot Payed DPs that are over date planned alert shows payments that are not over date.

Revising the query, this clausure is not correct:

where trunc(dateplanned) > trunc(now())
Steps To ReproduceGo to Sales Management > Transactions > Sales invoice.
Create a new one, for 01-01-2006.
Create a line.
Complete it.
Enable Alert background process.
Active Not Payed DPs that are over date planned
The previous payment is not shown
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0012965 closed dalsasua Localization Pack: Spain Not Payed DPs that are over date planned alert is not correct 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-14 13:40networkbNew Issue
2010-06-14 13:40networkbAssigned To => adrianromero
2010-06-14 13:41networkbRelationship addedrelated to 0012965
2010-06-16 13:06adrianromeroStatusnew => scheduled
2010-06-16 13:06adrianromerofix_in_branch => pi
2010-07-05 13:25sivaramanAssigned Toadrianromero => sivaraman
2010-07-05 13:29hgbotCheckin
2010-07-05 13:29hgbotNote Added: 0029057
2010-07-05 13:29hgbotStatusscheduled => resolved
2010-07-05 13:29hgbotResolutionopen => fixed
2010-07-05 13:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/885a012ad4b2fadf745afd02cee95843da3c01b1 [^]
2010-07-05 13:40sivaramanNote Added: 0029060
2010-07-06 08:20hgbotCheckin
2010-07-06 08:20hgbotNote Added: 0029077
2010-07-06 08:20hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/885a012ad4b2fadf745afd02cee95843da3c01b1 [^] => http://code.openbravo.com/erp/devel/pi/rev/b999e4c524c95f7e729ee6987d7c39db04c04f19 [^]
2010-07-07 12:38hudsonbotCheckin
2010-07-07 12:38hudsonbotNote Added: 0029110
2010-07-07 12:38hudsonbotCheckin
2010-07-07 12:38hudsonbotNote Added: 0029113
2010-07-22 11:42sureshbabuNote Added: 0029466
2010-07-22 13:59sivaramanNote Added: 0029468
2010-07-22 16:20sureshbabuNote Added: 0029470
2010-07-22 16:20sureshbabuNote Edited: 0029470bug_revision_view_page.php?bugnote_id=0029470#r610
2010-07-23 07:21sivaramanNote Added: 0029488
2010-07-23 07:54sureshbabuNote Added: 0029489
2010-07-23 07:54sureshbabuStatusresolved => closed
2010-07-24 00:00anonymoussf_bug_id0 => 3033795

Notes
(0029057)
hgbot   
2010-07-05 13:29   
Repository: erp/devel/pi
Changeset: 885a012ad4b2fadf745afd02cee95843da3c01b1
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
Date: Mon Jul 05 16:58:51 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/885a012ad4b2fadf745afd02cee95843da3c01b1 [^]

Fixes issue 13643: Not Payed DPs that are over date planned alert is not correct

WHERE clause has been modified in the Alert's SQL in order to display the proper Alerts for Not Payed DPs.

---
M src-db/database/sourcedata/referencedData/AD_ALERTRULE.xml
---
(0029060)
sivaraman   
2010-07-05 13:40   
Steps to test:

1. Log on to Openbravo with 'Openbravo Admin' role
2. Go to Sales Management > Transactions > Sales invoice.
3. Create a new one, for 01-01-2006.
4. Create a line and Complete it.
5. Change role to 'System Administrator' role
6. Go to General Setup || Application || Alert || Alert Rule
7. Activate 'Active Not Payed DPs that are over date planned' alert
8. Add 'System Administrator' as Alert Recipient
9. Go to General Setup || Process Scheduling || Process Request || Process Request
10. Schedule Alert Process
11. Change role to 'System Administrator' role
12. Verify if Alert message is also shown for the above created invoice
(0029077)
hgbot   
2010-07-06 08:20   
Repository: erp/devel/pi
Changeset: b999e4c524c95f7e729ee6987d7c39db04c04f19
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
Date: Tue Jul 06 11:49:54 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/b999e4c524c95f7e729ee6987d7c39db04c04f19 [^]

Fixes issue 13643: Not Payed DPs that are over date planned alert is not correct

---
M src-db/database/sourcedata/referencedData/AD_ALERTRULE.xml
---
(0029110)
hudsonbot   
2010-07-07 12:38   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/885a012ad4b2 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d555a35070ee [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17817.obx [^]
(0029113)
hudsonbot   
2010-07-07 12:38   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/b999e4c524c9 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d555a35070ee [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17817.obx [^]
(0029466)
sureshbabu   
2010-07-22 11:42   
@siva, i am not able to view the sales invoice details in the alert details as you mentioned in the steps to reproduce.

can you check once again
(0029468)
sivaraman   
2010-07-22 13:59   
Steps to test(revised):

1. Log on to Openbravo with 'Openbravo Admin' role
2. Go to Sales Management > Transactions > Sales invoice.
3. Create a new one, for 01-01-2006.
4. Create a line and Complete it.
5. Change role to 'System Administrator' role
6. Go to General Setup || Application || Alert || Alert Rule
7. Activate 'Not Payed DPs that are over date planned' alert
8. Switch to 'Openbravo Admin' role
9. Go to Go to General Setup || Application || Alert || Alert Rule
10. Select 'Not Payed DPs that are over date planned' alert
11. Add 'Openbravo Admin' as Alert Recipient
12. Again change role to 'System Administrator' role
13. Go to General Setup || Process Scheduling || Process Request || Process Request
14. Schedule Alert Process
15. Change role to 'Openbravo Admin' role
16. Verify if Alert message is shown for the above created invoice
(0029470)
sureshbabu   
2010-07-22 16:20   
@Siva, thanks for the detail steps, i would expect you to verify the fix works rightly or not. For me i am not able to view the invoice details in the alert.
(0029488)
sivaraman   
2010-07-23 07:21   
@Suresh, I just followed the above steps (revised) in the live build and found the alert functionality is working fine as expected. Can you please check http://live.builds.openbravo.com/int-full-pgsql/security/Menu.html [^] where i have created three sales invoices dated on 01-01-2006. Along with the old invoices, it shows 33 alerts (as of now). You can add one more invoice and check if alert counts updated.
(0029489)
sureshbabu   
2010-07-23 07:54   
Verified @ live builds context