0011310: Empty invoice line when creating invoice (Create Invoices from Orders process)

Description

An empty line (no description, quantity and price = 0) is generated when creating invoices in the 'Create Invoices from Orders' process if the Invoice Terms is set to 'Customer Schedule after Delivery'.
This is not related to the 8070 bug.

Steps To Reproduce

1. Create an order for a customer that has an invoice term set to 'Customer Schedule after Delivery'
2. Post the document
3. Create the shipment
4. Generate the invoice ('Create Invoices from Orders' process)

In the created invoice, there is an empty line in the invoice (the first line).

If the invoice regroups more than one order, there is an empty line at the beginning of each invoiced order.

It is the reference to the shipment that is not created properly.

Proposed Solution

The problem is in the c_invoice_create(IN p_pinstance_id character varying, OUT p_invoice_id character varying, IN p_order_id character varying) function.
At the line 964 (v_Reference:=v_Reference || ': ' || Cur_InvoiceSchedule.Description;)
If the description of the shipment is empty (NULL), v_Reference is also set to NULL (reminder : something concat to null = null!).
There should be a test before the concatenation, checking if the description of the shipment header is not null (IF (Cur_InvoiceSchedule.Description IS NOT NULL) THEN).
Like that, it is only concatenated if the description is not null.

As a workaround, when the order is created, a description is entered on the header, it is automatically copied on the shipment (if the 'Create Shipments from Orders' process is used), so it is not null. Or one can manually enter the description on the shipment.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0014884

2.50MP24

closed

sivaraman

Empty invoice line when creating invoice (Create Invoices from Orders process)

Notes
(0031904) adrianromero (viewer) 2010-10-18 12:41	This issue is a duplicate of issue 14884.

Issue History
Date Modified	Username	Field	Change
2009-11-11 09:50	neil_smith	New Issue
2009-11-11 09:50	neil_smith	Assigned To	=> rafaroda
2010-02-11 18:13	rafaroda	Assigned To	rafaroda => adrianromero
2010-05-19 15:27	iatienza	Issue Monitored: iatienza
2010-10-14 14:32	networkb	OBNetwork customer	=> Yes
2010-10-14 14:32	networkb	Severity	minor => major
2010-10-14 14:32	networkb	Target Version	=> 2.50MP24
2010-10-14 14:32	networkb	Issue Monitored: networkb
2010-10-15 16:53	networkb	OBNetwork customer	Yes => No
2010-10-15 16:53	networkb	Issue cloned	0014884
2010-10-18 12:41	adrianromero	Relationship added	duplicate of 0014884
2010-10-18 12:41	adrianromero	Note Added: 0031904
2010-10-18 12:41	adrianromero	Status	new => closed
2010-10-18 12:41	adrianromero	Resolution	open => duplicate
2010-10-19 00:00	anonymous	sf_bug_id	0 => 3090004