Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0013163 | Openbravo ERP | 07. Sales management | public | 2010-04-30 09:45 | 2010-05-18 21:43 |
| Reporter | psarobe | ||||
| Assigned To | dalsasua | ||||
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | 2.50MP13 | ||||
| Target Version | 2.50MP17 | Fixed in Version | |||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0013163: Cannot complete a sales/purchase invoice under some circumstances | ||||
| Description | Under some circumstances an invoice cannot be completed. This happens when: 1. The business partner has discounts configured 2. The result of the discount (amount) has more than 2 decimals 3. Only happens in Oracle database The reason is: 1. Trigger C_INVOICELINE_TRG4 is executed before C_INVLINE_CHK_RESTRICTIONS_TRG so the amount is not rounded based on the precision. 2. There is another issue that needs to be fixed. How can the error is coded like "RAISE_APPLICATION_ERROR(-20501,'Line Amount Is Not Correct');". That's a big mistake. That number has nothing to do with the real error so it misleads the end user and developers when trying to figure out what was wrong | ||||
| Steps To Reproduce | 1. Login in PI or Main 2. Openbravo/openbravo 3. Go to Sales management-> Transactions->Sales invoice 4. Click new and select Sailor as bpartner 5. Move to lines and select hammer 6. Qty=1 7. Go back to the header and complete Expected result: Process complete successfully Current result and error: Document already posted/processed | ||||
| Proposed Solution | Trigger C_INVOICELINE_TRG4 should be merged with C_INVLINE_CHK_RESTRICTIONS_TRG and do the check once the amount (line net amount) is rounded | ||||
| Additional Information | |||||
| Tags | Regression | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2010-04-30 09:45 | psarobe | New Issue | |||
| 2010-04-30 09:45 | psarobe | Assigned To | => dalsasua | ||
| 2010-04-30 09:46 | psarobe | Tag Attached: Regression | |||
| 2010-04-30 09:46 | psarobe | Status | new => scheduled | ||
| 2010-04-30 09:46 | psarobe | fix_in_branch | => pi | ||
| 2010-04-30 12:28 | hgbot | Checkin | |||
| 2010-04-30 12:28 | hgbot | Note Added: 0026809 | |||
| 2010-04-30 12:28 | hgbot | Status | scheduled => resolved | ||
| 2010-04-30 12:28 | hgbot | Resolution | open => fixed | ||
| 2010-04-30 12:28 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/b9e8574569f75fb2a408ff09233f02050e356bae [^] | ||
| 2010-05-03 16:08 | sureshbabu | Note Added: 0026873 | |||
| 2010-05-03 16:08 | sureshbabu | Status | resolved => closed | ||
| 2010-05-04 00:00 | anonymous | sf_bug_id | 0 => 2996197 | ||
| 2010-05-04 15:55 | psarobe | version | 2.50MP14 => 2.50MP13 | ||
| 2010-05-04 15:55 | psarobe | fix_in_branch | pi => | ||
| 2010-05-04 15:56 | psarobe | Note Added: 0026918 | |||
| 2010-05-18 12:12 | gorka_gil | Target Version | 2.50MP15 => 2.50MP17 | ||
| 2010-05-18 21:43 | hudsonbot | Checkin | |||
| 2010-05-18 21:43 | hudsonbot | Note Added: 0027459 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||