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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019532
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2012-01-20 10:582012-01-26 18:26
ReporterpsarobeView Statuspublic 
Assigned Togorkaion 
PriorityimmediateResolutionfixedFixed in Version3.0MP8
StatusclosedFix in branchpiFixed in SCM revision331403eece14
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019532: Payment schedule detail does not get updated when you close the order

DescriptionWhen you have a sales order and you invoice it but without delivering anything or less than the quantity invoiced then the data becomes inconsistent when closing the sales order. For example.

Before closing:
Amount 1000€, ordered 1000€, delivered 0€, invoiced 1000€
Payment schedule detail 1000€

After closing:
Amount 0€, ordered 0€, delivered 0€, invoiced 1000€
Payment schedule detail 1000# and THIS IS WRONG
Steps To Reproduce1. Login as Openbravo/openbravo
2. Change the role to QA testing admin
3. Go to Sales order window. click new
4. Select the Customer A and change the invoice rule to immediate. Save
5. Create a line and select the product Final Good A and quantity 5. Save
6. Click Book. Total gross amount= 10,35
5. Go to Sales invoice and click new. Select Customer A. Save
6. Click the button create lines from and select the above sales order
7. Click the complete button
8. Go back to the above sales order and close the order

Now the amount is 0 which is correct but the Payment in Plan remains as 10,35

Tables for this order:

Fin_payment_schedule still shows 10,35
Fin_payment_scheduledetails shows 10,35

TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00192253.0MP8 closedjecharri Data of payment plan are not updated if you close the order 
depends on defect 0019534 closedgorkaion Qty ordered gets updated to qty delivered even when the qty invoiced is bigger than qty delivered when closing the order 

-  Notes
(0044518)
gorkaion (viewer)
2012-01-24 17:26

 Developer steps to test the fix.

Several test cases have been designed based on the delivered, invoiced and paid amounts. All test cases have been tested in both Sales and Purchase flows using Oracle. On postgresql test case #4 for purchases and #7 for sales have been tested.

test case number;ordered qty;delivered qty;invoiced qty;paid qty
1;10;8;0;0
2;10;5;8;0
3;10;5;3;0
4;10;0;5;0
5;10;3;5;0
6;10;5;5;5
7;10;5;6;3
8;10;0;5;8

Step to test each case:
1 Create order and book
2 Create receipt/shipment, invoice and payment if necessary.
3 Close order
4 Check in database order's fin_payment_scheduledetails
(0044522)
gorkaion (viewer)
2012-01-24 17:45

 fixed in
https://code.openbravo.com/erp/devel/pi/rev/331403eece14 [^]
(0044619)
psarobe (viewer)
2012-01-26 18:26

 Works fine

- Issue History
Date Modified Username Field Change
2012-01-20 10:58 psarobe New Issue
2012-01-20 10:58 psarobe Assigned To => jonalegriaesarte
2012-01-20 10:58 psarobe Modules => Core
2012-01-20 10:58 psarobe OBNetwork customer => No
2012-01-20 11:05 jonalegriaesarte Assigned To jonalegriaesarte => jecharri
2012-01-20 11:08 jonalegriaesarte Relationship added related to 0019225
2012-01-20 11:21 psarobe Assigned To jecharri => jonalegriaesarte
2012-01-20 11:21 psarobe Steps to Reproduce Updated View Revisions
2012-01-20 11:29 psarobe Relationship added depends on 0019534
2012-01-23 10:41 gorkaion Assigned To jonalegriaesarte => gorkaion
2012-01-24 17:26 gorkaion Note Added: 0044518
2012-01-24 17:45 gorkaion Status new => scheduled
2012-01-24 17:45 gorkaion fix_in_branch => pi
2012-01-24 17:45 gorkaion Note Added: 0044522
2012-01-24 17:45 gorkaion Status scheduled => resolved
2012-01-24 17:45 gorkaion Fixed in SCM revision => 331403eece14
2012-01-24 17:45 gorkaion Resolution open => fixed
2012-01-26 18:26 psarobe Note Added: 0044619
2012-01-26 18:26 psarobe Status resolved => closed
2012-01-26 18:26 psarobe Fixed in Version => 3.0MP8

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker