0018753: Not Posted Transaction Report

Description

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.

Steps To Reproduce

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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0017795

closed

eduardo_Argal

Not Posted Transaction Report

Notes
(0041817) hgbot (developer) 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 ---

Issue History
Date Modified	Username	Field	Change
2011-10-11 13:14	eduardo_Argal	Type	defect => backport
2011-10-11 13:14	eduardo_Argal	fix_in_branch	=> 2.50
2011-10-13 20:20	hgbot	Checkin
2011-10-13 20:20	hgbot	Note Added: 0041817
2011-10-13 20:20	hgbot	Status	scheduled => resolved
2011-10-13 20:20	hgbot	Resolution	open => fixed
2011-10-13 20:20	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.50/rev/31a7a580101b5b860304ea54ce61fa899e89a37e [^]
2011-10-18 17:31	jonalegriaesarte	Status	resolved => closed
2011-10-18 17:31	jonalegriaesarte	Fixed in Version	=> 2.50MP35