Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0019532

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

major

always

2012-01-20 10:58

2012-01-26 18:26

Reporter

psarobe

View Status

public

Assigned To

gorkaion

Priority

immediate

Resolution

fixed

Fixed in Version

3.0MP8

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

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

Description

When 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 Reproduce

1. 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

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0019225	3.0MP8	closed	jecharri	Data of payment plan are not updated if you close the order
depends on	defect	0019534		closed	gorkaion	Qty ordered gets updated to qty delivered even when the qty invoiced is bigger than qty delivered when closing the order

Notes
(0044518) gorkaion (developer) 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 (developer) 2012-01-24 17:45	fixed in https://code.openbravo.com/erp/devel/pi/rev/331403eece14 [^]

(0044619) psarobe (manager) 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 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