Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0017795Openbravo ERPZ. Otherspublic2011-06-27 17:542011-11-09 12:23
jaime_chamorro 
eduardo_Argal 
highminoralways
closedfixed 
5
2.50 
 
Advanced Payables and Receivables Mngmt
No
0017795: Not Posted Transaction Report
The Not Posted Transaction Report does not take into account the new APR document that generates accounting: payment in/out, financial account transactions, reconciliation, remittance, and so on.
To reply the bug please follows the following steps in the example:
NOTE: the following example is already reproduced created in the client TEST and PRODUCTIVE environment (version 2.50+MP28). This example is based on the reconciliation document type only.
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
• Purchase Invoice - total amount: 150 €. Transaction and accounting date: 20-06-2011
• Sales Invoice – total amount: 200 € Transaction and accounting date: 20-06-2011
• Create a financial account (matching algorithm configured and just Cleared Payment Account configured for payment in/out accounting configuration.
• Create manually an imported bank statement (tab financial account created) with two bank statement lines:
 Line 1: amount out = 150 € // Transaction date: 20-06-2011
 Line 2: amount in = 200 € // Transaction date: 20-06-2011
Once all these data have been registered into the system follow the following steps:
A. Add Matching Using Imported Bank Statement: transaction Financial Management || Receivables & Payables || Transactions || Financial Account || Account
1. Select the Financial Account created >> Transactions >> Button “Matching Using Imported Bank Statement” >> add the payment out amount 150 € >> “Add Transaction” pop-up and filter by: Transaction Type: Payment In/out
 Transaction Date: by default
 Document: Paid out
2. Press button “Add Payment in/out” >> “Add Payment in/out” pop-up and filter to look for the purchase invoice created >> select the purchase invoiced created (150 €). Press ok.
3. Financial Account CAIXA >> Transactions >> Button “Matching Using Imported Bank Statement” >> add the payment in amount 200 € >> “Add Transaction” pop-up and filter by: Transaction Type: Payment In/out
 Transaction Date: by default
 Document: Received in
4. Press button “Add Payment in/out” >> “Add Payment in/out” pop-up and filter to look for the sales invoice created >> select the sales invoiced created (200 €). Press ok.
5. Save both lined matched and press button “Reconcile”.
B. Reconciliation Posting Process: transaction Financial Management || Receivables & Payables || Transactions || Financial Account || Account >> Reconciliation tab
1. Select the proper document no. reconciliatio. As you can check the reconciliation document is process but no posted yet.
2. Check the Not Posted Transaction Report for the period: from 01-06-2011 until today’s day. There is not any reference to the document reconciliation above.
No tags attached.
depends on backport 0018753 closed eduardo_Argal Not Posted Transaction Report 
related to design defect 0019296 closed dmiguelez Not Posted Transaction Report does not take into account Remittance elements 
Issue History
2011-06-27 17:54jaime_chamorroNew Issue
2011-06-27 17:54jaime_chamorroAssigned To => eduardo_Argal
2011-07-04 19:06maitePriorityhigh => urgent
2011-07-04 19:09maitePriorityurgent => high
2011-07-04 19:09maiteSeveritymajor => minor
2011-07-04 19:10maiteProjectModules => Openbravo ERP
2011-07-04 19:11maiteModules => Advanced Payables and Receivables Mngmt
2011-07-04 19:11maiteResolution time => 1316383200
2011-07-04 19:11maiteCategoryAdvance Payables and Receivables - es_ES => Z. Others
2011-09-15 13:32jonalegriaesarteAssigned Toeduardo_Argal => mirurita
2011-09-23 11:36jonalegriaesarteNote Added: 0041258
2011-09-23 11:36jonalegriaesarteTypedefect => feature request
2011-09-23 11:36jonalegriaesarteAssigned Tomirurita => psanjuan
2011-10-05 17:41psanjuanNote Added: 0041515
2011-10-05 17:41psanjuanAssigned Topsanjuan => jonalegriaesarte
2011-10-05 17:41psanjuanTypefeature request => defect
2011-10-07 13:31psanjuanAssigned Tojonalegriaesarte => eduardo_Argal
2011-10-07 13:32psanjuanNote Added: 0041558
2011-10-11 13:14eduardo_ArgalStatusnew => scheduled
2011-10-11 13:14eduardo_Argalfix_in_branch => pi
2011-10-13 13:37hgbotCheckin
2011-10-13 13:37hgbotNote Added: 0041801
2011-10-13 13:37hgbotStatusscheduled => resolved
2011-10-13 13:37hgbotResolutionopen => fixed
2011-10-13 13:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d32d0313948ce85d5c051fff36fa5d725b1ddb01 [^]
2011-10-18 17:26hudsonbotCheckin
2011-10-18 17:26hudsonbotNote Added: 0041894
2011-11-04 13:10maiteNote Added: 0042541
2011-11-04 13:10maiteStatusresolved => closed
2011-11-09 12:23jaime_chamorroNote Added: 0042693
2011-12-14 09:54maiteRelationship addedrelated to 0019296

Notes
(0041258)
jonalegriaesarte   
2011-09-23 11:36   
It will be treated as a feature request in the review of the reports
(0041515)
psanjuan   
2011-10-05 17:41   
this is not a feature request but a defect. APRM related transactions should also be taken into account.
(0041558)
psanjuan   
2011-10-07 13:32   
This report will support just Core Documents, as it is a Core report, therefore Remittances documents are out of scope.
(0041801)
hgbot   
2011-10-13 13:37   
Repository: erp/devel/pi
Changeset: d32d0313948ce85d5c051fff36fa5d725b1ddb01
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Oct 13 13:34:49 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d32d0313948ce85d5c051fff36fa5d725b1ddb01 [^]

Fixes issue 17795: Not Posted Transaction Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportNotPosted.html
M src/org/openbravo/erpCommon/ad_reports/ReportNotPosted.java
M src/org/openbravo/erpCommon/ad_reports/ReportNotPosted.xml
M src/org/openbravo/erpCommon/ad_reports/ReportNotPosted_data.xsql
---
(0041894)
hudsonbot   
2011-10-18 17:26   
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/3a0e09f510aa [^]

Maturity status: Test
(0042541)
maite   
2011-11-04 13:10   
verified
(0042693)
jaime_chamorro   
2011-11-09 12:23   
I have already checked that the link for the new documents (reconciliation at least) does not working properly. The following error apears:

HTTP Status 404 - /openbravo/FinancialAccount/ReconciliationsoldC095D2CC39704DBE8B906B7CD7710968_Relation.html

Type Status report

message /openbravo/FinancialAccount/ReconciliationsoldC095D2CC39704DBE8B906B7CD7710968_Relation.html

description The requested resource (/openbravo/FinancialAccount/ReconciliationsoldC095D2CC39704DBE8B906B7CD7710968_Relation.html) is not available.
Apache Tomcat/6.0.32

To replicate it just link into the reconciliation doc that it appears in the report.