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.

Tags

comsup_sprint4

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0006866

closed

gorkaion

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

Notes
(0012192) svnbot (reporter) 2009-01-14 19:29	Repository: openbravo Revision: 11896 Author: gorkaion Date: 2009-01-14 19:29:26 +0100 (Wed, 14 Jan 2009) Fixed bug 6870. Fixed the C_Invoice_Create procedure, c_order_id is now optional in the M_InOut table so it is necessary to make the join to the Order using the C_OrderLine instead of the M_InOut. --- U branches/r2.3x/database/model/functions/C_INVOICE_CREATE.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=11896&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2009-01-13 16:33	psarobe	Type	defect => backport
2009-01-13 16:33	psarobe	fix_in_branch	=> 2.3x
2009-01-14 11:24	rafaroda	Assigned To	rafaroda => gorkaion
2009-01-14 19:29	svnbot	Checkin
2009-01-14 19:29	svnbot	Note Added: 0012192
2009-01-14 19:29	svnbot	Status	scheduled => resolved
2009-01-14 19:29	svnbot	Resolution	open => fixed
2009-01-14 19:29	svnbot	svn_revision	=> 11896
2009-01-23 11:33	gorkaion	Tag Attached: comsup_sprint4
2009-01-27 12:34	psarobe	Status	resolved => closed