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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012230
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2010-02-11 12:382010-03-10 18:29
ReporterdalsasuaView Statuspublic 
Assigned Torafaroda 
PriorityimmediateResolutionfixedFixed in Version2.50MP12
StatusclosedFix in branchFixed in SCM revision7de7c4a6be7e
ProjectionnoneETAnoneTarget Versionpi
OSLinux 32 bitDatabaseOracleJava version1.6.0_14
OS VersionUbuntu 9.04Database version11.1.0.6.0 SEAnt version1.7.1
Product VersionpiSCM revision73a8794c3b1c 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012230: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0009520 closediciordia 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 closedrakheemohanlal While voiding an AR invoice or an AP invoice the system shows former "document date" and "posting date" dates 
related to defect 00108072.50MP8 closedrafaroda The documentno on invoices is not unique 

-  Notes
(0024257)
rafaroda (developer)
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 (developer)
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 (developer)
2010-02-16 12:56

The issue is related to the fix of issue 0010807
(0024415)
hgbot (developer)
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 (reporter)
2010-02-17 11:42

Tested & working fine
(0024540)
hudsonbot (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-02-11 12:38 dalsasua New Issue
2010-02-11 12:38 dalsasua Assigned To => psarobe
2010-02-11 18:30 psarobe Assigned To psarobe => rafaroda
2010-02-11 18:30 psarobe Priority normal => immediate
2010-02-11 18:30 psarobe Status new => scheduled
2010-02-15 11:32 rafaroda Note Added: 0024257
2010-02-15 11:44 rafaroda Relationship added related to 0009520
2010-02-15 11:45 rafaroda Relationship added related to 0009519
2010-02-16 12:34 rafaroda Note Added: 0024400
2010-02-16 12:55 rafaroda Relationship added related to 0010807
2010-02-16 12:56 rafaroda Note Added: 0024402
2010-02-16 15:15 hgbot Checkin
2010-02-16 15:15 hgbot Note Added: 0024415
2010-02-16 15:15 hgbot Status scheduled => resolved
2010-02-16 15:15 hgbot Resolution open => fixed
2010-02-16 15:15 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7de7c4a6be7eb6b511d2156f5c75b9953af86bf9 [^]
2010-02-17 11:42 arunkumar Note Added: 0024473
2010-02-17 11:42 arunkumar Status resolved => closed
2010-02-17 11:42 arunkumar Fixed in Version => 2.50MP12
2010-02-18 00:01 anonymous sf_bug_id 0 =>
2010-02-18 00:31 hudsonbot Checkin
2010-02-18 00:31 hudsonbot Note Added: 0024540
2010-03-10 18:29 anonymous sf_bug_id => 2968051


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker