Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007262Openbravo ERP07. Sales managementpublic2009-01-30 12:152009-02-20 06:29
Reportersureshbabu 
Assigned ToAinhoaPagola 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.50alpha-r6 
Target VersionFixed in Version2.50beta 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007262: User not able to complete the Sales order with document type as 'Prepay'
DescriptionUser not able to complete the Sales order with document type as 'Prepay'


Error:
column "data_exception" does not exist
Steps To Reproduce
Proposed Solution
Additional Information
Tagscommsup_sprint6
Relationships
depends on backport 0007662 closed AinhoaPagola User not able to complete the Sales order with document type as 'Prepay' 
has duplicate defect 00046812.35 closed pheenan Prepaid sales orders crashes when completing in postgres 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-30 12:15sureshbabuNew Issue
2009-01-30 12:15sureshbabuAssigned To => rafaroda
2009-01-30 12:15sureshbabusf_bug_id0 => 2548758
2009-02-03 10:49sureshbabuNote Added: 0013062
2009-02-10 10:36psarobeStatusnew => scheduled
2009-02-10 10:36psarobeAssigned Torafaroda => AinhoaPagola
2009-02-10 10:36psarobefix_in_branch => trunk
2009-02-17 11:05AinhoaPagolaNote Added: 0013557
2009-02-17 14:06svnbotCheckin
2009-02-17 14:06svnbotNote Added: 0013569
2009-02-17 14:06svnbotStatusscheduled => resolved
2009-02-17 14:06svnbotResolutionopen => fixed
2009-02-17 14:06svnbotsvn_revision => 13274
2009-02-18 18:42AinhoaPagolaStatusresolved => new
2009-02-18 18:42AinhoaPagolaResolutionfixed => open
2009-02-18 18:42AinhoaPagolaStatusnew => scheduled
2009-02-18 18:42AinhoaPagolaStatusscheduled => resolved
2009-02-18 18:42AinhoaPagolaResolutionopen => fixed
2009-02-18 18:44AinhoaPagolaRelationship addedhas duplicate 0004681
2009-02-20 06:29sureshbabuRegression testing => No
2009-02-20 06:29sureshbabuStatusresolved => closed
2009-02-20 06:29sureshbabuNote Added: 0013778
2009-02-20 06:29sureshbabuFixed in Version => trunk
2009-02-20 09:32PavelPonomarevTag Attached: commsup_sprint6

Notes
(0013062)
sureshbabu   
2009-02-03 10:49   
Steps t0 Reproduce:

# Login as userA
# Go to Sales management->Transactions->Sales Order
# Click New and select Transaction Document: Prepay

# Select business partner customerA


# Move to tab Lines and click New.
And select Product A
    * UOM:Unit
    * Unit price:2
    * List price:2
    * Tax:VAT(3)+CHARGE(0.5)

# Fill in Ordered quantity= 1
# Move to header and complete.

Expected result:
Sales order document status will move from draft to completed and document id will get generated.

Actual result:

User not able to complete the sales order when document type is Prepay
(0013557)
AinhoaPagola   
2009-02-17 11:05   
This exception happens because in prepay orders the invoice terms must be set to "immediate". It works fine for this invoice term, but if this field is set to anything else, it shows the error.

When prepay document is selected the invoice term automatically changes to inmediate. But if the Business Partner is selected afterwords, the invoice term will changed again to the Business Partners default invoice term.
(0013569)
svnbot   
2009-02-17 14:06   
Repository: openbravo
Revision: 13274
Author: AinhoaPagola
Date: 2009-02-17 14:06:17 +0100 (Tue, 17 Feb 2009)

Fixes bug 0007262. User not able to complete sales order with document type as 'Prepay'.

---
U trunk/src-db/database/model/functions/C_ORDER_POST1.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=13274&sc=1 [^]
(0013778)
sureshbabu   
2009-02-20 06:29   
Retested in context 79.125.56.185/openbravotrunk