Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0040091

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 09. Financial management

minor

have not tried

2019-01-31 16:58

2019-02-07 03:27

Reporter

Sandrahuguet

View Status

public

Assigned To

markmm82

Priority

normal

Resolution

open

Fixed in Version

Status

scheduled

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Linux 64 bit

Database

PostgreSQL

Java version

7.x

OS Version

Openbravo Appliance 14.04

Database version

9.3.x

Ant version

1.9.x

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

0040091: If converted amount is zero the document should be disabled for accounting.

Description

When a document is created in foreign currency, to be deposited in the financial account is converted to the financial account currency.
If the result of this conversion is zero, the document should be disabled for accounting. (same behavior of a document with amount zero)

Steps To Reproduce

As Group Admin:

Go to Price List window and create new one.
    Organization = F&B España, S.A.
    Name = MXN
    Currency = MXN
    Sales Price List = Y
  Go to Price List Version and define a new one:
    Name = MXN
    Valid From = Yesterday
  Add a Product Price for it:
    Product = Agua sin Gas 1L
    Unit Price = 10.00
    List Price = 10.00

  Define a conversion of 0.04 between MXN and EUR
    Currency = MXN
    To Currency = EUR
    Valid from Date = Yesterday
    Multiple Rate By = 0.04
    Divide Rate By = 25
  Define a conversion of 0.04 between MXN and USD
    Currency = MXN
    To Currency = USD
    Valid from Date = Yesterday
    Multiple Rate By = 0.05
    Divide Rate By = 19

  Go to Cuenta de Banco Financial Account
    Go to Payment Method tab and select Transferencia Payment method
      Allow the Payment IN to receive Payments in Multiple Currencies

  Create a Sales Invoice
   Select previously created MXN price list (with MXN currency)
   Add a line and select previously created tax rate and product
   Complete it

   Add a payment of 0.06 to it with today's date
   Add a new payment with the pending amount and a different date

   Navigate to the payment of 0.06, check that received in the financial account is 0.
   Check in accounting tab a wrong row of 0 is generated.

Proposed Solution

Show the following warning message:

Warning
Total Gross Amount of the invoice is zero. Invoice is disabled for accounting.

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

closed

Process failed during execution when posting a payment/transaction/reconciliation of a Cash VAT invoice with different currency

Notes
(0109652) markmm82 (developer) 2019-02-07 03:27	Test Plan: As Group Admin: Go to Price List window and create new one. Organization = F&B España, S.A. Name = MXN Currency = MXN Sales Price List = Y Go to Price List Version and define a new one: Name = MXN Valid From = Yesterday Add a Product Price for it: Product = Agua sin Gas 1L Unit Price = 10.00 List Price = 10.00 Define a conversion of 0.04 between MXN and EUR Currency = MXN To Currency = EUR Valid from Date = Yesterday Multiple Rate By = 0.04 Divide Rate By = 25 Define a conversion of 0.04 between MXN and USD Currency = MXN To Currency = USD Valid from Date = Yesterday Multiple Rate By = 0.05 Divide Rate By = 19 Go to Cuenta de Banco Financial Account Go to Payment Method tab and select Transferencia Payment method Allow the Payment IN to receive Payments in Multiple Currencies Create a Sales Invoice Select previously created MXN price list (with MXN currency) Add a line and select previously created tax rate and product Complete it Add a payment of 0.06 to it with today's date Add a new payment with the pending amount and a different date Navigate to the payment of 0.06 and try to post it. Notice that a warning message is show: "Warning Total Gross Amount of the document is zero. Document is disabled for accounting."

Issue History
Date Modified	Username	Field	Change
2019-01-31 16:58	Sandrahuguet	New Issue
2019-01-31 16:58	Sandrahuguet	Assigned To	=> Triage Finance
2019-01-31 16:58	Sandrahuguet	Modules	=> Core
2019-01-31 16:58	Sandrahuguet	Triggers an Emergency Pack	=> No
2019-01-31 17:08	Sandrahuguet	Relationship added	related to 0039903
2019-01-31 17:19	Sandrahuguet	Relationship deleted	related to 0039903
2019-01-31 17:19	Sandrahuguet	Relationship added	related to 0039969
2019-01-31 17:20	Sandrahuguet	Assigned To	Triage Finance => markmm82
2019-02-04 10:51	ngarcia	Issue Monitored: ngarcia
2019-02-05 21:26	markmm82	Status	new => scheduled
2019-02-07 03:27	markmm82	Note Added: 0109652

Copyright © 2000 - 2009 MantisBT Group