Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008373 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 08. Project and service management | major | random | 2009-04-01 11:27 | 2009-05-05 00:00 | |||
| Reporter | serc | View Status | public | |||||
| Assigned To | areefbasha | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 11714fc5cfc0 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Windows | Database | PostgreSQL | Java version | 1.6.0_03 | |||
| OS Version | Xp | Database version | 8.3.5 | Ant version | 1.7.0 | |||
| Product Version | 2.50beta | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0008373: Expense invoices are not being created properly. | |||||||
| Description | Create AP Expense Invoices doesn't properly generate invoices from expense sheets. Randomly, it merges expenses into some other invoices. One of the potential reasons is, in the respective servlet i.e., org.openbravo.erpCommon.ad_process.ExpenseAPInvoice there is an issues with a query. Method processExpense needs invoice header to process expense sheets, and gets it from another method selectInvoiceHeader which is using max in the query. This seems to be absurd and might be cause of the problem. | |||||||
| Steps To Reproduce | 1. Create some expense sheets. 2. Process them in Create AP Expense Invoice page. 3. See output at Procurement Management-> Transactions-> Purchase Invoices. You will see at times expenses that are to merge in one invoice are merged at different purchase invoices. Sample data ----------- 1) Create a new expense sheet Create a line item one line item --> 5000 --> Food Click Process Expenses button in the expense sheet header. 2) Create another new expense sheet Create two line items a line item --> 6000 --> Electricity a line item --> 7000 --> Food Click Process Expenses button in the expense sheet header. 3) Create AP Expense Invoices for the above items Gor the message as "Purchase Invoice No. 10000039 has been created" Expected Result: Now the all the three lines items should appear in one pucharse invoice 10000039 Actual Result : Only the first item appear in the purchase invoice 10000039 the second item appear in another purchase invoice 10000038. | |||||||
| Proposed Solution | SERVLET: org.openbravo.erpCommon.ad_process.ExpenseAPInvoice Method processExpense needs invoice header to process expense sheets, and gets it from another method selectInvoiceHeader which is using max in the query. This is not causing the problem but the following: 1) C_INVOICELINE table is no needed in selectInvoiceHeader and selectInvoiceHeaderNoProject selects selects. 2) There are some checks done to employee condition: price list, location, payment rule, payment term, etc... These check has to be done before selectInvoiceHeader and selectInvoiceHeaderNoProject and not after. 3) These employee conditions should take part in the selectInvoiceHeader and selectInvoiceHeaderNoProject selects. | |||||||
| Tags | 250MP1 | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0015877) hgbot (developer) 2009-04-28 18:24 |
Repository: erp/devel/pi Changeset: 11714fc5cfc0453dee2fe460302b138d4181c9b0 Author: Areef Basha <areef.basha <at> openbravo.com> Date: Tue Apr 28 21:52:08 2009 -0400 URL: http://code.openbravo.com/erp/devel/pi/rev/11714fc5cfc0453dee2fe460302b138d4181c9b0 [^] Fixes bug 8373: : Expense invoices are not being created properly. The selectInvoiceHeader and selectInvoiceHeaderNoProject selects have been changed. --- M src/org/openbravo/erpCommon/ad_process/ExpenseAPInvoice.java M src/org/openbravo/erpCommon/ad_process/ExpenseAPInvoice_data.xsql --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-04-01 11:27 | serc | New Issue | |
| 2009-04-01 11:27 | serc | Assigned To | => rafaroda |
| 2009-04-01 11:27 | serc | OBNetwork customer | => No |
| 2009-04-01 11:27 | serc | Regression testing | => No |
| 2009-04-03 08:44 | rafaroda | Assigned To | rafaroda => serc |
| 2009-04-03 08:44 | rafaroda | Priority | normal => high |
| 2009-04-03 08:44 | rafaroda | Steps to Reproduce Updated | |
| 2009-04-03 08:44 | rafaroda | Status | new => scheduled |
| 2009-04-03 08:44 | rafaroda | fix_in_branch | => pi |
| 2009-04-23 16:05 | psarobe | Tag Attached: 250MP1 | |
| 2009-04-27 11:07 | rafaroda | Assigned To | serc => sathiyan |
| 2009-04-27 12:36 | sathiyan | Assigned To | sathiyan => areefbasha |
| 2009-04-28 13:59 | areefbasha | fix_in_branch | pi => |
| 2009-04-28 13:59 | areefbasha | Proposed Solution updated | |
| 2009-04-28 14:41 | rafaroda | Steps to Reproduce Updated | |
| 2009-04-28 16:18 | rafaroda | Steps to Reproduce Updated | |
| 2009-04-28 18:24 | hgbot | Checkin | |
| 2009-04-28 18:24 | hgbot | Note Added: 0015877 | |
| 2009-04-28 18:24 | hgbot | Status | scheduled => resolved |
| 2009-04-28 18:24 | hgbot | Resolution | open => fixed |
| 2009-04-28 18:24 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/11714fc5cfc0453dee2fe460302b138d4181c9b0 [^] |
| 2009-05-04 19:53 | psarobe | Status | resolved => closed |
| 2009-05-05 00:00 | anonymous | sf_bug_id | 0 => 2786888 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |