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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0021415
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 09. Financial managementmajoralways2012-08-22 13:252012-09-26 17:19
ReporterpsarobeView Statuspublic 
Assigned ToSandrahuguet 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionf7657cc77788
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021415: Ability to define a write-off limit by amount per financial account

DescriptionAbility to define a write-off limit per financial account. To enable this feature there will be a preference that when it is defined (per user or role or org, etc) the user won't be able to write off certain amount above the limit defined.

For example if you defined a limit of 1€ and the invoice is 29.80 € and the customer pays you 29.50 you won't be able to select the option of write off.

Things to do:

* Window Financial account|| transactions tab:
- New field: Type write-off: Values (Percentage; Amount). The percentage value must be disabled since it's not going to be implemented
- New fields: write-off limit:
Both fields will have a display logic and will be shown after the preference is defined
*Create a new preference: Write-off limit

* Expected behaviour:
When the preference is defined:
- In all windows where the write-off can be performed if the user exceeds the limit defined the option to write-off will be shown but disabled with a new Label "Write off the difference (Above limit)"
- If the currency of the invoice/payment is different than the currency of the financial account then the system needs to take this into account and convert the amount into the currency of the FA and check the limit
- If the user select several invoices the limit to check will be the sum of all differences
Steps To ReproduceN/A
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate feature request 0020012 closedmirurita Let the user configure the "Write off the difference" maximum amount 
related to defect 0021891 closedpramakrishnan Not needed section (Bank) in the Financial Account window 

-  Notes
(0051901)
Sandrahuguet (developer)
2012-09-06 13:02
edited on: 2012-09-06 13:42

 Test Plan:
As F&B Group admin
-Go to preference, create new preference
   ·Client: F&B International Group
   ·Organization: *
   ·Property: Not allow to change exchange rate and amount
   ·Value: Y
   ·Visible at client: F&B International Group
   ·Visible at organization: blank
   ·Visible at user: blank
   ·Visible at role: blank
   ·Window: blank
- Logout and login

-Go to Financial Account, select bank -account 1
  ·Tyoe write-off: Amount
  ·Write-off limit: 1

- Go to sales invoice, and create one:
   ·Organization: F&B US, Inc.
   ·Payment Method: Wire transfer
   ·Create line product: lager beer, quantity:100 and complete
   ·Click in Add Payment
   .Payment 263.5
   ·Notice that you can write off
   ·Payment 262.5
   ·Notice that you can not write off
- Go to purchase invoice
   ·Organization: F&B US, Inc.
   ·Business Partner: Be Soft Drinker, Inc.
   ·Payment Method: Wire transfer
   ·Create line product: plain water, quantity:1000 and complete
   ·Click in Add Payment
   .Payment 1019.5
   ·Notice that you can write off
   ·Payment 1018
   ·Notice that you can not write off
- Go to paymet in, and create one:
   ·Organization: F&B US, Inc.
   ·Payment Method: Wire transfer
   ·Paying from: USD - Bank - Account 1
   ·Select two payments, enter an amount to be paid and the difference must be greater than 1
   ·Notice that you can not write off
   ·Select two payments, enter an amount to be paid and the difference should be less or equal 1
   ·Notice that you can write off

- Go to paymet out, and create one:
   ·Organization: F&B US, Inc.
   ·Payment Method: Wire transfer
   ·Paying from: USD - Bank - Account 1
   ·Select two payments, enter an amount to be paid and the difference must be greater than 1
   ·Notice that you can not write off
   ·Select two payments, enter an amount to be paid and the difference should be less or equal 1
   ·Notice that you can write off
- Go to financial account: USD - Bank - Account 1 /payment method, select wire transfer
   ·Receive payments in multiple currencies=yes
   ·Make payments in multiple currencies=yes
   ·Add transaction/Add payment
   ·Currency:EUR
    ·Select one, enter an amount to be paid and the difference converted to USD must be greater than 1
   ·Notice that you can not write off
   ·Select one, enter an amount to be paid and the difference converted to USD should be less or equal 1
   ·Notice that you can write off
Wire Transfer
-Go to payment proposal
  ·Organization: F&B US, Inc.
  ·Paying from: USD - Bank - Account 1
  ·Payment method: Wire Transfer
  ·Click Select Expected payments
  ·Select one, enter an amount to be paid and the difference must be greater than 1 and check writeoff
  ·click in submit
  .The system shows: It is not allow to write off because you have exceeded the write off limit

As QA Admin
- Go to sales invoice, and create one:
   ·Organization: USA
   ·Business Partner: Customer A
   ·Payment Method: 1(USA)
   ·Create line product: tennis ball, quantity:100 and complete
   ·Click in Add Payment
   .Payment 449.30
   ·Notice that you can write off
   ·Payment 400.00
   ·Notice that you can write off
(0052147)
hgbot (developer)
2012-09-14 20:22

 Repository: erp/devel/pi
Changeset: f7657cc77788d3a38c4c245736bfc87d746a79ce
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Fri Sep 14 20:14:05 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f7657cc77788d3a38c4c245736bfc87d746a79ce [^]

Fixed issue 21415 Ability to define a write-off limit

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddOrderOrInvoice.html
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddOrderOrInvoice.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddOrderOrInvoice.xml
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddPaymentFromInvoice.html
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddPaymentFromInvoice.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddPaymentFromInvoice.xml
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddPaymentFromTransaction.html
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddPaymentFromTransaction.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/AddPaymentFromTransaction.xml
M modules/org.openbravo.advpaymentmngt/web/org.openbravo.advpaymentmngt/FIN_Utilities.js
M src-db/database/model/tables/FIN_FINANCIAL_ACCOUNT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/erpCommon/ad_callouts/SE_Payment_MultiCurrency.java
---
(0052148)
hgbot (developer)
2012-09-14 20:22

 Repository: erp/devel/pi
Changeset: 1922c7ff8ac1efb2cffd515cecab61da22a16e58
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri Sep 14 13:52:11 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1922c7ff8ac1efb2cffd515cecab61da22a16e58 [^]

Related to issue 21415 Ability to define a write-off limit
Ability to define a write-off limit by amount per financial account
Commit Payment Proposal

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml
M modules/org.openbravo.advpaymentmngt/web/org.openbravo.advpaymentmngt/js/ob-aprm-utilities.js
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0052614)
dmiguelez (developer)
2012-09-26 10:39

 Code Review + Testing OK
(0052765)
hudsonbot (developer)
2012-09-26 17:19

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b780e90c6452 [^]

Maturity status: Test
(0052766)
hudsonbot (developer)
2012-09-26 17:19

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b780e90c6452 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2012-08-22 13:25 psarobe New Issue
2012-08-22 13:25 psarobe Assigned To => Sandrahuguet
2012-08-22 13:25 psarobe Modules => Core
2012-08-22 13:32 psarobe Summary Ability to define a write-off limit per financial account by amount => Ability to define a write-off limit by amount per financial account
2012-08-22 13:32 psarobe Description Updated View Revisions
2012-08-22 13:44 psarobe Description Updated View Revisions
2012-08-22 13:51 psarobe Description Updated View Revisions
2012-08-29 10:31 Sandrahuguet Status new => scheduled
2012-08-29 10:31 Sandrahuguet fix_in_branch => pi
2012-09-06 13:02 Sandrahuguet Note Added: 0051901
2012-09-06 13:19 Sandrahuguet Note Edited: 0051901 View Revisions
2012-09-06 13:28 Sandrahuguet Note Edited: 0051901 View Revisions
2012-09-06 13:34 Sandrahuguet Note Edited: 0051901 View Revisions
2012-09-06 13:38 Sandrahuguet Note Edited: 0051901 View Revisions
2012-09-06 13:42 Sandrahuguet Note Edited: 0051901 View Revisions
2012-09-14 20:22 hgbot Checkin
2012-09-14 20:22 hgbot Note Added: 0052147
2012-09-14 20:22 hgbot Status scheduled => resolved
2012-09-14 20:22 hgbot Resolution open => fixed
2012-09-14 20:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f7657cc77788d3a38c4c245736bfc87d746a79ce [^]
2012-09-14 20:22 hgbot Checkin
2012-09-14 20:22 hgbot Note Added: 0052148
2012-09-25 14:47 thirumalaik Relationship added related to 0020012
2012-09-25 15:57 mirurita Relationship replaced has duplicate 0020012
2012-09-26 10:39 dmiguelez Closed by => dmiguelez
2012-09-26 10:39 dmiguelez Note Added: 0052614
2012-09-26 10:39 dmiguelez Status resolved => closed
2012-09-26 17:19 hudsonbot Checkin
2012-09-26 17:19 hudsonbot Note Added: 0052765
2012-09-26 17:19 hudsonbot Checkin
2012-09-26 17:19 hudsonbot Note Added: 0052766
2012-10-09 16:10 vmromanos Relationship added related to 0021891

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker