Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||||||||||||||||
| View Issue Details | ||||||||||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||||||||||||||||
| 0008780 | Openbravo ERP | 07. Sales management | public | 2009-04-27 16:05 | 2009-05-29 00:00 | |||||||||||||||||||||
| Reporter | AinhoaPagola | |||||||||||||||||||||||||
| Assigned To | rajagopal | |||||||||||||||||||||||||
| Priority | normal | Severity | trivial | Reproducibility | always | |||||||||||||||||||||
| Status | closed | Resolution | fixed | |||||||||||||||||||||||
| Platform | OS | 20 | OS Version | Ubuntu 8.4 | ||||||||||||||||||||||
| Product Version | pi | |||||||||||||||||||||||||
| Target Version | Fixed in Version | pi | ||||||||||||||||||||||||
| 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 | 0008780: Create invoices from order: Creates blank line with no description (PostgreSQL) | |||||||||||||||||||||||||
| Description | Generate invoice process, which created invoices from orders, inserts a blank line, apart from the lines of the order. In Oracle, this line is only for orders that have a receipt, and the document number of that receipt is copied in the description of the line. That is, for instance, for orders with invoice rule immediate, in Oracle, no extra line is created. For orders with invoice rule "after order delivered", if the shipment is done, the invoice contains a blank line with the delivery number. In PostgresSQL, a blank line is always created with no description, nor anything on it. Line number = 0. | |||||||||||||||||||||||||
| Steps To Reproduce | * Create a new sales order. * Invoice term = immediate. * Run Create Invoice from orders (select the created order) * Go to the invoice a check that there is a line 0 with nothing on it. ----- * Create a new sales order. * Invoice term "after order delivered" * Create a shipment for the order * Run Create Invoice from orders (select the created order) * Go to the invoice a check that there is a line 0 with nothing on it. | |||||||||||||||||||||||||
| Proposed Solution | In c_incoive_create, when the description is created there is probably some where a concatenation with NULL, which converts the whole string to null in PostgreSQL. | |||||||||||||||||||||||||
| Additional Information | ||||||||||||||||||||||||||
| Tags | No tags attached. | |||||||||||||||||||||||||
| Relationships |
| |||||||||||||||||||||||||
| Attached Files | ||||||||||||||||||||||||||
| Issue History | ||||||||||||||||||||||||||
| Date Modified | Username | Field | Change | |||||||||||||||||||||||
| 2009-04-27 16:05 | AinhoaPagola | New Issue | ||||||||||||||||||||||||
| 2009-04-27 16:05 | AinhoaPagola | Assigned To | => rafaroda | |||||||||||||||||||||||
| 2009-04-27 16:05 | AinhoaPagola | Regression testing | => No | |||||||||||||||||||||||
| 2009-04-27 16:08 | AinhoaPagola | Summary | Create invoices from order: invoice process: Creates blank line with no description (PostgreSQL) => Create invoices from order: Creates blank line with no description (PostgreSQL) | |||||||||||||||||||||||
| 2009-04-27 16:08 | AinhoaPagola | Proposed Solution updated | ||||||||||||||||||||||||
| 2009-04-27 16:08 | AinhoaPagola | Steps to Reproduce Updated | ||||||||||||||||||||||||
| 2009-04-27 16:14 | rafaroda | Assigned To | rafaroda => sathiyan | |||||||||||||||||||||||
| 2009-04-27 16:14 | rafaroda | Status | new => scheduled | |||||||||||||||||||||||
| 2009-04-27 16:14 | rafaroda | Steps to Reproduce Updated | ||||||||||||||||||||||||
| 2009-04-28 08:11 | sathiyan | Assigned To | sathiyan => rajagopal | |||||||||||||||||||||||
| 2009-05-06 10:12 | hgbot | Checkin | ||||||||||||||||||||||||
| 2009-05-06 10:12 | hgbot | Note Added: 0016082 | ||||||||||||||||||||||||
| 2009-05-06 10:12 | hgbot | Status | scheduled => resolved | |||||||||||||||||||||||
| 2009-05-06 10:12 | hgbot | Resolution | open => fixed | |||||||||||||||||||||||
| 2009-05-06 10:12 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/3fdf05db7f2eb8eaa800de5eea12770f7d219275 [^] | |||||||||||||||||||||||
| 2009-05-21 18:08 | RenateNieuwkoop | Note Added: 0016562 | ||||||||||||||||||||||||
| 2009-05-28 10:11 | rafaroda | Relationship added | related to 0008207 | |||||||||||||||||||||||
| 2009-05-28 10:12 | rafaroda | Relationship added | related to 0008955 | |||||||||||||||||||||||
| 2009-05-28 10:12 | rafaroda | Relationship added | related to 0005604 | |||||||||||||||||||||||
| 2009-05-28 10:31 | sureshbabu | Status | resolved => closed | |||||||||||||||||||||||
| 2009-05-28 10:31 | sureshbabu | Note Added: 0016704 | ||||||||||||||||||||||||
| 2009-05-28 10:31 | sureshbabu | Fixed in Version | => pi | |||||||||||||||||||||||
| 2009-05-28 12:47 | rafaroda | Note Added: 0016723 | ||||||||||||||||||||||||
| 2009-05-29 00:00 | anonymous | sf_bug_id | 0 => 2798132 | |||||||||||||||||||||||
| 2009-06-01 12:58 | rafaroda | Note Deleted: 0016723 | ||||||||||||||||||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||