Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035783
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementmajoralways2017-04-12 14:042017-04-25 18:58
ReporterngarciaView Statuspublic 
Assigned Tomarkmm82 
PriorityimmediateResolutionfixedFixed in Version3.0PR17Q2
StatusclosedFix in branchFixed in SCM revisionc31ebe580b49
ProjectionnoneETAnoneTarget Version3.0PR17Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression levelProduction - Confirmed Stable
Regression date2017-12-03
Regression introduced in release3.0PR17Q1
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/9df1ba7871bb [^]
Triggers an Emergency PackNo
Summary

0035783: Orders with Invoice Terms different from Customer Schedule After Delivery cannot be invoiced if the bp has an invoice schedule

DescriptionSales Orders with Invoice Terms different from Customer Schedule After Delivery (Immediate, After Delivery, After Order Delivered) cannot be invoiced if the business partner has an invoice schedule defined and the order does not fill its requirement

The problem is that the order is not returned by the C_INVOICE_CANDIDATE_V view, the following two changes were wrong

AND (o.invoicerule IN ('I', 'O', 'D', 'S'))

OR (si.invoicefrequency IN ('D', 'W', 'T'))
Steps To ReproduceAs group admin role:
   Create a new Invoice Schedule
   Configure it in order a sales order with today's date not to be automatically invoiced. Example being today 12-04-2017
      Day of The Month: 15
      Invoice Cut-Off Day: 13
   Set the Customer Schedule After Delivery Invoice Terms to a customer
   Create a Sales Order to that customer and set its Invoice Terms as Immediate
   Check the order does not appear in the Create Invoices From Orders process
   Create a sales invoice header and check the order is not shown in the Create lines From process
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0035772 closedmarkmm82 Orders with Invoice Terms different from Customer Schedule After Delivery cannot be invoiced if the bp has an invoice schedule 

-  Notes
(0096164)
hgbot (developer)
2017-04-25 17:43

 Repository: erp/backports/3.0PR17Q2
Changeset: c31ebe580b49e1a22ef010098c7f8566362c7494
Author: Mark <markmm82 <at> gmail.com>
Date: Wed Apr 12 12:53:42 2017 -0400
URL: http://code.openbravo.com/erp/backports/3.0PR17Q2/rev/c31ebe580b49e1a22ef010098c7f8566362c7494 [^]

Fixes issue 35783: Orders with Invoice Terms different from Customer Schedule
After Delivery cannot be invoiced if the bp has an invoice schedule

Sales Orders with Invoice Terms different from Customer Schedule After Delivery
(Immediate, After Delivery, After Order Delivered) cannot be invoiced if the business
partner has an invoice schedule defined and the order does not fill its requirement

The problem is that the order is not returned by the C_INVOICE_CANDIDATE_V view.
To avoid it was fixed the condition that takes into account the invoice rule of
the order and the sales invoice frequency.

---
M src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
---
(0096167)
aferraz (manager)
2017-04-25 17:44

 Code review + Testing OK
(0096176)
hgbot (developer)
2017-04-25 18:58

 Repository: erp/backports/3.0PR17Q2
Changeset: 94badfae5504ab2fbf3ad592d48020dc80b9bc41
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Apr 25 18:26:55 2017 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR17Q2/rev/94badfae5504ab2fbf3ad592d48020dc80b9bc41 [^]

Related to issue 35783: Fix dbcons failure

---
M src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml
---

- Issue History
Date Modified Username Field Change
2017-04-12 18:59 markmm82 Type defect => backport
2017-04-12 18:59 markmm82 Target Version => 3.0PR17Q2
2017-04-25 17:43 hgbot Checkin
2017-04-25 17:43 hgbot Note Added: 0096164
2017-04-25 17:43 hgbot Status scheduled => resolved
2017-04-25 17:43 hgbot Resolution open => fixed
2017-04-25 17:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR17Q2/rev/c31ebe580b49e1a22ef010098c7f8566362c7494 [^]
2017-04-25 17:44 aferraz Review Assigned To => aferraz
2017-04-25 17:44 aferraz Note Added: 0096167
2017-04-25 17:44 aferraz Status resolved => closed
2017-04-25 17:44 aferraz Fixed in Version => 3.0PR17Q2
2017-04-25 18:58 hgbot Checkin
2017-04-25 18:58 hgbot Note Added: 0096176

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker