Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008780 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | trivial | always | 2009-04-27 16:05 | 2009-05-29 00:00 | |||
| Reporter | AinhoaPagola | View Status | public | |||||
| Assigned To | rajagopal | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | pi | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 3fdf05db7f2e | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5 | |||
| OS Version | Ubuntu 8.4 | Database version | 8.3 | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0016082) hgbot (developer) 2009-05-06 10:12 |
Repository: erp/devel/pi Changeset: 3fdf05db7f2eb8eaa800de5eea12770f7d219275 Author: Rajagopal Baskaran <rajagopal.baskaran <at> openbravo.com> Date: Wed May 06 13:38:55 2009 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/3fdf05db7f2eb8eaa800de5eea12770f7d219275 [^] Fixes bug 8780: Create invoices from order: Creates blank line with no description (PostgreSQL) has been fixed. --- M src-db/database/model/functions/C_INVOICE_CREATE.xml --- |
|
(0016562) RenateNieuwkoop (reporter) 2009-05-21 18:08 |
Does this resolve point 1 on bug 8955 also? I don't think that bug was just for PostgreSQL though. |
|
(0016704) sureshbabu (reporter) 2009-05-28 10:31 |
Tested working fine |
|
Notes |
|
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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |