Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0008955
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 07. Sales managementminoralways2009-05-07 16:442012-09-10 16:36
ReporterjtarbalView Statuspublic 
Assigned Tonaiaramartinez 
PrioritynormalResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

DescriptionWhen 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 Reproduce1) 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 SolutionThe 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.
TagsVMA-Reviewed
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0005604 acknowledgedrmorley Avoiding additional lines in Create invoice from Orders for warehouse orders 
related to defect 0008780 closedrajagopal Create invoices from order: Creates blank line with no description (PostgreSQL) 

-  Notes
(0016561)
RenateNieuwkoop (reporter)
2009-05-21 18:04

just fyi there is also RFE 5604 about blank lines in invoices that I logged a while ago, so maybe it can be combined with the efforts for point 1 on this bug
(0016722)
rafaroda (developer)
2009-05-28 12:43

Point 1 and FR 0005604 have been resolved fixing 0008780

Point 2 remains un-fixed.
(0016803)
rafaroda (developer)
2009-06-01 12:07

Happens also in Openbravo ERP 2.40 branch.
(0016806)
rafaroda (developer)
2009-06-01 12:45

If Invoice Terms = After Delivery, shipment lines are correctly linked to invoice lines.
(0016807)
rafaroda (developer)
2009-06-01 12:57

If in the Sales Order, Print Discount = Y, the line with blank product and 0 amount is created.
(0016809)
rafaroda (developer)
2009-06-01 13:00

Point 1 is re-open and will be addressed in feature request 0005604
(0048576)
naiaramartinez (developer)
2012-05-11 13:40

Test Plan:
  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 created invoice and notice that the line is linked to the sales order line and to the shipment line.

This is only happening when the doctype of the sales order's line is 'Warehouse order'.
(0051969)
dmiguelez (developer)
2012-09-10 16:36

The fix is more complex that initially expected.


- Issue History
Date Modified Username Field Change
2009-05-07 16:44 jtarbal New Issue
2009-05-07 16:44 jtarbal Assigned To => rafaroda
2009-05-07 23:13 psarobe Status new => scheduled
2009-05-07 23:13 psarobe fix_in_branch => pi
2009-05-21 18:04 RenateNieuwkoop Note Added: 0016561
2009-05-28 10:12 rafaroda Relationship added related to 0008780
2009-05-28 10:12 rafaroda Relationship added related to 0005604
2009-05-28 12:43 rafaroda Note Added: 0016722
2009-06-01 12:05 rafaroda Status scheduled => acknowledged
2009-06-01 12:05 rafaroda fix_in_branch pi =>
2009-06-01 12:05 rafaroda Proposed Solution updated
2009-06-01 12:07 rafaroda Note Added: 0016803
2009-06-01 12:45 rafaroda Note Added: 0016806
2009-06-01 12:57 rafaroda Note Added: 0016807
2009-06-01 13:00 rafaroda Note Added: 0016809
2010-02-11 18:05 rafaroda Assigned To rafaroda => adrianromero
2011-06-03 11:00 dalsasua Assigned To adrianromero => dalsasua
2011-07-20 18:11 dalsasua Assigned To dalsasua => jonalegriaesarte
2012-02-15 19:05 iciordia Assigned To jonalegriaesarte => vmromanos
2012-02-16 14:11 vmromanos Tag Attached: VMA-Reviewed
2012-05-10 12:13 gorka_gil Assigned To vmromanos => mirurita
2012-05-11 13:40 naiaramartinez Note Added: 0048576
2012-05-11 13:43 naiaramartinez Assigned To mirurita => naiaramartinez
2012-05-11 13:43 naiaramartinez Status acknowledged => scheduled
2012-05-11 13:43 naiaramartinez fix_in_branch => pi
2012-09-10 16:36 dmiguelez Note Added: 0051969
2012-09-10 16:36 dmiguelez Type defect => design defect
2012-09-10 16:36 dmiguelez fix_in_branch pi =>
2012-09-10 16:36 dmiguelez Proposed Solution updated


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker