0006869: 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
There are no notes attached to this issue.

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.40
2009-01-14 11:24	rafaroda	Assigned To	rafaroda => gorkaion
2009-01-14 19:28	gorkaion	Status	scheduled => resolved
2009-01-14 19:28	gorkaion	Fixed in Version	=> 2.40
2009-01-14 19:28	gorkaion	svn_revision	=> 11895
2009-01-14 19:28	gorkaion	Resolution	open => fixed
2009-01-23 11:33	gorkaion	Tag Attached: comsup_sprint4
2009-01-25 22:14	psarobe	Status	resolved => closed