Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039330Openbravo ERP07. Sales managementpublic2018-09-20 15:342018-12-11 20:22
Reportergsuarez 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Versionpi 
Target VersionpiFixed in Version3.0PR19Q1 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039330: Invoice status field in Goods Shipment don't work appropietly
DescriptionWhen a sales invoice is created from a shipment and don't complete it, the invoice status of the shipment is updated.
Steps To Reproduce1. Create a Goods Shipment with one line with quantity 1.
2. Book the Goods Shipment.
3. Create sales invoice header.
4. Press button Create Lines from Shipment.
5. Select the line created in the Goods Shipment.
6. Don't book the sales invoice.
7. Go to the Goods Shipment and check the invoice status field. The value is incorrect, because the sales invoice is not complete yet.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0039386 closed Triage Omni OMS Goods Shipment IsCompletelyInvoiced flag is not properly updated when voiding Sales Invoice 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-09-20 15:34gsuarezNew Issue
2018-09-20 15:34gsuarezAssigned To => Triage Finance
2018-09-20 15:34gsuarezModules => Core
2018-09-20 15:34gsuarezResolution time => 1539208800
2018-09-20 15:34gsuarezTriggers an Emergency Pack => No
2018-09-20 15:40PracticsIssue Monitored: Practics
2018-09-21 14:11SandrahuguetAssigned ToTriage Finance => AtulOpenbravo
2018-09-27 19:52AtulOpenbravoStatusnew => scheduled
2018-10-02 07:48AtulOpenbravoNote Added: 0107104
2018-10-02 08:15AtulOpenbravoNote Edited: 0107104bug_revision_view_page.php?bugnote_id=0107104#r17721
2018-10-02 08:48AtulOpenbravoNote Edited: 0107104bug_revision_view_page.php?bugnote_id=0107104#r17722
2018-10-02 09:08AtulOpenbravoRelationship addedrelated to 0039386
2018-10-02 17:57hgbotCheckin
2018-10-02 17:57hgbotNote Added: 0107125
2018-10-02 17:57hgbotStatusscheduled => resolved
2018-10-02 17:57hgbotResolutionopen => fixed
2018-10-02 17:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/334861bec14192c6157fb99f2167c56089c904e9 [^]
2018-10-02 17:58SandrahuguetReview Assigned To => Sandrahuguet
2018-10-02 17:58SandrahuguetNote Added: 0107126
2018-10-02 17:58SandrahuguetStatusresolved => closed
2018-10-02 17:58SandrahuguetFixed in Version => 3.0PR19Q1
2018-12-11 20:22hudsonbotCheckin
2018-12-11 20:22hudsonbotNote Added: 0108414

Notes
(0107104)
AtulOpenbravo   
2018-10-02 07:48   
(edited on: 2018-10-02 08:48)
1. Create a Goods Shipment with one line with quantity 10.
2. Book the Goods Shipment.
3. Create sales invoice header.
4. Press button Create Lines from Shipment.
5. Select the line created in the Goods Shipment.
6. Don't book the sales invoice.
7. Go to the Goods Shipment and check the invoice status field. The value is set 0 and it is correct, because the sales invoice is not complete yet.
8. Book the Sales Invoice and check the invoice status field in related Goods Shipment. The value is 100%.
9. Void the Sales Invoice and again check the invoice status field in related Goods Shipment. The value is 0%.

Similar tests are done for partial invoicing of goods shipment.

For eg: Movement Qty = 10

Sales Invoice 1 : Qty = 6

Goods Shipment, Invoice Status = 60%

Sales Invoice 2 : Qty = 4

Goods shipment, Invoice Status = 100%

Void First Sales invoice:

Check Goods shipment, Invoice Status = 40%.
(0107125)
hgbot   
2018-10-02 17:57   
Repository: erp/devel/pi
Changeset: 334861bec14192c6157fb99f2167c56089c904e9
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Fri Sep 28 01:58:48 2018 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/334861bec14192c6157fb99f2167c56089c904e9 [^]

Fixes Issue 39330:Invoice status field in Goods Shipment don't
work appropriately

Added clause whether invoice is processed when calculating
invoice status.

---
M src-db/database/model/functions/C_GETINVOICESTATUSFROMSHIPMENT.xml
---
(0107126)
Sandrahuguet   
2018-10-02 17:58   
Code review + testing OK
(0108414)
hudsonbot   
2018-12-11 20:22   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/470e3cd384c5 [^]
Maturity status: Test