Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014234Openbravo ERP09. Financial managementpublic2010-08-18 13:262010-09-15 00:00
Reporterdalsasua 
Assigned Tosathiyan 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 9.04
Product Versionpi 
Target Version2.50MP22Fixed 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
Summary0014234: Grouping in Journal is not correct.
DescriptionIf an entry has got two lines with same account, description, and same amounts (but one line in debit column, and the other one in credit column), it groups both lines in one only.
Steps To Reproduce- Go To Financial Management || Receivables & Payables || Transactions || Manual Settlement || Manual Settlement
- Create and save a new record
- Go to Financial Management || Receivables & Payables || Transactions || Manual Settlement || Manual Settlement >> Create Payment
- Create a new record
- Set BP=McGiver, and amount = 100, Direct Posting='Y', "Remuneraciones pendientes de Pago" as G/L Item
- Go to Financial Management || Receivables & Payables || Transactions || Manual Settlement || Manual Settlement >> Create Payment >> Balance Payment
- Set credit amount = 100, and "Remuneraciones pendientes de Pago" as G/L Item
- Go back to Financial Management || Receivables & Payables || Transactions || Manual Settlement || Manual Settlement
- Process and Post. The entry obtained is the shown in the attached file: one only line with amount 0, instead of two lines: one with 100 in the debit, and another one with 100 in the credit.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00133142.50MP20 closed sathiyan Error when posting an invoice with negative line amount 
Attached Filespng Pantallazo-Openbravo - Mozilla Firefox.png (208,110) 2010-08-23 09:05
https://issues.openbravo.com/file_download.php?file_id=2892&type=bug
png

png Pantallazo-Openbravo - Mozilla Firefox-1.png (182,737) 2010-08-23 09:17
https://issues.openbravo.com/file_download.php?file_id=2893&type=bug
png

png Pantallazo-Openbravo - Mozilla Firefox-2.png (166,557) 2010-08-23 09:17
https://issues.openbravo.com/file_download.php?file_id=2894&type=bug
png

png document is rightly posted.PNG (57,562) 2010-09-14 08:52
https://issues.openbravo.com/file_download.php?file_id=3075&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-08-18 13:26dalsasuaNew Issue
2010-08-18 13:26dalsasuaAssigned To => sathiyan
2010-08-19 12:45sathiyanStatusnew => scheduled
2010-08-19 12:45sathiyanfix_in_branch => pi
2010-08-21 15:06hgbotCheckin
2010-08-21 15:06hgbotNote Added: 0030209
2010-08-21 15:06hgbotStatusscheduled => resolved
2010-08-21 15:06hgbotResolutionopen => fixed
2010-08-21 15:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d08feaca26c753c592e7f87d418c72f8b84e517f [^]
2010-08-23 09:04dalsasuaNote Added: 0030212
2010-08-23 09:04dalsasuaStatusresolved => new
2010-08-23 09:04dalsasuaResolutionfixed => open
2010-08-23 09:05dalsasuaStatusnew => scheduled
2010-08-23 09:05dalsasuaFile Added: Pantallazo-Openbravo - Mozilla Firefox.png
2010-08-23 09:17dalsasuaFile Added: Pantallazo-Openbravo - Mozilla Firefox-1.png
2010-08-23 09:17dalsasuaFile Added: Pantallazo-Openbravo - Mozilla Firefox-2.png
2010-08-25 07:09hudsonbotCheckin
2010-08-25 07:09hudsonbotNote Added: 0030274
2010-08-25 10:27dalsasuaRelationship addedrelated to 0013314
2010-08-30 18:38hgbotCheckin
2010-08-30 18:38hgbotNote Added: 0030478
2010-08-30 18:38hgbotStatusscheduled => resolved
2010-08-30 18:38hgbotResolutionopen => fixed
2010-08-30 18:38hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/d08feaca26c753c592e7f87d418c72f8b84e517f [^] => http://code.openbravo.com/erp/devel/pi/rev/9e0be3238aaf9afeb02335623eddfeca5e14bd77 [^]
2010-08-30 18:41dalsasuaNote Added: 0030479
2010-09-07 09:17hudsonbotCheckin
2010-09-07 09:17hudsonbotNote Added: 0030704
2010-09-14 08:51sureshbabuNote Added: 0031018
2010-09-14 08:51sureshbabuStatusresolved => closed
2010-09-14 08:52sureshbabuFile Added: document is rightly posted.PNG
2010-09-15 00:00anonymoussf_bug_id0 => 3066285

Notes
(0030209)
hgbot   
2010-08-21 15:06   
Repository: erp/devel/pi
Changeset: d08feaca26c753c592e7f87d418c72f8b84e517f
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Sat Aug 21 18:35:56 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/d08feaca26c753c592e7f87d418c72f8b84e517f [^]

Fixes Issue 14234 : Grouping in Journal is not correct

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql
---
(0030212)
dalsasua   
2010-08-23 09:04   
It seems it's not correctly fixed. Please have a look to Settlement with Document No 10011: it's not correctly posted. (See attached images)
(0030274)
hudsonbot   
2010-08-25 07:09   
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/d08feaca26c7 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/8a6a35fc0751 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18218.obx [^]
(0030478)
hgbot   
2010-08-30 18:38   
Repository: erp/devel/pi
Changeset: 9e0be3238aaf9afeb02335623eddfeca5e14bd77
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Aug 30 18:37:36 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/9e0be3238aaf9afeb02335623eddfeca5e14bd77 [^]

Fixes issue 14234
Restored previous behavior of the report

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql
---
(0030479)
dalsasua   
2010-08-30 18:41   
User must use the flag "Allow negatives", and un-flag it, to experience expected behavior.
(0030704)
hudsonbot   
2010-09-07 09:17   
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/9e0be3238aaf [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/4390fe5213a4 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18274.obx [^]
(0031018)
sureshbabu   
2010-09-14 08:51   
After i unchecked the "Allow negatives" flag, when i post the manual settlement the general entries are

(Dr)46500 Remuneraciones pendientes de pago 100.00
(Cr)46500 Remuneraciones pendientes de pago 100.00

Also i have attached the screen shot for the same