Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034371Openbravo ERP07. Sales managementpublic2016-11-03 10:372016-12-16 18:38
Reportermaite 
Assigned Toalekosmp86 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q1 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket43381
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034371: Invoice Date and Accounting Date should be truncated when invoice is created using "Void" process
DescriptionReversed invoice has dates with HH:MM:SS <> 00:00:00 what should not be the case
Steps To Reproduce1. Register new Sales Invoice document for "F&B US East Coast" organization. Set any business partner and add any line and process
2. Run "Void" process
3. Via database, verify that date fields are not truncated
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00270893.0PR15Q1 closed fsoto82 Invoice Date and Accounting Date should be truncated when invoice is created using "Generate Invoice from Receipt" process 
related to defect 00309713.0PR16Q1 closed aferraz When voiding an unpaid invoice, payment schedule details should be canceled instead of deleted 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-11-03 10:37maiteNew Issue
2016-11-03 10:37maiteAssigned To => Triage Finance
2016-11-03 10:37maiteOBNetwork customer => Yes
2016-11-03 10:37maiteModules => Core
2016-11-03 10:37maiteSupport ticket => 43381
2016-11-03 10:37maiteResolution time => 1479596400
2016-11-03 10:37maiteTriggers an Emergency Pack => No
2016-11-03 10:37maiteRelationship addedrelated to 0027089
2016-11-03 10:38maiteIssue Monitored: networkb
2016-11-03 20:59aferrazAssigned ToTriage Finance => nonofrancisco
2016-11-07 17:07markmm82Assigned Tononofrancisco => markmm82
2016-11-07 17:50markmm82Statusnew => acknowledged
2016-11-09 09:18aferrazRelationship addedrelated to 0030971
2016-11-09 10:13maiteDescription Updatedbug_revision_view_page.php?rev_id=13580#r13580
2016-11-09 10:13maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=13582#r13582
2016-11-10 16:21markmm82Note Added: 0091340
2016-11-10 16:27markmm82Statusacknowledged => scheduled
2016-11-11 09:09aferrazAssigned Tomarkmm82 => alekosmp86
2016-11-11 09:31hgbotCheckin
2016-11-11 09:31hgbotNote Added: 0091374
2016-11-11 09:31hgbotStatusscheduled => resolved
2016-11-11 09:31hgbotResolutionopen => fixed
2016-11-11 09:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ac6861ecdd851dc97f200b3eaf19908c899ddede [^]
2016-11-11 09:33aferrazReview Assigned To => aferraz
2016-11-11 09:33aferrazNote Added: 0091375
2016-11-11 09:33aferrazStatusresolved => closed
2016-11-11 09:33aferrazFixed in Version => 3.0PR17Q1
2016-12-16 18:38hudsonbotCheckin
2016-12-16 18:38hudsonbotNote Added: 0092609

Notes
(0091340)
markmm82   
2016-11-10 16:21   
Test Plan:
Go to Sales Invoice screen
   Create a new record:
      Organization: F&B US East Coast
   Save the record.
   Go to [Lines] Tab
      Create a new record:
         Product: Pear Juice
         Invoiced Quantity: 100
         Tax: Sales Exempt
      Save the record.
Complete the invoice.

With the previously created sales invoice still selected, click on Reactivate button and select Void process. Click OK.

A new reversed invoice is created based on the selected sales invoice.

Via database, go to table C_Invoice, notice that the reversed invoice we have just created has date with HH:MM:SS = 00:00:00
(0091374)
hgbot   
2016-11-11 09:31   
Repository: erp/devel/pi
Changeset: ac6861ecdd851dc97f200b3eaf19908c899ddede
Author: Alejandro <alekosmp86 <at> gmail.com>
Date: Wed Nov 09 12:24:38 2016 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/ac6861ecdd851dc97f200b3eaf19908c899ddede [^]

Fixes issue 34371: Dates are truncated in voided invoice

Reversed invoices had dates with HH:MM:SS <> 00:00:00. Function C_Invoice_Post
has been modified to trunc the dateinvoiced and dateacct fields. Reversed invoices
are now created with date with HH:MM:SS = 00:00:00

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0091375)
aferraz   
2016-11-11 09:33   
Code review + Testing OK
(0092609)
hudsonbot   
2016-12-16 18:38   
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/dc8bf00badd0 [^]
Maturity status: Test