Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014138Openbravo ERP07. Sales managementpublic2010-08-06 10:462010-09-13 12:38
Reporternetworkb 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP20 
Target Version2.50MP21Fixed in Version2.50MP21 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014138: Error when you create an invoice with news forms of payment
DescriptionError when you create an invoice with news forms of payment.

(Module 'Formas de Pago-1.0.2' installed)

This error appears:

Error:
el valor es demasiado largo para el tipo character(1)
Steps To Reproduce- As Openbravo Admin go to Sales Management || Transactions || Sales Order
- Create a new record:
   - Organziation: B
   - Transaction Document: Standard Order
   - Delivery Terms: Complete Order
   - Form of Payment_ Recibo Domiciliado
- Create a line
- Complete the order

- Go to Sales Management || Transactions || Generate Shipments
- Select B organization
- Ok

- Go to Sales Management || Transactions || Generate Invoices
- Select B organization
- Realize that the error appears
Proposed SolutionOn C_INVOICE_CREATE

the line: v_gPaymentRule CHAR(1) should be v_gPaymentRule CHAR(30);
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-08-06 10:46networkbNew Issue
2010-08-06 10:46networkbAssigned To => adrianromero
2010-08-06 10:46networkbOBNetwork customer => Yes
2010-08-09 15:05adrianromeroStatusnew => scheduled
2010-08-09 15:05adrianromerofix_in_branch => pi
2010-08-12 14:15hgbotCheckin
2010-08-12 14:15hgbotNote Added: 0029918
2010-08-12 14:15hgbotStatusscheduled => resolved
2010-08-12 14:15hgbotResolutionopen => fixed
2010-08-12 14:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ef6183fd79e5d06612cfccfbbccbb96f436d9728 [^]
2010-08-12 14:19adrianromeroNote Added: 0029919
2010-08-13 00:20hudsonbotCheckin
2010-08-13 00:20hudsonbotNote Added: 0029932
2010-08-13 04:05hudsonbotCheckin
2010-08-13 04:05hudsonbotNote Added: 0029934
2010-08-19 14:32psarobeNote Added: 0030156
2010-08-19 14:32psarobeStatusresolved => closed
2010-08-19 14:32psarobeFixed in Version => 2.50MP21
2010-09-13 12:38anonymoussf_bug_id0 => 3065164

Notes
(0029918)
hgbot   
2010-08-12 14:15   
Repository: erp/devel/pi
Changeset: ef6183fd79e5d06612cfccfbbccbb96f436d9728
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu Aug 12 14:12:42 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ef6183fd79e5d06612cfccfbbccbb96f436d9728 [^]

Fixes issue 0014138: Error when you create an invoice with news forms of payment
It has been modified the type of the PL/SQL variable that contains these values

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
---
(0029919)
adrianromero   
2010-08-12 14:19   
* Testing of the issue
Kindly follow the steps to reproduce and notice that no error appears.

* Other areas affected.
It only has been modified the PL/SQL that creates invoices invoked by the Generate Invoices process just making more room for payment rule values. Anything else is affected.
(0029932)
hudsonbot   
2010-08-13 00:20   
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/ef6183fd79e5 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/b4491b44162a [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18142.obx [^]
(0029934)
hudsonbot   
2010-08-13 04:05   
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/ef6183fd79e5 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/b4491b44162a [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18142.obx [^]
(0030156)
psarobe   
2010-08-19 14:32   
Tested working fine