0008955: Several errors in "Create Invoices from Orders" form

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0008955

Openbravo ERP

07. Sales management

public

2009-05-07 16:44

2012-09-10 16:36

Reporter

jtarbal

Assigned To

naiaramartinez

Priority

normal

Severity

minor

Reproducibility

always

Status

scheduled

Resolution

open

Platform

OS Version

Product Version

2.50

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

0008955: Several errors in "Create Invoices from Orders" form

Description

When using the "Create Invoices from Orders" form, we have detected the following errors:
1.- The Sales Invoice that is generated has a line that do not contain any product nor description. This blank line should not be added to the Invoice
2.- The Sales Invoice lines are only linked to the Sales Order lines, but not to the Goods Shipment line. However, when navigating to a Sales Order line, this is linked to both the Sales Invoice and the Goods Shipment lines.

Steps To Reproduce

1) Create a new Sales Order with Transaction Document = Warehouse Order and Invoice Terms = Immediate
2) Create a new line
3) Complete this Sale Order: a shipment is created.
4) Go to Create Invoices from Orders or Generate Invoices processes and select the previous order.
Go to the invoice created and notice that the line is linked only to the sale order line and not to the shipment line.

Proposed Solution

The fix is more complex than initially expected.

This scenario is an example of the complexity involved.

Create a new Product.

Create a new Physical Inventory for a Warehouse.
Create 3 lines for this Physical Inventory. All of them for the same product, with Quantity on hand 5. And each one of them for a different Storage Bin.
Process the Physical Inventory.

Now the previous Warehouse has a total available stock of the new Product of 15 units, but it has it split in 3 different Storage Bins.

Create the Order with Transaction Document = Warehouse Order and Invoice Terms = Immediate
Create a new line
Complete this Sale Order: a shipment is created.

The Order has one order line, but the Shipment has 3 shipment lines.
When creating the Invoice, it must have 3 Invoice lines, each one related to a different Shipment Line.

Additional Information

Tags

VMA-Reviewed

Relationships

related to	feature request	0005604		acknowledged	rmorley	Avoiding additional lines in Create invoice from Orders for warehouse orders
related to	defect	0008780		closed	rajagopal	Create invoices from order: Creates blank line with no description (PostgreSQL)