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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013697
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajorhave not tried2010-06-18 12:332010-10-30 11:24
ReporterarunkumarView Statuspublic 
Assigned Tosivaraman 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision1250e8f1c3d9
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013697: Discount is still applied to sales invoice even it it was made as inactive

DescriptionCreate a discount of 20% and apply it to sales invoice. After that make the discount status as inactive.Now complete a newly created invoice.Still you can see the discount is applied to the sales invoice.
Steps To ReproduceSetup
1: Create a product with below details
Name: Discount 20% , product Category: Discounts, UOM:Unit, Product Type: Item, Purchase & Sales: Checked

2) Navigate to Discount tab (Master Data Management || Business Partner Setup || Discount || Discount ) and click new, then enter the below details
Name: Discount 20% for BP:CUSA apply only to invoice , Product: Discount 20%, Discount %: 20.00

3) Navigate to Business partner window (Master Data Management || Business Partner || Business Partner ) and select the customer : Customer A and then navigate to "Discount" tab, then click New and enter the below details

Discount: Discount 20% for BP:CUSA apply only to invoice, Apply in order: unchecked (critical, please make sure you unchecked this checkbox) , Customer:Checked

Precondition:
1) Navigate to Discount tab (Master Data Management || Business Partner Setup || Discount || Discount ) and select the record with Name: Discount 20% for BP:CUSA apply only to invoice
Then uncheck the "Active" checkbox to make the record inactive

steps:
1) Create and complete a sales Invoice with the below details
BP: Customer A
Product: FGA
Qty: 125
and on complete of invoice, verify the 20% of Net Total amount not applied to the invoice

But you can see the 20% discount is still applied here.

TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0031874)
hgbot (developer)
2010-10-15 10:32

 Repository: erp/devel/pi
Changeset: 1250e8f1c3d9d61c3e932e27e0cefd1b5959ed01
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
Date: Fri Oct 15 14:00:55 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/1250e8f1c3d9d61c3e932e27e0cefd1b5959ed01 [^]

Fixes issue 13697: Discount is still applied to sales invoice even it it was made as inactive

In C_INVOICE_TRG2 Trigger, one more AND clause has been added that will check whether discount is active or not before inserting it into C_INVOICE_DISCOUNT table.

---
M src-db/database/model/triggers/C_INVOICE_TRG2.xml
---
(0031875)
sivaraman (reporter)
2010-10-15 10:34

 Steps to test:

Kindly follow the steps as given in 'Steps To Reproduce' section and verify if inactive discount is not applied
(0031932)
hudsonbot (developer)
2010-10-18 17:39

 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/1250e8f1c3d9 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/e1c7df1ae349 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18559.obx [^]
(0032039)
sureshbabu (reporter)
2010-10-21 07:51

 The mentioned issue is rightly fixed, but while retesting i found one more issue, that is while reactivating the invoice, discount line in Discount tab not getting deleted. Because of that even when i deactivate the discount, when i try to complete the reactivated the sales invoices discount % still applies to the sales invoice. Tested in postgres context

- Issue History
Date Modified Username Field Change
2010-06-18 12:33 arunkumar New Issue
2010-06-18 12:33 arunkumar Assigned To => adrianromero
2010-10-15 10:29 sivaraman Assigned To adrianromero => sivaraman
2010-10-15 10:32 hgbot Checkin
2010-10-15 10:32 hgbot Note Added: 0031874
2010-10-15 10:32 hgbot Status new => resolved
2010-10-15 10:32 hgbot Resolution open => fixed
2010-10-15 10:32 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1250e8f1c3d9d61c3e932e27e0cefd1b5959ed01 [^]
2010-10-15 10:34 sivaraman Note Added: 0031875
2010-10-18 17:39 hudsonbot Checkin
2010-10-18 17:39 hudsonbot Note Added: 0031932
2010-10-21 07:51 sureshbabu Note Added: 0032038
2010-10-21 07:51 sureshbabu Note Deleted: 0032038
2010-10-21 07:51 sureshbabu Note Added: 0032039
2010-10-21 07:51 sureshbabu Status resolved => closed
2010-10-30 11:24 anonymous sf_bug_id 0 => 3098724

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker