Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013643
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminoralways2010-06-14 13:402010-07-24 00:00
ReporternetworkbView Statuspublic 
Assigned Tosivaraman 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionb999e4c524c9
ProjectionnoneETAnoneTarget Version2.50MP20
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product Version2.50MP18SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013643: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0012965 closeddalsasua Localization Pack: Spain Not Payed DPs that are over date planned alert is not correct 

-  Notes
(0029057)
hgbot (developer)
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 (reporter)
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 (developer)
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 (developer)
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 (developer)
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 (reporter)
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 (reporter)
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 (reporter)
2010-07-22 16:20
edited on: 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 (reporter)
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 (reporter)
2010-07-23 07:54

 Verified @ live builds context

- Issue History
Date Modified Username Field Change
2010-06-14 13:40 networkb New Issue
2010-06-14 13:40 networkb Assigned To => adrianromero
2010-06-14 13:41 networkb Relationship added related to 0012965
2010-06-16 13:06 adrianromero Status new => scheduled
2010-06-16 13:06 adrianromero fix_in_branch => pi
2010-07-05 13:25 sivaraman Assigned To adrianromero => sivaraman
2010-07-05 13:29 hgbot Checkin
2010-07-05 13:29 hgbot Note Added: 0029057
2010-07-05 13:29 hgbot Status scheduled => resolved
2010-07-05 13:29 hgbot Resolution open => fixed
2010-07-05 13:29 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/885a012ad4b2fadf745afd02cee95843da3c01b1 [^]
2010-07-05 13:40 sivaraman Note Added: 0029060
2010-07-06 08:20 hgbot Checkin
2010-07-06 08:20 hgbot Note Added: 0029077
2010-07-06 08:20 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/885a012ad4b2fadf745afd02cee95843da3c01b1 [^] => http://code.openbravo.com/erp/devel/pi/rev/b999e4c524c95f7e729ee6987d7c39db04c04f19 [^]
2010-07-07 12:38 hudsonbot Checkin
2010-07-07 12:38 hudsonbot Note Added: 0029110
2010-07-07 12:38 hudsonbot Checkin
2010-07-07 12:38 hudsonbot Note Added: 0029113
2010-07-22 11:42 sureshbabu Note Added: 0029466
2010-07-22 13:59 sivaraman Note Added: 0029468
2010-07-22 16:20 sureshbabu Note Added: 0029470
2010-07-22 16:20 sureshbabu Note Edited: 0029470 View Revisions
2010-07-23 07:21 sivaraman Note Added: 0029488
2010-07-23 07:54 sureshbabu Note Added: 0029489
2010-07-23 07:54 sureshbabu Status resolved => closed
2010-07-24 00:00 anonymous sf_bug_id 0 => 3033795

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker