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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013999
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2010-07-19 15:472010-10-22 12:12
ReporternetworkbView Statuspublic 
Assigned Todalsasua 
PriorityimmediateResolutionfixedFixed in Version2.50MP23
StatusclosedFix in branchFixed in SCM revisiona8dc1c241ec4
ProjectionnoneETAnoneTarget Version2.50MP23
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product Version2.50MP19SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013999: invoice post does not work when exists debt payment with same amount in negative that invoice debt payment

DescriptionIn purchase invoice, when exists a debt payment with the same amount in negative that invoice debt payment and distinct isreceipt, the two debt payments are included in settlement, but when this settlement is processed, error is returned:

Error:
The amounts of the Canceled not charge and Generated amount do not match
Steps To ReproduceFinancial Management || Receivables & Payables || Transactions || Bank Statement || Header
. create bank statement

Financial Management || Receivables & Payables || Transactions || Bank Statement || Line
. create a new line:
     run process create debt payment:
       business partner: McGiver Supplies
       amount: 100
       due date: 10/07/2010
       receipt is checked

run process bank statement

. Procurement Management || Transactions || Purchase Invoice || Header
 . create new invoice:
    business partner: mcGiver
    Transaction document: AP Invoice

. Procurement Management || Transactions || Purchase Invoice || Lines
 . create new line:
   product boots
   qty 100
   Net Unit Price 1
   Net List Price 1
   Tax: Exempt

. run process invoice
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0029549)
psarobe (manager)
2010-07-26 10:59

 Hi,

I cannot reproduce the issue. Works perfect for me. Maybe you got confused with the steps

Can you please try it again?

Thanks
(0029626)
hgbot (developer)
2010-07-28 07:08

 Repository: erp/devel/pi
Changeset: acce63739f67f538fbe80d91927bd224f27a84a5
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Wed Jul 28 10:37:35 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/acce63739f67f538fbe80d91927bd224f27a84a5 [^]

Fixes Issue 13999: invoice post does not work when exists debt payment

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0029638)
hudsonbot (developer)
2010-07-28 12:29

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/acce63739f67 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/0f307f2c6481 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17929.obx [^]
(0029655)
sureshbabu (reporter)
2010-07-29 09:01

 Verified, followed the steps mentioned in the defect its working perfect now
(0031793)
hgbot (developer)
2010-10-13 10:18

 Repository: erp/devel/pi
Changeset: 48933d28a14f62a490e714bd453d43af9473352f
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Oct 08 16:27:42 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/48933d28a14f62a490e714bd453d43af9473352f [^]

Fixes issue 13999: invoice post does not work when exists debt payment

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0031795)
dalsasua (reporter)
2010-10-13 10:23

 This issue is re-opened, as the fix caused the regression 0014791
(0031796)
dalsasua (reporter)
2010-10-13 10:24

 Rollbacked fix
(0031830)
psarobe (manager)
2010-10-13 19:49

 Change the target version and the priority since this issue was supposed to be already fixed. It has to be in MP23
(0031838)
hudsonbot (developer)
2010-10-13 23:38

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/48933d28a14f [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/c531f0a7334b [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18531.obx [^]
(0031843)
hgbot (developer)
2010-10-14 08:38

 Repository: erp/devel/pi
Changeset: a8dc1c241ec418e2cdf499567501ace4b23d717a
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Oct 13 13:14:01 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a8dc1c241ec418e2cdf499567501ace4b23d717a [^]

Fixes issue 13999: invoice post does not work

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0031864)
hudsonbot (developer)
2010-10-14 22:29

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/a8dc1c241ec4 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d7ad2f964c30 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18536.obx [^]
(0032090)
sureshbabu (reporter)
2010-10-22 06:31

 @David, still i am finding the same issue when i try to process the settlement document after including both the payments.

Right now i am getting error as "Error: The amounts of the Canceled not charge and Generated amount do not match"

Note: Tested in both the contexts (Oracle, postgres) @ live.builds.com
(0032107)
psarobe (manager)
2010-10-22 12:12

 Tested it is working fine.

Hi Suresh, What you are trying to do it is correct that is not allowed. I see that you are doing is apart from the steps to reproduce but let me explain to you why it is correct the behaviour you are experience.
You have a, for example, -100€ payment (receipt/sales) and also a payment (purchase) of 100.
Take into account that -100 payment (receipt) is the same as 100 payment (purchase). So finally what you are basically doing is trying to cancel:
100 €
100 €
That comes out into 200€ and not in 0€ so that the reason why you cannot cancel both against nothing

- Issue History
Date Modified Username Field Change
2010-07-19 15:47 networkb New Issue
2010-07-19 15:47 networkb Assigned To => dalsasua
2010-07-26 08:19 sathiyan Assigned To dalsasua => sathiyan
2010-07-26 10:59 psarobe Note Added: 0029549
2010-07-26 10:59 psarobe Status new => feedback
2010-07-26 11:19 networkb Status feedback => new
2010-07-26 11:19 networkb Steps to Reproduce Updated View Revisions
2010-07-26 11:59 sathiyan Status new => scheduled
2010-07-26 11:59 sathiyan fix_in_branch => pi
2010-07-28 07:08 hgbot Checkin
2010-07-28 07:08 hgbot Note Added: 0029626
2010-07-28 07:08 hgbot Status scheduled => resolved
2010-07-28 07:08 hgbot Resolution open => fixed
2010-07-28 07:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/acce63739f67f538fbe80d91927bd224f27a84a5 [^]
2010-07-28 12:29 hudsonbot Checkin
2010-07-28 12:29 hudsonbot Note Added: 0029638
2010-07-29 09:01 sureshbabu Note Added: 0029655
2010-07-29 09:01 sureshbabu Status resolved => closed
2010-07-30 00:00 anonymous sf_bug_id 0 => 3036808
2010-10-13 10:18 hgbot Checkin
2010-10-13 10:18 hgbot Note Added: 0031793
2010-10-13 10:18 hgbot Status closed => resolved
2010-10-13 10:18 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/acce63739f67f538fbe80d91927bd224f27a84a5 [^] => http://code.openbravo.com/erp/devel/pi/rev/48933d28a14f62a490e714bd453d43af9473352f [^]
2010-10-13 10:23 dalsasua Note Added: 0031795
2010-10-13 10:23 dalsasua Status resolved => new
2010-10-13 10:23 dalsasua Resolution fixed => open
2010-10-13 10:24 dalsasua Status new => scheduled
2010-10-13 10:24 dalsasua Note Added: 0031796
2010-10-13 10:24 dalsasua Assigned To sathiyan => dalsasua
2010-10-13 19:49 psarobe Priority high => immediate
2010-10-13 19:49 psarobe Target Version 2.50MP21 => 2.50MP23
2010-10-13 19:49 psarobe fix_in_branch pi =>
2010-10-13 19:49 psarobe Note Added: 0031830
2010-10-13 23:38 hudsonbot Checkin
2010-10-13 23:38 hudsonbot Note Added: 0031838
2010-10-14 08:38 hgbot Checkin
2010-10-14 08:38 hgbot Note Added: 0031843
2010-10-14 08:38 hgbot Status scheduled => resolved
2010-10-14 08:38 hgbot Resolution open => fixed
2010-10-14 08:38 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/48933d28a14f62a490e714bd453d43af9473352f [^] => http://code.openbravo.com/erp/devel/pi/rev/a8dc1c241ec418e2cdf499567501ace4b23d717a [^]
2010-10-14 22:29 hudsonbot Checkin
2010-10-14 22:29 hudsonbot Note Added: 0031864
2010-10-22 06:31 sureshbabu Note Added: 0032090
2010-10-22 12:12 psarobe Note Added: 0032107
2010-10-22 12:12 psarobe Status resolved => closed
2010-10-22 12:12 psarobe Fixed in Version => 2.50MP23

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker