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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034260
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2016-10-21 06:352016-12-16 18:38
ReporterpradeepvarmaView Statuspublic 
Assigned Tomarkmm82 
PriorityhighResolutionfixedFixed in Version3.0PR17Q1
StatusclosedFix in branchFixed in SCM revisionc5a35b41929c
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

0034260: Currency not getting selected based on the organization selected in Simple G/L Journal

DescriptionThe currency is by defualt set to a default currency when a new record is created in the simple g/l journal window.
And when a different organization is selected the currency is not changed based on the organization selected.
Steps To Reproduce1. Log in to any livebuild instance
2. Open the simple g/l journal record.
-> Default orgn select will be a Spanish orgn and the currency will by EUR.
3. Change the organization to US East cost and check the currency will still remain as EUR.
4. The video for the same is attached here with.
TagsNo tags attached.
Attached Files? file icon currency_of_organization_simple_gl_journal.mp4 [^] (1,315,010 bytes) 2016-10-21 06:35

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0022296 closedmarkmm82 The field currency should be updated with the currency of the general ledger configuration while entering a G/L Journal Header 
related to defect 0033798 schedulednonofrancisco General Ledger is not updated when organization changes 
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
(0091235)
psanjuan (manager)
2016-11-08 13:17

 Issue verified as.

As F&B International Group Admin role set below values as default session values:
Organization : F&B España
Warehouse: España Region Norte
Language : English.

Check "Set as Default", and then press "Apply".

Go to Simple G/L Journal window and create a new one.

Verify that default organization shown is not F&B España but F&B US Inc and the currency is EUR.

Change it to F&B España. Change it to F&B US and check that currency remains as EUR.

This is not correct. Issue verified.
(0091262)
psanjuan (manager)
2016-11-09 11:11
edited on: 2016-11-09 12:08

 Test Plan

Test case 1

As F&B International Group Admin role set
Organization = F&B España
Warehouse = España Region Norte
Language = English
as default values.

Press Apply

Go to Simple G/L Journal and create a new one.
Check that F&B España organization is selected, same as Currency = EUR.
Enter a Description and Save.
Close the window.

Go to Profile and set as default:
Organization = F&B US
Warehouse = US East Cost
Language = English
Press Apply.

Go to Simple G/L Journal and create a new one.
Check that F&B US organization is selected, same as Currency = USD
Enter a Description and Save.
Close the window.

Go to Profile and set as default:
Organization = F&B España - Region Norte.
Warehouse = España Region Norte
Language = English
Press Apply.

Go to Simple G/L Journal and create a new one.
Check that F&B España Region Norte organization is selected, same as Currency = EUR

Change Organization to F&B US.
Check that Currency changes to USD

Change Organization to F&B España without saving.
Check that Currency changes to EUR.

Change Organization to F&B US East Coast without saving.
Check that Currency changes to USD

Test case 2 - USD General Ledger while posting in EUR currency.

Change Organization to F&B España without saving.
Check that currency changes to EUR.
Select General Ledger to F&B International Group US Dollar
Check that currency remains as EUR.

Go to Lines and enter two lines as:
Account 1110 Debit Amount = 100.00 (EUR). Check General Ledger Currency Debit = 120.00 USD (100.00 EUR * 1.2 EUR to USD rate)
Account 1130 Credit Amount = 100.00 (EUR). Check General Ledger Currency Credit = 120.00 USD (100.00 EUR * 1.2 EUR to USD rate)
Complete and post


Verify there is only one journal entries report for F&B International Group US Dollar as shown below:

120.00 (1110) Debit
120.00 (1130) Credit
(0091264)
psanjuan (manager)
2016-11-09 11:44
edited on: 2016-11-09 12:09

 Test Case 3 EUR General Ledger while posting in EUR

Go to Simple G/L Journal and create a new one.
Check that F&B España organization is selected, same as currency = EUR
Check that F&B España US Euro General Ledger is selected.
Enter a description.

Go to lines and create a two new lines with below setup:
10300 account - 100.00 EUR (debit)
10340 account - 100.00 EUR (Credit)
Complete and Post.

Verify there is only one journal entries report for F&B España EUR as shown below:

100.00 (1110) Debit
100.00 (1130) Credit
(0091268)
psanjuan (manager)
2016-11-09 12:11
edited on: 2016-11-09 12:21

 Test Case 4 - Multi-General Ledger while posting in EUR

Go to Simple G/L Journal and create a new one.
Check that F&B España is selected, Currency = EUR.
Enter a Description. Check Multi-General Ledger.

Go to lines and create a two new lines with below setup:
line one - select a G/L item - 100.00 EUR (debit)
line two - select a G/L item - 100.00 EUR (Credit)
Complete and Post.

Verify there are two journal entries reports, one for each General Ledger Account, as G/L Items setup has two accounts one for each General Ledger.

For F&B España EUR as shown below:

100.00 (1110) Debit
100.00 (1130) Credit

For F&B Interantional USD as shown below:

120.00 (1110) Debit
120.00 (1130) Credit
(0091269)
psanjuan (manager)
2016-11-09 12:21
edited on: 2016-11-09 12:21

 Test Case 5 - Multi-General Ledger while posting in USD

Go to Simple G/L Journal and create a new one.
Check that F&B España is selected, Currency = EUR. Change currency to USD.
Enter a Description. Check Multi-General Ledger.

Go to lines and create a two new lines with below setup:
line one - select a G/L item - 100.00 USD (debit)
line two - select a G/L item - 100.00 USD (Credit)
Complete and Post.

Verify there are two journal entries reports, one for each General Ledger Account, as G/L Items setup has two accounts one for each General Ledger.

For F&B España EUR as shown below:

83.33 (1110) Debit
83.33 (1130) Credit

For F&B Interantional USD as shown below:

100.00 (1110) Debit
100.00 (1130) Credit
(0091270)
psanjuan (manager)
2016-11-09 12:22

 Test Plan above verified.

Issue can be code reviewed and closed.
(0091276)
hgbot (developer)
2016-11-09 12:43

 Repository: erp/devel/pi
Changeset: c5a35b41929c37703e651e7775bb0e85881f0725
Author: Mark <markmm82 <at> gmail.com>
Date: Fri Nov 04 09:23:33 2016 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/c5a35b41929c37703e651e7775bb0e85881f0725 [^]

Fixes issue 34260: Currency selected based on org in Simple G/L Journal

When a different organization is selected the currency is changed based on the organization selected.

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src/org/openbravo/erpCommon/ad_callouts/SL_Journal_Period.java
---
(0091277)
hgbot (developer)
2016-11-09 12:44

 Repository: erp/devel/pi
Changeset: e0bcd0b2606d2c69623d2d21cd1bb59e1ac2118c
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Nov 09 11:12:18 2016 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e0bcd0b2606d2c69623d2d21cd1bb59e1ac2118c [^]

Related to issue 34260: Code review improvements

Change GL_JournalBatch | AD_Org_ID default value to login organization.
Change GL_Journal | AD_Org_ID default value to login organization in Simple G/L Journal window and to parent organization in G/L Journal window.
Add callout also to GL_JournalBatch | AD_Org_ID column.
Use OBCurrencyUtils.getOrgCurrency to get organization's currency in SL_Journal_Period.java.

---
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src/org/openbravo/erpCommon/ad_callouts/SL_Journal_Period.java
---
(0091279)
aferraz (manager)
2016-11-09 12:45

 Code review OK
(0092602)
hudsonbot (developer)
2016-12-16 18:38

 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/dc8bf00badd0 [^]
Maturity status: Test
(0092603)
hudsonbot (developer)
2016-12-16 18:38

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

- Issue History
Date Modified Username Field Change
2016-10-21 06:35 pradeepvarma New Issue
2016-10-21 06:35 pradeepvarma Assigned To => Triage Finance
2016-10-21 06:35 pradeepvarma File Added: currency_of_organization_simple_gl_journal.mp4
2016-10-21 06:35 pradeepvarma Modules => Core
2016-10-21 06:35 pradeepvarma Triggers an Emergency Pack => No
2016-10-21 13:01 egoitz Resolution time => 1478214000
2016-10-21 13:22 aferraz Relationship added related to 0022296
2016-10-24 17:53 aferraz Assigned To Triage Finance => markmm82
2016-10-25 17:09 markmm82 Status new => scheduled
2016-11-03 20:07 aferraz Relationship added related to 0033798
2016-11-03 20:09 aferraz Resolution time 1478214000 =>
2016-11-03 20:09 aferraz Severity major => minor
2016-11-08 13:17 psanjuan Note Added: 0091235
2016-11-09 11:11 psanjuan Note Added: 0091262
2016-11-09 11:12 psanjuan Note Edited: 0091262 View Revisions
2016-11-09 11:24 psanjuan Note Edited: 0091262 View Revisions
2016-11-09 11:35 psanjuan Note Edited: 0091262 View Revisions
2016-11-09 11:39 psanjuan Note Edited: 0091262 View Revisions
2016-11-09 11:44 psanjuan Note Added: 0091264
2016-11-09 12:06 psanjuan Note Edited: 0091264 View Revisions
2016-11-09 12:07 psanjuan Note Edited: 0091264 View Revisions
2016-11-09 12:08 psanjuan Note Edited: 0091262 View Revisions
2016-11-09 12:08 psanjuan Note Edited: 0091262 View Revisions
2016-11-09 12:09 psanjuan Note Edited: 0091264 View Revisions
2016-11-09 12:11 psanjuan Note Added: 0091268
2016-11-09 12:18 psanjuan Note Edited: 0091268 View Revisions
2016-11-09 12:20 psanjuan Note Edited: 0091268 View Revisions
2016-11-09 12:21 psanjuan Note Added: 0091269
2016-11-09 12:21 psanjuan Note Edited: 0091268 View Revisions
2016-11-09 12:21 psanjuan Note Edited: 0091269 View Revisions
2016-11-09 12:22 psanjuan Note Added: 0091270
2016-11-09 12:43 hgbot Checkin
2016-11-09 12:43 hgbot Note Added: 0091276
2016-11-09 12:43 hgbot Status scheduled => resolved
2016-11-09 12:43 hgbot Resolution open => fixed
2016-11-09 12:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c5a35b41929c37703e651e7775bb0e85881f0725 [^]
2016-11-09 12:44 hgbot Checkin
2016-11-09 12:44 hgbot Note Added: 0091277
2016-11-09 12:45 aferraz Review Assigned To => aferraz
2016-11-09 12:45 aferraz Note Added: 0091279
2016-11-09 12:45 aferraz Status resolved => closed
2016-11-09 12:45 aferraz Fixed in Version => 3.0PR17Q1
2016-12-16 18:38 hudsonbot Checkin
2016-12-16 18:38 hudsonbot Note Added: 0092602
2016-12-16 18:38 hudsonbot Checkin
2016-12-16 18:38 hudsonbot Note Added: 0092603
2017-06-07 09:00 ngarcia Relationship added related to 0032441

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker