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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0006866
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2009-01-13 13:172009-02-23 11:56
ReporternetworkbView Statuspublic 
Assigned Togorkaion 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision11894
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

DescriptionThe automatic invoicing process (Sales Management > Transactions > Generate Invoices)
does not invoice the orders that have been shipped in a single goods shipment.
Steps To Reproduce1. 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 SolutionThe 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.
Tagscomsup_sprint4
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0006869 closedgorkaion Generate invoices process doesn't work for orders with "Customer Schedule After Delivery" invoice terms 
depends on backport 0006870 closedgorkaion Generate invoices process doesn't work for orders with "Customer Schedule After Delivery" invoice terms 

-  Notes
(0012191)
gorkaion (developer)
2009-01-14 19:24

 Bugfix 6866. 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.
This commit also fixes an UUID problem in the C_Invoice_Post procedure.
(0013838)
sureshbabu (reporter)
2009-02-20 13:52

 still i am not able to create a invoice for PO with invoice term as 'Customer schedule after delivery'

Retested in context 79.125.56.185/openbravotrunk
(0013865)
gorkaion (developer)
2009-02-20 17:53

 I have done some tests in several machines using trunk (postgresql and oracle) and a 2.40 instance using postgresql and in all cases the invoice is generated correctly.

I've tried to test in your proposed context, but I've found an postgresql problem related to the fix of issues 0007678 and 0007679 that is fixed in the revision 13480. When this last fix is applied in that machine I'll try again to reproduce the problem.
(0013870)
gorkaion (developer)
2009-02-20 18:45

 I have just tested in the 79.125.56.185/openbravotrunk context and it is working. Please confirm that it is fixed or provide more detailed steps to reproduce the error.

- Issue History
Date Modified Username Field Change
2009-01-13 13:17 networkb New Issue
2009-01-13 13:17 networkb Assigned To => rafaroda
2009-01-13 13:17 networkb sf_bug_id 0 => 2504422
2009-01-13 13:17 networkb Regression testing => No
2009-01-13 16:10 networkb version => 2.40
2009-01-13 16:32 psarobe Severity minor => major
2009-01-13 16:33 psarobe Status new => scheduled
2009-01-13 16:33 psarobe fix_in_branch => trunk
2009-01-14 11:24 rafaroda Assigned To rafaroda => gorkaion
2009-01-14 19:24 gorkaion Status scheduled => resolved
2009-01-14 19:24 gorkaion svn_revision => 11894
2009-01-14 19:24 gorkaion Resolution open => fixed
2009-01-14 19:24 gorkaion Note Added: 0012191
2009-01-23 11:32 gorkaion Tag Attached: comsup_sprint4
2009-02-20 13:52 sureshbabu Status resolved => new
2009-02-20 13:52 sureshbabu Resolution fixed => open
2009-02-20 13:52 sureshbabu Note Added: 0013838
2009-02-20 17:53 gorkaion Note Added: 0013865
2009-02-20 18:45 gorkaion Note Added: 0013870
2009-02-20 18:45 gorkaion Status new => feedback
2009-02-23 11:56 psarobe Status feedback => scheduled
2009-02-23 11:56 psarobe Status scheduled => resolved
2009-02-23 11:56 psarobe Resolution open => fixed
2009-02-23 11:56 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker