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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0035783

Openbravo ERP

07. Sales management

public

2017-04-12 14:04

2017-04-25 18:58

Reporter

ngarcia

Assigned To

markmm82

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0PR17Q2

Fixed in Version

3.0PR17Q2

Merge Request Status

Review Assigned To

aferraz

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Production - Confirmed Stable

Regression date

2017-12-03

Regression introduced in release

3.0PR17Q1

Regression introduced by commit

https://code.openbravo.com/erp/devel/pi/rev/9df1ba7871bb [^]

Triggers an Emergency Pack

Summary

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

Description

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, the following two changes were wrong

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

OR (si.invoicefrequency IN ('D', 'W', 'T'))

Steps To Reproduce

As 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

Proposed Solution

Additional Information