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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0032440
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2016-03-09 09:232016-06-17 19:36
ReporterngarciaView Statuspublic 
Assigned ToSanjota 
PriorityurgentResolutionfixedFixed in Version3.0PR16Q3
StatusclosedFix in branchFixed in SCM revision571e53e91071
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0032440: Different currency in Simple G/L Journal header and lines

DescriptionDifferent currency in Simple G/L Journal header and lines
Steps To ReproduceAs group admin role:
   Create a Simple G/L Journal header and save it with the default currency shown
   Change the currency and save it again
   Add a line to it
   Check through database that the currency of the line is different from the currency of the header
      select j.documentno, j.c_currency_id, jl.c_currency_id
      from gl_journal j, gl_journalline jl
      where j.gl_journal_id = jl.gl_journal_id
      and j.gl_journal_id = <id>
   Complete it
   Check there is no conversion between lines currency and accounting schema currency
   Try to post it and check the following error message is shown:
      Document currency cannot be converted to the Accounting Schema currency
   Define a currency conversion between them and check you could post the document now although the amount is converted from the header currency to the accounting schema currency
Proposed SolutionChange the Default Value of the C_Currency_ID column of the GL_JournalLine table from @currency@ to @C_Currency_ID@
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to design defect 0032441 closedTriage Omni OMS Organization and Currency fields are showing the last saved value as default value in Simple G/L Journal window 

-  Notes
(0085309)
Sanjota (developer)
2016-03-28 13:35

Test Plan:
* Create a Simple G/L Journal header and save it with the default currency shown
* Change the currency and save it again
* Check through database that the currency of the line is same as currency of the header
* Complete it
* Check there is no currency between lines currency and accounting schema currency
* Try to post it and check the following error message is shown:
   'Document currency cannot be converted to the Accounting Schema currency'
   Define a currency conversion between them and check you could post the document now although the amount is converted from the header currency to the accounting schema currency
(0085346)
psanjuan (manager)
2016-03-31 09:29
edited on: 2016-03-31 12:31

Create a Simple G/L Journal header.
Check that you have below detailed information:

Organization = F&B España
General Ledger = F&B International Group US Dollar
Description (empty). Enter a description such as "Test Issue Currency"
Select the check "Multi-General Ledger". Note that General Ledger field is removed.
Save. Check that the currency shown is EUR.
Change the currency to AED for instance and save.

Add a line to it by selecting a GL Item. Enter a Debit amount = 100
Create another line and select another GL Item. Enter a Credit amount = 100
Complete.

Run this SQL query by adding GL Journal record id

select j.documentno, j.c_currency_id, jl.c_currency_id
      from gl_journal j, gl_journalline jl
      where j.gl_journal_id = jl.gl_journal_id
      and j.gl_journal_id = <id>

For instance

select j.documentno, j.c_currency_id, jl.c_currency_id
      from gl_journal j, gl_journalline jl
      where j.gl_journal_id = jl.gl_journal_id
      and j.gl_journal_id = 'FBEA79CB185A43AEB01844832FD05D78'

Verify that header curreny is 238 (AED) while lines currency is 102 (EUR). This is not correct.

Try to post it. An error is shown saying "Document currency cannot be converted to the Accounting Schema currency".

Go to conversion rates window and enter below conversions valid from 01-03-2016 to 31-03-2016:

AED to EUR 0.512821
EUR to AED 1.95
AED to USD 0.75
USD to AED 1.33333

Go back to the Simple G/L Journal and post it.

Verify below posting is shown:

F&B International Group US Dollar General Ledger:
DEBIT 75.00 (100.00 AED * 0.75)
CREDIT 75.00 (100.00 AED * 0.75)

F&B España EUR General Ledger:
DEBIT 51.28 (100.00 AED * 0.512821)
CREDIT 51.28 (100.00 AED * 0.512821)

Regardless posting is correct, currency of the lines is not.

(0085347)
psanjuan (manager)
2016-03-31 09:29

Issue set as in feedback because it can not be reproduced.
(0085348)
psanjuan (manager)
2016-03-31 10:20
edited on: 2016-03-31 10:24

Issue verified by using SQL query above. Currency set on the lines is not the same that the one in the header.
Once the conversion rate needed is entered in Openbravo, header currency is used to convert to accounting schema currency which is correct.

Real issue here is that currency set on the lines is not the same as the currency in the header.

(0085349)
psanjuan (manager)
2016-03-31 11:00
edited on: 2016-03-31 12:57

Test Plan

Scenario 1 - Simple G/L Journal.

Create a Simple G/L Journal header.
Check that you have below detailed information:

Organization = F&B España
General Ledger = F&B International Group US Dollar
Description (empty). Enter a description such as "Test Issue Currency"
Select the check "Multi-General Ledger". Note that General Ledger field is removed, same as Rate.
Save. Check that the currency shown is EUR.
Change the currency to AED for instance and save.

Add a line to it by selecting a GL Item. Enter a Debit amount = 100
Create another line and select another GL Item. Enter a Credit amount = 100
Complete.

Run this SQL query by adding GL Journal record id

select j.documentno, j.c_currency_id, jl.c_currency_id
      from gl_journal j, gl_journalline jl
      where j.gl_journal_id = jl.gl_journal_id
      and j.gl_journal_id = <id>


For instance

select j.documentno, j.c_currency_id, jl.c_currency_id
      from gl_journal j, gl_journalline jl
      where j.gl_journal_id = jl.gl_journal_id
      and j.gl_journal_id = 'FBEA79CB185A43AEB01844832FD05D78'

Verify that header curreny is 238 (AED) same as line currency 238 (AED).
This is correct.

Try to post it. An error is shown saying "Document currency cannot be converted to the Accounting Schema currency".

Go to conversion rates window and enter below conversions valid from 01-03-2016 to 31-03-2016:

AED to EUR 0.512821
EUR to AED 1.95
AED to USD 0.75
USD to AED 1.33333

Go back to the Simple G/L Journal and post it.

Verify below posting is shown:

F&B International Group US Dollar General Ledger:
DEBIT 75.00 (100.00 AED * 0.75)
CREDIT 75.00 (100.00 AED * 0.75)

F&B España EUR General Ledger:
DEBIT 51.28 (100.00 AED * 0.512821)
CREDIT 51.28 (100.00 AED * 0.512821)


Scenario 2 - Simple G/L Journal.

Create a Simple G/L Journal header.
Check that you have below detailed information:

Organization = F&B España
General Ledger = change to F&B España Euro
Description (empty). Enter a description such as "Test Issue Currency"
Save. Check that the currency shown is EUR.

Change the currency to GIP for instance and save.

Check that a conversion rates warning is shown. Enter a rate = 0.75. Save

Add a line to it by selecting an account. Enter a Debit amount = 100
Create another line and select another GL Item. Enter a Credit amount = 100
Complete.

Run this SQL query by adding GL Journal record id

select j.documentno, j.c_currency_id, jl.c_currency_id
      from gl_journal j, gl_journalline jl
      where j.gl_journal_id = jl.gl_journal_id
      and j.gl_journal_id = '8C89808096DB4385BF7EA6B57DC2CF8D'

Verify that header curreny is 166 (GIP) same as line currency 166 (GIP).
This is correct.

Try to post it. An error is shown saying "Document currency cannot be converted to the Accounting Schema currency".

This is not correct because there is a rate entered in the header of the Simple G/L Journal. See issue = 32564

Workaround is:

Go to conversion rates window and enter below conversions valid from 01-03-2016 to 31-03-2016:

GIP to EUR 2.5
EUR to GIP 0.4

Go back to the Simple G/L Journal and post it.

Verify below posting is shown:

F&B España EUR General Ledger:
DEBIT 51.28 (100.00 GIP * 0.75)
CREDIT 51.28 (100.00 GIP * 0.75)

Conversion rate set in the header of Simple G/L Journal is used.

Scenario 3 and 4 - repeat scenarios 1 and 2 for G/L Journal.

(0085356)
psanjuan (manager)
2016-03-31 12:51

Test Plan above verified.

Issue can be code reviewed and closed.
(0085421)
hgbot (developer)
2016-04-04 19:11

Repository: erp/devel/pi
Changeset: 571e53e91071fba9a14e45bd7855249f2092e4c7
Author: Sanjota <sanjota.nelagi <at> promantia.com>
Date: Mon Mar 28 16:16:15 2016 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/571e53e91071fba9a14e45bd7855249f2092e4c7 [^]

Fixes issue 32440: Same currency in Simple G/L Journal header and lines

---
M src-db/database/sourcedata/AD_COLUMN.xml
---
(0085422)
aferraz (manager)
2016-04-04 19:11

Code review OK
(0087416)
hudsonbot (developer)
2016-06-17 19:36

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/0dc7be081b1c [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2016-03-09 09:23 ngarcia New Issue
2016-03-09 09:23 ngarcia Assigned To => Triage Finance
2016-03-09 09:23 ngarcia Modules => Core
2016-03-09 09:23 ngarcia Resolution time => 1460325600
2016-03-09 09:23 ngarcia Triggers an Emergency Pack => No
2016-03-09 09:42 ngarcia Issue Monitored: networkb
2016-03-09 09:47 ngarcia Steps to Reproduce Updated View Revisions
2016-03-09 11:00 ngarcia Relationship added related to 0032441
2016-03-22 12:36 Sanjota Assigned To Triage Finance => Sanjota
2016-03-22 12:36 Sanjota Status new => scheduled
2016-03-28 13:35 Sanjota Note Added: 0085309
2016-03-31 09:29 psanjuan Note Added: 0085346
2016-03-31 09:29 psanjuan Note Added: 0085347
2016-03-31 09:30 psanjuan Status scheduled => feedback
2016-03-31 09:30 psanjuan Resolution open => unable to reproduce
2016-03-31 09:41 ngarcia Status feedback => scheduled
2016-03-31 09:41 ngarcia Steps to Reproduce Updated View Revisions
2016-03-31 09:58 ngarcia Steps to Reproduce Updated View Revisions
2016-03-31 10:20 psanjuan Note Added: 0085348
2016-03-31 10:24 psanjuan Note Edited: 0085348 View Revisions
2016-03-31 11:00 psanjuan Note Edited: 0085346 View Revisions
2016-03-31 11:00 psanjuan Note Added: 0085349
2016-03-31 11:02 psanjuan Note Edited: 0085346 View Revisions
2016-03-31 11:03 psanjuan Note Edited: 0085349 View Revisions
2016-03-31 11:04 psanjuan Note Edited: 0085349 View Revisions
2016-03-31 11:04 psanjuan Note Edited: 0085349 View Revisions
2016-03-31 11:07 psanjuan Note Edited: 0085349 View Revisions
2016-03-31 11:17 psanjuan Note Edited: 0085349 View Revisions
2016-03-31 12:29 psanjuan Note Edited: 0085349 View Revisions
2016-03-31 12:31 psanjuan Note Edited: 0085346 View Revisions
2016-03-31 12:31 psanjuan Note Edited: 0085349 View Revisions
2016-03-31 12:39 psanjuan Note Edited: 0085349 View Revisions
2016-03-31 12:51 psanjuan Note Added: 0085356
2016-03-31 12:57 psanjuan Note Edited: 0085349 View Revisions
2016-04-04 19:11 hgbot Checkin
2016-04-04 19:11 hgbot Note Added: 0085421
2016-04-04 19:11 hgbot Status scheduled => resolved
2016-04-04 19:11 hgbot Resolution unable to reproduce => fixed
2016-04-04 19:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/571e53e91071fba9a14e45bd7855249f2092e4c7 [^]
2016-04-04 19:11 aferraz Review Assigned To => aferraz
2016-04-04 19:11 aferraz Note Added: 0085422
2016-04-04 19:11 aferraz Status resolved => closed
2016-04-04 19:13 aferraz Fixed in Version => 3.0PR16Q3
2016-06-17 19:36 hudsonbot Checkin
2016-06-17 19:36 hudsonbot Note Added: 0087416


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker