openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #16477
[Bug 1065072] [NEW] [6.1] voucher journal entry not based on correct rate
Public bug reported:
Hello,
test done under 6.1
I noticed that voucher journal entry not based on correct rate. Rate
used is today 's rate instead of payment date (=voucher date) rate.
As we work with our scenario tool OpenERP Scenario
(bzr+ssh://bazaar.launchpad.net/~c2c-oerpscenario/oerpscenario/6.1-main-
focus/), I copied paste our scenario here in order to explain what this
test does exactly :
Thank you
Frederic @ Camptocamp
###############################################################################
#
# OERPScenario, OpenERP Functional Tests
# Copyright 2009 Camptocamp SA
#
##############################################################################
##############################################################################
# Branch # Module # Processes # System
@addons @account_voucher @2 @201
Feature: In order to validate multicurrency account_voucher behaviour.
I create a customer invoice for 1000 USD (rate : 1.5) and pay 500 EUR
(rate : 1). I import this invoice in a bank statement (module
account_voucher is installed). The Journal entries must not calculate
any currency gain/loss nor any write off. After the payment, my invoice
should remains open.
@account_voucher_run
Scenario: Create invoice 201
Given I need a "account.invoice" with oid: scen.voucher_inv_201
And having:
| name | value |
| name | SI_201 |
| date_invoice | %Y-01-01 |
| date_due | %Y-02-15 |
| address_invoice_id | by oid: scen.partner_1_add |
| partner_id | by oid: scen.partner_1 |
| account_id | by name: Debtors |
| journal_id | by name: Sales |
| currency_id | by name: USD |
| type | out_invoice |
Given I need a "account.invoice.line" with oid: scen.voucher_inv201_line201
And having:
| name | value |
| name | invoice line 201 |
| quantity | 1 |
| price_unit | 1000 |
| account_id | by name: Sales |
| invoice_id | by oid:scen.voucher_inv_201 |
Given I find a "account.invoice" with oid: scen.voucher_inv_201
And I open the credit invoice
@account_voucher_run
Scenario: Create Statement 201
Given I need a "account.bank.statement" with oid: scen.voucher_statement_201
And having:
| name | value |
| name | Bk.St.201 |
| date | %Y-02-15 |
| currency_id | by name: EUR |
| journal_id | by oid: scen.voucher_eur_journal |
And the bank statement is linked to period "02/%Y"
@account_voucher_run @account_voucher_import_invoice
Scenario: Import invoice into statement
Given I find a "account.bank.statement" with oid: scen.voucher_statement_201
And I import invoice "SI_201" using import invoice button
@acccout_voucher_run @account_statement_line_amount_modified
Scenario: Modify the paid amount of the imported invoice to pay partialy my invoice
Given I need a "account.bank.statement.line" with name: SI_201
Then I modify the bank statement line amount to 500
@account_voucher_run @account_voucher_confirm
Scenario: confirm bank statement
Given I find a "account.bank.statement" with oid: scen.voucher_statement_201
And I set bank statement end-balance
When I confirm bank statement
@account_voucher_run @account_voucher_valid_201
Scenario: validate voucher
Given I find a "account.bank.statement" with oid: scen.voucher_statement_201
Then I should have following journal entries in voucher:
| date | period | account | debit | credit | curr.amt | curr. | reconcile | partial |
| %Y-02-15 | 02/%Y | Debtors | | 500.00 | -900.00 | USD | | yes |
| %Y-02-15 | 02/%Y | EUR bank account | 500.00 | | | | | |
# BUG : today (oct-2012), the currency amount is -815.00 based on oct-12 rate (1.63) instead -900.00 of feb-12 rate (1.8). This currency amount is used to calculate the residual amount on the invoice
@account_voucher_run @account_voucher_valid_invoice_201
Scenario: validate voucher
Given My invoice "SI_201" is in state "open" reconciled with a residual amount of "100"
** Affects: openobject-addons
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1065072
Title:
[6.1] voucher journal entry not based on correct rate
Status in OpenERP Addons (modules):
New
Bug description:
Hello,
test done under 6.1
I noticed that voucher journal entry not based on correct rate. Rate
used is today 's rate instead of payment date (=voucher date) rate.
As we work with our scenario tool OpenERP Scenario
(bzr+ssh://bazaar.launchpad.net/~c2c-oerpscenario/oerpscenario/6.1
-main-focus/), I copied paste our scenario here in order to explain
what this test does exactly :
Thank you
Frederic @ Camptocamp
###############################################################################
#
# OERPScenario, OpenERP Functional Tests
# Copyright 2009 Camptocamp SA
#
##############################################################################
##############################################################################
# Branch # Module # Processes # System
@addons @account_voucher @2 @201
Feature: In order to validate multicurrency account_voucher behaviour.
I create a customer invoice for 1000 USD (rate : 1.5) and pay 500 EUR
(rate : 1). I import this invoice in a bank statement (module
account_voucher is installed). The Journal entries must not calculate
any currency gain/loss nor any write off. After the payment, my
invoice should remains open.
@account_voucher_run
Scenario: Create invoice 201
Given I need a "account.invoice" with oid: scen.voucher_inv_201
And having:
| name | value |
| name | SI_201 |
| date_invoice | %Y-01-01 |
| date_due | %Y-02-15 |
| address_invoice_id | by oid: scen.partner_1_add |
| partner_id | by oid: scen.partner_1 |
| account_id | by name: Debtors |
| journal_id | by name: Sales |
| currency_id | by name: USD |
| type | out_invoice |
Given I need a "account.invoice.line" with oid: scen.voucher_inv201_line201
And having:
| name | value |
| name | invoice line 201 |
| quantity | 1 |
| price_unit | 1000 |
| account_id | by name: Sales |
| invoice_id | by oid:scen.voucher_inv_201 |
Given I find a "account.invoice" with oid: scen.voucher_inv_201
And I open the credit invoice
@account_voucher_run
Scenario: Create Statement 201
Given I need a "account.bank.statement" with oid: scen.voucher_statement_201
And having:
| name | value |
| name | Bk.St.201 |
| date | %Y-02-15 |
| currency_id | by name: EUR |
| journal_id | by oid: scen.voucher_eur_journal |
And the bank statement is linked to period "02/%Y"
@account_voucher_run @account_voucher_import_invoice
Scenario: Import invoice into statement
Given I find a "account.bank.statement" with oid: scen.voucher_statement_201
And I import invoice "SI_201" using import invoice button
@acccout_voucher_run @account_statement_line_amount_modified
Scenario: Modify the paid amount of the imported invoice to pay partialy my invoice
Given I need a "account.bank.statement.line" with name: SI_201
Then I modify the bank statement line amount to 500
@account_voucher_run @account_voucher_confirm
Scenario: confirm bank statement
Given I find a "account.bank.statement" with oid: scen.voucher_statement_201
And I set bank statement end-balance
When I confirm bank statement
@account_voucher_run @account_voucher_valid_201
Scenario: validate voucher
Given I find a "account.bank.statement" with oid: scen.voucher_statement_201
Then I should have following journal entries in voucher:
| date | period | account | debit | credit | curr.amt | curr. | reconcile | partial |
| %Y-02-15 | 02/%Y | Debtors | | 500.00 | -900.00 | USD | | yes |
| %Y-02-15 | 02/%Y | EUR bank account | 500.00 | | | | | |
# BUG : today (oct-2012), the currency amount is -815.00 based on oct-12 rate (1.63) instead -900.00 of feb-12 rate (1.8). This currency amount is used to calculate the residual amount on the invoice
@account_voucher_run @account_voucher_valid_invoice_201
Scenario: validate voucher
Given My invoice "SI_201" is in state "open" reconciled with a residual amount of "100"
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1065072/+subscriptions
Follow ups
References
