Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0021876Openbravo ERP07. Sales managementpublic2012-10-05 14:102013-02-05 22:44
mirurita 
mirurita 
highminorN/A
closedfixed 
5
 
 
pramakrishnan
Core
No
0021876: It should be possible to filter out (ignore) records in sales/purchase invoice window although they are persisted in database
It 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.

1) 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.

No tags attached.
Issue History
2012-10-05 14:10miruritaNew Issue
2012-10-05 14:10miruritaAssigned To => dmiguelez
2012-10-05 14:10miruritaModules => Core
2012-10-08 12:02miruritaStatusnew => closed
2012-10-08 12:02miruritaResolutionopen => no change required
2013-02-04 10:03miruritaAssigned Todmiguelez => mirurita
2013-02-04 10:03miruritaStatusclosed => new
2013-02-04 10:03miruritaResolutionno change required => open
2013-02-04 10:05miruritaTriggers an Emergency Pack => No
2013-02-04 10:05miruritaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4348#r4348
2013-02-04 11:09hgbotCheckin
2013-02-04 11:09hgbotNote Added: 0056123
2013-02-04 11:09hgbotStatusnew => resolved
2013-02-04 11:09hgbotResolutionopen => fixed
2013-02-04 11:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0de5dae02decb2eef7a4e1b3b3d30bc39b2ac5e1 [^]
2013-02-05 13:10pramakrishnanReview Assigned To => pramakrishnan
2013-02-05 13:10pramakrishnanNote Added: 0056166
2013-02-05 13:10pramakrishnanStatusresolved => closed
2013-02-05 22:44hudsonbotCheckin
2013-02-05 22:44hudsonbotNote Added: 0056190

Notes
(0056123)
hgbot   
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   
2013-02-05 13:10   
Code Review + Testing - OK
(0056190)
hudsonbot   
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