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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0021876
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 07. Sales managementminorN/A2012-10-05 14:102013-02-05 22:44
ReportermiruritaView Statuspublic 
Assigned Tomirurita 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision0de5dae02dec
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Topramakrishnan
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021876: It should be possible to filter out (ignore) records in sales/purchase invoice window although they are persisted in database

DescriptionIt should be possible to ignore (do not display) records in sales/purchase invoice window although they are persisted in database.

In a invoicing process where the user should be able to preview/validate/update the invoices that are going to be generated (there is a validation step) it is very useful to use c_invoice table to store these temporal invoices (you take advantage of all the trigger, tax calculation, gross amount calculation...).

The problem with the previous approach is that the temporal invoices will be displayed in sales/purchase invoice windows mixed with "no temporal" (real) invoices.

Steps To Reproduce1) Create a new invoice (purchase or sales)
2) Update (through database) docstatus = 'TEMP'
3) Go to sales/purchase invoice window and clear all filters.
4) The invoice should not be displayed.
5) Go to business partner info window and check that the previous invoices are not displayed.
6) Go to Invoice Details report and check that the previous invoices are not displayed.

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0056123)
hgbot (developer)
2013-02-04 11:09

Repository: erp/devel/pi
Changeset: 0de5dae02decb2eef7a4e1b3b3d30bc39b2ac5e1
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Mon Feb 04 11:07:21 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0de5dae02decb2eef7a4e1b3b3d30bc39b2ac5e1 [^]

Fixes issue 21876: ignore temporal sales/purchase invoices.
In a invoicing process where the user should be able to preview/validate/update the invoices
that are going to be generated (there is a validation step) it is very useful to use c_invoice
table to store these temporal invoices (you take advantage of all the trigger, tax calculation,
gross amount calculation...).

New document status created: TEMP
Modified sales/purchase invoice tab where clauses
Modified Business Partner Info >> Partner Invoices tab where clause
Temporal invoices filtered out in Invoice Detail report

---
M src-db/database/sourcedata/AD_REF_LIST.xml
M src-db/database/sourcedata/AD_TAB.xml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql
---
(0056166)
pramakrishnan (developer)
2013-02-05 13:10

Code Review + Testing - OK
(0056190)
hudsonbot (developer)
2013-02-05 22:44

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/86db3ad54671 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2012-10-05 14:10 mirurita New Issue
2012-10-05 14:10 mirurita Assigned To => dmiguelez
2012-10-05 14:10 mirurita Modules => Core
2012-10-08 12:02 mirurita Status new => closed
2012-10-08 12:02 mirurita Resolution open => no change required
2013-02-04 10:03 mirurita Assigned To dmiguelez => mirurita
2013-02-04 10:03 mirurita Status closed => new
2013-02-04 10:03 mirurita Resolution no change required => open
2013-02-04 10:05 mirurita Triggers an Emergency Pack => No
2013-02-04 10:05 mirurita Steps to Reproduce Updated View Revisions
2013-02-04 11:09 hgbot Checkin
2013-02-04 11:09 hgbot Note Added: 0056123
2013-02-04 11:09 hgbot Status new => resolved
2013-02-04 11:09 hgbot Resolution open => fixed
2013-02-04 11:09 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0de5dae02decb2eef7a4e1b3b3d30bc39b2ac5e1 [^]
2013-02-05 13:10 pramakrishnan Review Assigned To => pramakrishnan
2013-02-05 13:10 pramakrishnan Note Added: 0056166
2013-02-05 13:10 pramakrishnan Status resolved => closed
2013-02-05 22:44 hudsonbot Checkin
2013-02-05 22:44 hudsonbot Note Added: 0056190


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker