Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012466Openbravo ERP09. Financial managementpublic2010-02-25 10:532010-05-18 12:12
Reporternetworkb 
Assigned Tobalamurugan 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP17Fixed in Version2.50MP15 
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
Summary0012466: Not Posted Transaction Report groups bankstatement with same name and amount
DescriptionIf we have 2 different bank statements with same name and amount and we run Not Posted Transaction Report, they appear grouped as one bank statement (instead of 2)

You must unschedule the Acct Server Process
Steps To Reproduce0.Go to General Setup || Process Scheduling || Process Request
select Acct Server Process and click 'Unschedule Process'

1. Sales Management || Transactions || Sales Invoice: create 2 sales invoice with same amount and complete it. (2 identical payments will be created)
2. Financial Management || Receivables & Payables || Transactions || Bank Statement: create 2 new records with same name, press "Create lines From" and set one of the previous payments to each of them.
Process the bank statement.
Realize that the two bank statement are Unposted.
3. Financial Management || Accounting || Analysis Tools || Not Posted Transaction Report: run report and realize that only one bank statement appear.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Not Posted Transaction Report.png (101,601) 2010-04-08 12:09
https://issues.openbravo.com/file_download.php?file_id=2415&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-02-25 10:53networkbNew Issue
2010-02-25 10:53networkbAssigned To => dalsasua
2010-03-08 16:05jpabloaeTarget Version2.50MP14 => 2.50MP15
2010-04-06 14:41balamuruganAssigned Todalsasua => balamurugan
2010-04-06 15:04balamuruganNote Added: 0025902
2010-04-06 15:04balamuruganAssigned Tobalamurugan => networkb
2010-04-06 15:04balamuruganStatusnew => feedback
2010-04-08 12:07balamuruganNote Added: 0025973
2010-04-08 12:07balamuruganStatusfeedback => closed
2010-04-08 12:07balamuruganResolutionopen => unable to reproduce
2010-04-08 12:08balamuruganStatusclosed => new
2010-04-08 12:08balamuruganResolutionunable to reproduce => open
2010-04-08 12:09balamuruganFile Added: Not Posted Transaction Report.png
2010-04-08 12:09balamuruganStatusnew => closed
2010-04-08 12:09balamuruganResolutionopen => unable to reproduce
2010-04-08 17:35networkbAssigned Tonetworkb => balamurugan
2010-04-08 17:35networkbStatusclosed => new
2010-04-08 17:35networkbResolutionunable to reproduce => open
2010-04-08 17:39networkbNote Added: 0025993
2010-04-08 17:39networkbDescription Updatedbug_revision_view_page.php?rev_id=216#r216
2010-04-08 17:39networkbSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=218#r218
2010-04-08 17:39networkbDescription Updatedbug_revision_view_page.php?rev_id=219#r219
2010-04-09 10:58hgbotCheckin
2010-04-09 10:58hgbotNote Added: 0026018
2010-04-09 10:58hgbotStatusnew => resolved
2010-04-09 10:58hgbotResolutionopen => fixed
2010-04-09 10:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3df698af8adaba6c8623d21256f645e10b7daba2 [^]
2010-04-15 16:45psarobeNote Added: 0026275
2010-04-15 16:45psarobeStatusresolved => closed
2010-04-15 16:45psarobeFixed in Version => 2.50MP15
2010-04-16 00:00anonymoussf_bug_id0 => 2987958
2010-04-19 21:13hudsonbotCheckin
2010-04-19 21:13hudsonbotNote Added: 0026441
2010-05-18 12:12gorka_gilTarget Version2.50MP15 => 2.50MP17

Notes
(0025902)
balamurugan   
2010-04-06 15:04   
The Existing system is working as expected. As automatic invoice posting is happened after completing the invoice. so, the user could not see the records. After unscheduling the Acct Server process, we could able to see the unposted records.
(0025973)
balamurugan   
2010-04-08 12:07   
The Existing system is working as expected. As automatic invoice posting is happened after completing the invoice. so, the user could not see the records. After unscheduling the Acct Server process, we could able to see the unposted records. Please see the screenshot attached.
(0025993)
networkb   
2010-04-08 17:39   
You must unschedule the Acct Server Process and you must realize that the Bank Statement are unposted.
(0026018)
hgbot   
2010-04-09 10:58   
Repository: erp/devel/pi
Changeset: 3df698af8adaba6c8623d21256f645e10b7daba2
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Fri Apr 09 14:39:57 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/3df698af8adaba6c8623d21256f645e10b7daba2 [^]

Fixes Issue 12466: Not Posted Transaction Report doesn't show the records.

---
M src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql
---
(0026275)
psarobe   
2010-04-15 16:45   
Tested working fine
(0026441)
hudsonbot   
2010-04-19 21:13   
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/3df698af8ada [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]