Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0018753Openbravo ERPZ. Otherspublic2011-06-27 17:542011-10-18 17:31
jaime_chamorro 
eduardo_Argal 
highminoralways
closedfixed 
5
2.50 
2.50MP35 
Advanced Payables and Receivables Mngmt
No
0018753: 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.
blocks defect 0017795 closed eduardo_Argal Not Posted Transaction Report 
Issue History
2011-10-11 13:14eduardo_ArgalTypedefect => backport
2011-10-11 13:14eduardo_Argalfix_in_branch => 2.50
2011-10-13 20:20hgbotCheckin
2011-10-13 20:20hgbotNote Added: 0041817
2011-10-13 20:20hgbotStatusscheduled => resolved
2011-10-13 20:20hgbotResolutionopen => fixed
2011-10-13 20:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/31a7a580101b5b860304ea54ce61fa899e89a37e [^]
2011-10-18 17:31jonalegriaesarteStatusresolved => closed
2011-10-18 17:31jonalegriaesarteFixed in Version => 2.50MP35

Notes
(0041817)
hgbot   
2011-10-13 20:20   
Repository: erp/stable/2.50
Changeset: 31a7a580101b5b860304ea54ce61fa899e89a37e
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Thu Oct 13 20:19:47 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/31a7a580101b5b860304ea54ce61fa899e89a37e [^]

Fixes 18753: Not Posted Transaction Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportAcctRedirectUtility.java
M src/org/openbravo/erpCommon/ad_reports/ReportAcctRedirectUtility_data.xsql
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
---