Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012230Openbravo ERP03. Procurement managementpublic2010-02-11 12:382010-03-10 18:29
Reporterdalsasua 
Assigned Torafaroda 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 9.04
Product Versionpi 
Target VersionpiFixed in Version2.50MP12 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012230: not able to void invoices
DescriptionIf you try to void a completed purchase invoice (no matter if posted of not), in Oracle is thrown the error ORA-01403: no data found\\nORA-01403: no data found, and in Postgresql the DATA_EXCEPTION error.
Steps To Reproduce- Login as Openbravo Admin
- Go to Procurement Management || Transactions || Purchase Invoice || Header
- Go to invoice number 10000000
- Void it-> error is shown
- Create a new invoice, add lines, complete
- Void it -> error is shown
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0009520 closed iciordia While voiding an AR invoice or an AP invoice the system should allow the user to change "document date" and "posting date" 
related to defect 0009519 closed rakheemohanlal While voiding an AR invoice or an AP invoice the system shows former "document date" and "posting date" dates 
related to defect 00108072.50MP8 closed rafaroda The documentno on invoices is not unique 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-11 12:38dalsasuaNew Issue
2010-02-11 12:38dalsasuaAssigned To => psarobe
2010-02-11 12:38dalsasuaOBNetwork customer => No
2010-02-11 18:30psarobeAssigned Topsarobe => rafaroda
2010-02-11 18:30psarobePrioritynormal => immediate
2010-02-11 18:30psarobeStatusnew => scheduled
2010-02-15 11:32rafarodaNote Added: 0024257
2010-02-15 11:44rafarodaRelationship addedrelated to 0009520
2010-02-15 11:45rafarodaRelationship addedrelated to 0009519
2010-02-16 12:34rafarodaNote Added: 0024400
2010-02-16 12:55rafarodaRelationship addedrelated to 0010807
2010-02-16 12:56rafarodaNote Added: 0024402
2010-02-16 15:15hgbotCheckin
2010-02-16 15:15hgbotNote Added: 0024415
2010-02-16 15:15hgbotStatusscheduled => resolved
2010-02-16 15:15hgbotResolutionopen => fixed
2010-02-16 15:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7de7c4a6be7eb6b511d2156f5c75b9953af86bf9 [^]
2010-02-17 11:42arunkumarNote Added: 0024473
2010-02-17 11:42arunkumarStatusresolved => closed
2010-02-17 11:42arunkumarFixed in Version => 2.50MP12
2010-02-18 00:01anonymoussf_bug_id0 =>
2010-02-18 00:31hudsonbotCheckin
2010-02-18 00:31hudsonbotNote Added: 0024540
2010-03-10 18:29anonymoussf_bug_id => 2968051

Notes
(0024257)
rafaroda   
2010-02-15 11:32   
If you open the current period, the invoice is voided (reversed) properly.

The problem comes here in the creation and completion of the reversal invoice: "Period not opened" message is not displayed and process continues, leading to a no data found error.
(0024400)
rafaroda   
2010-02-16 12:34   
Issue also happens with the following steps:
* 2010 period is NOT open.
* Create a Sales or Purchase Invoice with a line and try to complete it: ORA-01403: no data found: ERROR
* Create a Goods Shipment or receipt with a line and complete it: The Period does not exist or it is not opened: CORRECT
(0024402)
rafaroda   
2010-02-16 12:56   
The issue is related to the fix of issue 0010807
(0024415)
hgbot   
2010-02-16 15:15   
Repository: erp/devel/pi
Changeset: 7de7c4a6be7eb6b511d2156f5c75b9953af86bf9
Author: Rafa Roda Palacios <rafael.roda <at> openbravo.com>
Date: Tue Feb 16 15:08:01 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7de7c4a6be7eb6b511d2156f5c75b9953af86bf9 [^]

Fixes issue 12230 Check for repeated invoice document nos works also now for non existing periods. Related to issue 10807

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0024473)
arunkumar   
2010-02-17 11:42   
Tested & working fine
(0024540)
hudsonbot   
2010-02-18 00:31   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/7de7c4a6be7e [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7c1b489fb0a0 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16459.obx [^]