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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012858
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementcriticalhave not tried2010-04-01 09:012010-05-18 12:12
ReporterarunkumarView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision3e7d26d481a3
ProjectionnoneETAnoneTarget Version2.50MP17
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012858: Unable to complete purchase/sales order and purcahse/sales invoice

DescriptionCreate a complete purchase order. Also Create & complete purchase invoice. You will see an error message "This record cannot be deleted because it is associated with other existing elements. Please see Linked Items"
Steps To ReproducePurchase order:

Login as Openbravo/openbravo with "Openbravo Admin" role.
Go to procurement management -> Transactions -> Purchase order -> Header.
Create a new record and select the business partner Mcgiver supplies.
In lines create a new record.Enter the product "Hat" and ordered quantity as 10.
Go back to header and complete.

You will see an error message "This record cannot be deleted because it is associated with other existing elements. Please see Linked Items"

Purchase Invoice:

Login as Openbravo/openbravo with "Openbravo Admin" role.
Go to procurement management -> Transactions -> Purchase Invoice-> Header.
Create a new record and select the business partner Mcgiver supplies.
In lines create a new record.Enter the product "Hat" and invoiced quantity as 10.
Go back to header and complete.

You will see an error message "This record cannot be deleted because it is associated with other existing elements. Please see Linked Items"
TagsRegression QA
Attached Filesjpg file icon purchaseorder.JPG [^] (153,797 bytes) 2010-04-01 09:01

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0025867)
psarobe (manager)
2010-04-02 11:40

The same happens in Sales order and sales invoice
(0025885)
dalsasua (reporter)
2010-04-06 09:31

This is the error returned from database when executing the 'C_Order Post' process in a fresh installation, in revision e9504e6a07ae:

@ERROR=ORA-02291: restricción de integridad (TAD_PI.FIN_PAYMENTMETHOD_PAYMENT_SCH) violada - clave principal no encontrada
(0025891)
adrianromero (manager)
2010-04-06 12:36

From Hari investigations:

The issue rises in the FIN_GEN_PAYMENTSCHEDULE_INV.xml prodcedure.This occurs in Insert statement of this procedure.

Lines Numbers:

1)https://code.openbravo.com/erp/devel/pi/file/e9504e6a07ae/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml#l170 [^]

In this line

In this column "fin_paymentmethod_id" foreign key inserting value is "to-do"
2)https://code.openbravo.com/erp/devel/pi/file/e9504e6a07ae/src-db/database/model/functions/FIN_GEN_PAYMENTSCHEDULE_INV.xml#l241 [^]

In this the foreign key constraints are inserting null
(0025916)
hgbot (developer)
2010-04-07 01:22

Repository: erp/devel/pi
Changeset: 3e7d26d481a36e9e2b29e01c39ae3ce74f066e9f
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Wed Apr 07 01:33:48 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3e7d26d481a36e9e2b29e01c39ae3ce74f066e9f [^]

Fixes bug 0012858: Unable to complete purchase/sales order and purcahse/sales invoice

---
M src-db/database/sourcedata/AD_EP_PROCEDURES.xml
---
(0026148)
psarobe (manager)
2010-04-13 17:30

Tested, working fine
(0026421)
hudsonbot (developer)
2010-04-19 21:12

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/3e7d26d481a3 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/91d98bda46c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17088.obx [^]

- Issue History
Date Modified Username Field Change
2010-04-01 09:01 arunkumar New Issue
2010-04-01 09:01 arunkumar Assigned To => adrianromero
2010-04-01 09:01 arunkumar File Added: purchaseorder.JPG
2010-04-01 09:01 arunkumar Status new => scheduled
2010-04-01 09:01 arunkumar fix_in_branch => pi
2010-04-02 11:40 psarobe Note Added: 0025867
2010-04-02 11:40 psarobe Target Version => 2.50MP15
2010-04-02 11:40 psarobe fix_in_branch pi =>
2010-04-02 11:40 psarobe Summary Unable to complete purchase order and purcahse invoice => Unable to complete purchase/sales order and purcahse/sales invoice
2010-04-02 11:40 psarobe Steps to Reproduce Updated View Revisions
2010-04-03 01:40 eintelau Issue Monitored: eintelau
2010-04-06 09:31 dalsasua Note Added: 0025885
2010-04-06 11:36 plujan Assigned To adrianromero => eduardo_Argal
2010-04-06 12:36 adrianromero Note Added: 0025891
2010-04-06 12:56 psarobe Tag Attached: Regression QA
2010-04-07 01:22 hgbot Checkin
2010-04-07 01:22 hgbot Note Added: 0025916
2010-04-07 01:22 hgbot Status scheduled => resolved
2010-04-07 01:22 hgbot Resolution open => fixed
2010-04-07 01:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3e7d26d481a36e9e2b29e01c39ae3ce74f066e9f [^]
2010-04-13 17:30 psarobe Note Added: 0026148
2010-04-13 17:30 psarobe Status resolved => closed
2010-04-14 00:01 anonymous sf_bug_id 0 => 2986802
2010-04-19 21:12 hudsonbot Checkin
2010-04-19 21:12 hudsonbot Note Added: 0026421
2010-05-18 12:12 gorka_gil Target Version 2.50MP15 => 2.50MP17


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker