|View Issue Details|
|Type||Category||Severity||Reproducibility||Date Submitted||Last Update|
|defect||[Openbravo ERP] 09. Financial management||major||always||2011-06-27 19:16||2011-08-12 13:41|
|Priority||high||Resolution||fixed||Fixed in Version|
|Status||closed||Fix in branch||Fixed in SCM revision||add1c452cbb9|
|OS Version||Database version||Ant version|
|Product Version||2.50||SCM revision|
|Review Assigned To|
|Regression introduced in release|
|Regression introduced by commit|
|Triggers an Emergency Pack||No|
0017797: Payment Report: wrong subtotal amounts by status
|Description||The Payment Report does not add up properly at subtotal level for the same status. In fact, the report does not differentiate between payments in and out for the same status.|
After checking the corresponding wiki information (http://wiki.openbravo.com/wiki/Projects/PaymentReport/User_Documentation#Sub_Totals [^]) we have detected that there are the same status for both payments in and out. So, the report should differentiate the document type when there is a subtotal.
|Steps To Reproduce||To reply the bug please follows the following steps in the example:|
NOTE: the following example is already created in the client TEST and PRODUCTIVE environment version 2.50+MP28.
Create the following data:
• Payment Method to use: Write transfer (same configuration for payment in/out):
Payment In Allowed: marked
Execution Type: Manual
Upon Reconciliation Use: Cleared Payment Account
• Business partner both: customer and vendor.
• Purchase Invoice - total amount: 150 €. Transaction and accounting date: 20-06-2011
• Sales Invoice – total amount: 200 € Transaction and accounting date: 20-06-2011
Once all these data have been registered into the system follow the following steps:
A. Financial Management || Receivables & Payables || Analysis Tools || Payment Report || Payment Report
1. Filter by:
Organization: the regarding one
Business partner: the created above.
Cover to currency: the regarding to the invoices created
Payment type: receivables and payables
Ordering criteria: by date
2. Press button “Search” >> see attached the result:
3. Subtotal Awaiting Payment: once is a sales invoice (354,43 €) and the other is a purchase invoice (117,00 €). However, there is not possible to differentiate both. There should be a column to differentiate if it is a payment in or out. The subtotal for this status should be the subtraction but not the sum.
4. The same happens with other status like Subtotal Remittance in this example: as you can check in this example these remittance payments are AP Payments. Therefore, the subtotal should have to take into account the document type.
|Proposed Solution||The subtotal should have to take into account the document type. The subtotal for an specific status should be the subtraction but not the sum base on the document type.|
Finally, is the Grand Total amount should differentiate to amounts: payment in and payment out. This way, there final result should have sense.
|Tags||No tags attached.|
|Attached Files||Subtotal Payment Report.bmp [^] (2,219,234 bytes) 2011-06-27 19:16|
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Fri Jul 08 13:57:53 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/add1c452cbb91b8504b5a9844126ca015821a0b7 [^]
Fixes issue 17797: Payment Report: wrong subtotal amounts by status.
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.
Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/cf2afed6e8ef [^]
Maturity status: Test
|2011-06-27 19:16||jaime_chamorro||New Issue|
|2011-06-27 19:16||jaime_chamorro||Assigned To||=> mirurita|
|2011-06-27 19:16||jaime_chamorro||File Added: Subtotal Payment Report.bmp|
|2011-06-30 18:52||mirurita||Assigned To||mirurita => ioritzCia|
|2011-07-04 18:22||maite||Priority||high => immediate|
|2011-07-04 18:22||maite||Severity||major => critical|
|2011-07-08 14:10||ioritzCia||Project||Modules => Openbravo ERP|
|2011-07-08 14:12||ioritzCia||Modules||=> Payment Report|
|2011-07-08 14:12||ioritzCia||Category||Payment Report => 09. Financial management|
|2011-07-08 14:13||ioritzCia||Status||new => scheduled|
|2011-07-08 14:13||ioritzCia||fix_in_branch||=> pi|
|2011-07-11 09:58||dalsasua||Priority||immediate => high|
|2011-07-11 09:58||dalsasua||Severity||critical => major|
|2011-07-11 09:58||dalsasua||fix_in_branch||pi =>|
|2011-07-11 18:55||hgbot||Note Added: 0039000|
|2011-07-11 18:55||hgbot||Status||scheduled => resolved|
|2011-07-11 18:55||hgbot||Resolution||open => fixed|
|2011-07-11 18:55||hgbot||Fixed in SCM revision||=> http://code.openbravo.com/erp/devel/pi/rev/add1c452cbb91b8504b5a9844126ca015821a0b7 [^]|
|2011-08-01 14:19||hudsonbot||Note Added: 0039587|
|2011-08-12 13:41||maite||Note Added: 0040164|
|2011-08-12 13:41||maite||Status||resolved => closed|
|Copyright © 2000 - 2009 MantisBT Group|