0021415: Ability to define a write-off limit by amount per financial account - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

ID

Project

Category

View Status

Date Submitted

Last Update

0021415

Openbravo ERP

09. Financial management

public

2012-08-22 13:25

2012-09-26 17:19

Reporter

psarobe

Assigned To

Sandrahuguet

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS

5

OS Version

Product Version

pi

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

dmiguelez

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

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

Description

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

N/A

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

has duplicate	feature request	0020012		closed	mirurita	Let the user configure the "Write off the difference" maximum amount
related to	defect	0021891		closed	pramakrishnan	Not needed section (Bank) in the Financial Account window

Attached Files

Issue History

Date Modified

Username

Field

Change

2012-08-22 13:25

New Issue

2012-08-22 13:25

Assigned To

=> Sandrahuguet

2012-08-22 13:25

Modules

=> Core

2012-08-22 13:32

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

Description Updated

bug_revision_view_page.php?rev_id=3744#r3744

2012-08-22 13:44

Description Updated

bug_revision_view_page.php?rev_id=3745#r3745

2012-08-22 13:51

Description Updated

bug_revision_view_page.php?rev_id=3746#r3746

2012-08-29 10:31

Status

new => scheduled

2012-08-29 10:31

fix_in_branch

=> pi

2012-09-06 13:02

Note Added: 0051901

2012-09-06 13:19

Note Edited: 0051901

bug_revision_view_page.php?bugnote_id=0051901#r3809

2012-09-06 13:28

Note Edited: 0051901

bug_revision_view_page.php?bugnote_id=0051901#r3810

2012-09-06 13:34

Note Edited: 0051901

bug_revision_view_page.php?bugnote_id=0051901#r3811

2012-09-06 13:38

Note Edited: 0051901

bug_revision_view_page.php?bugnote_id=0051901#r3812

2012-09-06 13:42

Note Edited: 0051901

bug_revision_view_page.php?bugnote_id=0051901#r3813

2012-09-14 20:22

Checkin

2012-09-14 20:22

Note Added: 0052147

2012-09-14 20:22

Status

scheduled => resolved

2012-09-14 20:22

Resolution

open => fixed

2012-09-14 20:22

Fixed in SCM revision

=> http://code.openbravo.com/erp/devel/pi/rev/f7657cc77788d3a38c4c245736bfc87d746a79ce [^]

2012-09-14 20:22

Checkin

2012-09-14 20:22

Note Added: 0052148

2012-09-25 14:47

Relationship added

related to 0020012

2012-09-25 15:57

mirurita

Relationship replaced

has duplicate 0020012

2012-09-26 10:39

Closed by

=> dmiguelez

2012-09-26 10:39

Note Added: 0052614

2012-09-26 10:39

Status

resolved => closed

2012-09-26 17:19

Checkin

2012-09-26 17:19

Note Added: 0052765

2012-09-26 17:19

Checkin

2012-09-26 17:19

Note Added: 0052766

2012-10-09 16:10

Relationship added

related to 0021891

Notes

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