Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0037732 | Openbravo ERP | 07. Sales management | public | 2018-01-25 18:35 | 2018-02-22 18:18 |
|
| Reporter | dmiguelez | |
| Assigned To | Triage Omni OMS | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 30 | OS Version | Openbravo Appliance 14.04 |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR18Q2 | |
| Merge Request Status | |
| Review Assigned To | dmiguelez |
| 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 | 0037732: Add an Extension Point at the beginning of the C_Order_Post |
| Description | Add an Extension Point at the beginning of the C_Order_Post
There is currently another one at the end, but it would be nice to have another one at the beginning to allow modules to perform custom validations at the beginning of the process. |
| Steps To Reproduce | Add an Extension Point at the beginning of the C_Order_Post
There is currently another one at the end, but it would be nice to have another one at the beginning to allow modules to perform custom validations at the beginning of the process. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  Test-ORA.sql (1,008) 2018-01-26 10:00
https://issues.openbravo.com/file_download.php?file_id=11493&type=bug
Test-PG.sql (1,094) 2018-01-26 10:00
https://issues.openbravo.com/file_download.php?file_id=11494&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2018-01-25 18:35 | dmiguelez | New Issue | |
| 2018-01-25 18:35 | dmiguelez | Assigned To | => Triage Finance |
| 2018-01-25 18:35 | dmiguelez | Modules | => Core |
| 2018-01-25 18:35 | dmiguelez | Triggers an Emergency Pack | => No |
| 2018-01-26 09:59 | dmiguelez | Note Added: 0101985 | |
| 2018-01-26 10:00 | dmiguelez | File Added: Test-ORA.sql | |
| 2018-01-26 10:00 | dmiguelez | File Added: Test-PG.sql | |
| 2018-01-26 10:03 | hgbot | Checkin | |
| 2018-01-26 10:03 | hgbot | Note Added: 0101986 | |
| 2018-01-26 10:03 | hgbot | Status | new => resolved |
| 2018-01-26 10:03 | hgbot | Resolution | open => fixed |
| 2018-01-26 10:03 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/72ef6d83714d6bf9b9b0d77302c16f9a2e1a143f [^] |
| 2018-01-26 10:06 | dmiguelez | Review Assigned To | => dmiguelez |
| 2018-01-26 10:06 | dmiguelez | Note Added: 0101987 | |
| 2018-01-26 10:06 | dmiguelez | Status | resolved => closed |
| 2018-01-26 10:06 | dmiguelez | Fixed in Version | => 3.0PR18Q2 |
| 2018-02-22 18:18 | hudsonbot | Checkin | |
| 2018-02-22 18:18 | hudsonbot | Note Added: 0102689 | |
|
Notes |
|
|
|
Using Postgres.
Create function in Database using the attached file (Test_PG.sql).
Log in as System Admin and go to Window Extension Points.
Select the Extension Point with name: C_Order_Post - Validation Process
Create a new record in the Procedures Tab with:
- Module: Core (Set Module in development if it is not)
- Sequence Number: 10
- Procedure: Test
Log out and Log in as F&B Admin
Go to Sales Order Window and create a new Sales Order with:
- Business Partner: Alimentos y Supermercados
Move to Lines Tab and create a new record with:
- Product: Agua Sin Gas
- Ordered Quantity: 1
Click on Book button. An error message is shown with the message: Test
Edit the database funciton and comment or delete the line: RAISE EXCEPTION '%', 'Test';
Click on Book button. The process is completed successfully with the message: Test
Do the same test for a Purchase Order (with the proper parameters for Business Partner and Product, any Business Partner or Product available will be ok)
Do the same test for Oracle, but using the function provided in the other attached file (Test_ORA.sql). |
|
|
|
(0101986)
|
|
hgbot
|
|
2018-01-26 10:03
|
|
Repository: erp/devel/pi
Changeset: 72ef6d83714d6bf9b9b0d77302c16f9a2e1a143f
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Jan 25 18:35:39 2018 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/72ef6d83714d6bf9b9b0d77302c16f9a2e1a143f [^]
Fixes Issue 37732. Adds an exetension Point at the beginning of the C_Order_Post
---
M src-db/database/model/functions/C_ORDER_POST1.xml
M src-db/database/sourcedata/AD_EXTENSION_POINTS.xml
---
|
|
|
|
|
|
|
|
|
|