Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040091Openbravo ERP09. Financial managementpublic2019-01-31 16:582019-02-07 03:27
ReporterSandrahuguet 
Assigned Tomarkmm82 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusscheduledResolutionopen 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040091: If converted amount is zero the document should be disabled for accounting.
DescriptionWhen 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 ReproduceAs 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 SolutionShow the following warning message:

Warning
Total Gross Amount of the invoice is zero. Invoice is disabled for accounting.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0039969 closed markmm82 Process failed during execution when posting a payment/transaction/reconciliation of a Cash VAT invoice with different currency 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-01-31 16:58SandrahuguetNew Issue
2019-01-31 16:58SandrahuguetAssigned To => Triage Finance
2019-01-31 16:58SandrahuguetModules => Core
2019-01-31 16:58SandrahuguetTriggers an Emergency Pack => No
2019-01-31 17:08SandrahuguetRelationship addedrelated to 0039903
2019-01-31 17:19SandrahuguetRelationship deletedrelated to 0039903
2019-01-31 17:19SandrahuguetRelationship addedrelated to 0039969
2019-01-31 17:20SandrahuguetAssigned ToTriage Finance => markmm82
2019-02-04 10:51ngarciaIssue Monitored: ngarcia
2019-02-05 21:26markmm82Statusnew => scheduled
2019-02-07 03:27markmm82Note Added: 0109652

Notes
(0109652)
markmm82   
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."