Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013358Openbravo ERP07. Sales managementpublic2010-05-18 10:572010-06-03 22:49
Reporternetworkb 
Assigned Toadrianromero 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP17 
Target Version2.50MP19Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013358: Error when invoicing using invoice grouping "by project"
DescriptionIf your partner has defined InvoiceTerms= customer schedule after delivery and InvoiceGrouping=by project , invoices are not correctly grouped by project
Steps To Reproduce1. Master Data Management || Business Partner || Business Partner >> Customer: set bp mcgiver with InvoiceTerms= customer schedule after delivery and InvoiceGrouping=by project
2. Sales Management || Transactions || Sales Order || Header : create 5 sales orders for mcgiver-->
   * SalesOrder1 = without project
   * SalesOrder2 = with project Mafalda
   * SalesOrder3 = with project Mafalda
   * SalesOrder4 = with project Millman
   * SalesOrder5 = with project Millman
3. Sales Management || Transactions || Create Shipments from Orders: create shipments for 5 orders
4. Sales Management || Transactions || Create Invoices from Orders: create invoices for 5 orders and realize that
   * Only 2 Invoices have been created -->
        * Invoice1 has lines for Millman project (Correct)
        * Invoice2 has lines for Mafalda project but also for order without project (INCORRECT)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-05-18 10:57networkbNew Issue
2010-05-18 10:57networkbAssigned To => adrianromero
2010-05-18 10:57networkbOBNetwork customer => Yes
2010-05-18 13:59adrianromeroStatusnew => scheduled
2010-05-18 13:59adrianromerofix_in_branch => pi
2010-06-01 17:48hgbotCheckin
2010-06-01 17:48hgbotNote Added: 0027868
2010-06-01 17:48hgbotStatusscheduled => resolved
2010-06-01 17:48hgbotResolutionopen => fixed
2010-06-01 17:48hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a21f7072b8ef6303ee9f93d741f1dfc9b3eebc5c [^]
2010-06-01 17:51adrianromeroNote Added: 0027869
2010-06-02 10:25arunkumarNote Added: 0027897
2010-06-02 10:25arunkumarStatusresolved => closed
2010-06-03 00:00anonymoussf_bug_id0 => 3010712
2010-06-03 22:49hudsonbotCheckin
2010-06-03 22:49hudsonbotNote Added: 0027941

Notes
(0027868)
hgbot   
2010-06-01 17:48   
Repository: erp/devel/pi
Changeset: a21f7072b8ef6303ee9f93d741f1dfc9b3eebc5c
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Jun 01 17:48:17 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a21f7072b8ef6303ee9f93d741f1dfc9b3eebc5c [^]

Fixes issue 0013358: Error when invoicing using invoice grouping by project
This change modifies the condition of grouping by project because it did not take into account when the project is NULL

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
---
(0027869)
adrianromero   
2010-06-01 17:51   
* Testing issue
Just follow the steps to test and notice that now sales orders with no project associated and sales orders with a project associated are not grouped in the same invoice

* Other areas affected
Only the process C_INVOICE_CREATE has been modified so only the process Create Invoices from Orders is affected.
(0027897)
arunkumar   
2010-06-02 10:25   
Tested working fine
(0027941)
hudsonbot   
2010-06-03 22:49   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/a21f7072b8ef [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/c011484a38d9 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17407.obx [^]