0006870: Generate invoices process doesn't work for orders with "Customer Schedule After Delivery" invoice terms

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0006870

Openbravo ERP

07. Sales management

public

2009-01-13 13:17

2009-01-27 12:34

Reporter

networkb

Assigned To

gorkaion

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0006870: Generate invoices process doesn't work for orders with "Customer Schedule After Delivery" invoice terms

Description

The automatic invoicing process (Sales Management > Transactions > Generate Invoices)
does not invoice the orders that have been shipped in a single goods shipment.

Steps To Reproduce

1. Sales Management||Transactions||Sales Order --> create 2 orders with
    transaction document= standard order
    order date y scheduled delivery date= 13/12/2008
    bp: sailor int
    invoice terms: customer schedule after delivery
   and at least one line and COMPLETE. (No. 50041 y 50042 in tecnicia14)
2. Sales Management||Transactions||Goods Shipment--> create 1 shipment with
    bp: sailor int
    create lines from the previous orders and COMPLETE. (No. 500026)
3. Run Generate Invoices Process choosing just organization.

It creates 0 invoices.

Proposed Solution

The error is in the C_INVOICE_CREATE process in the SELECT of line 602. The JOIN
"sh.C_Order_ID=o.C_Order_ID" should be replaced by "ol.C_Order_ID=o.C_Order_ID" as in
the case stated before, the field C_ORDER_ID in M_INOUT is null as there are lines
from different orders.

Additional Information