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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0017795
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersminoralways2011-06-27 17:542011-11-09 12:23
Reporterjaime_chamorroView Statuspublic 
Assigned Toeduardo_Argal 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisiond32d0313948c
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50SCM revision 
Review Assigned To
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0017795: Not Posted Transaction Report

DescriptionThe 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.
Steps To ReproduceTo 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0018753 closededuardo_Argal Not Posted Transaction Report 
related to design defect 0019296 closeddmiguelez Not Posted Transaction Report does not take into account Remittance elements 

-  Notes
(0041258)
jonalegriaesarte (reporter)
2011-09-23 11:36

 It will be treated as a feature request in the review of the reports
(0041515)
psanjuan (manager)
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 (manager)
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 (developer)
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 (developer)
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 (developer)
2011-11-04 13:10

 verified
(0042693)
jaime_chamorro (reporter)
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.

- Issue History
Date Modified Username Field Change
2011-06-27 17:54 jaime_chamorro New Issue
2011-06-27 17:54 jaime_chamorro Assigned To => eduardo_Argal
2011-07-04 19:06 maite Priority high => urgent
2011-07-04 19:09 maite Priority urgent => high
2011-07-04 19:09 maite Severity major => minor
2011-07-04 19:10 maite Project Modules => Openbravo ERP
2011-07-04 19:11 maite Modules => Advanced Payables and Receivables Mngmt
2011-07-04 19:11 maite Resolution time => 1316383200
2011-07-04 19:11 maite Category Advance Payables and Receivables - es_ES => Z. Others
2011-09-15 13:32 jonalegriaesarte Assigned To eduardo_Argal => mirurita
2011-09-23 11:36 jonalegriaesarte Note Added: 0041258
2011-09-23 11:36 jonalegriaesarte Type defect => feature request
2011-09-23 11:36 jonalegriaesarte Assigned To mirurita => psanjuan
2011-10-05 17:41 psanjuan Note Added: 0041515
2011-10-05 17:41 psanjuan Assigned To psanjuan => jonalegriaesarte
2011-10-05 17:41 psanjuan Type feature request => defect
2011-10-07 13:31 psanjuan Assigned To jonalegriaesarte => eduardo_Argal
2011-10-07 13:32 psanjuan Note Added: 0041558
2011-10-11 13:14 eduardo_Argal Status new => scheduled
2011-10-11 13:14 eduardo_Argal fix_in_branch => pi
2011-10-13 13:37 hgbot Checkin
2011-10-13 13:37 hgbot Note Added: 0041801
2011-10-13 13:37 hgbot Status scheduled => resolved
2011-10-13 13:37 hgbot Resolution open => fixed
2011-10-13 13:37 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d32d0313948ce85d5c051fff36fa5d725b1ddb01 [^]
2011-10-18 17:26 hudsonbot Checkin
2011-10-18 17:26 hudsonbot Note Added: 0041894
2011-11-04 13:10 maite Note Added: 0042541
2011-11-04 13:10 maite Status resolved => closed
2011-11-09 12:23 jaime_chamorro Note Added: 0042693
2011-12-14 09:54 maite Relationship added related to 0019296

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker