0035073: Fetching data when it is sorting by a null foreign key is not working as expected.

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #35073		[ All Revisions ] [ Back to Issue ]
Summary	0035073: Fetching data when it is sorting by a null foreign key is not working as expected.

Revision	2017-05-04 17:46 by inigosanchez
Steps To Reproduce	- Login as "System Administrator - System" role. - Go to [Module] window and put "Core" module in development mode. - Go to [Tables and Columns] window and select "BusinessPartner" table. - Go to [Column] subtab and open in form view "BP_Currency_ID" record. - Check "Used as Record Identifiew" checkbox. Save it. -Restart tomcat because model has changed. - Login as "F&B International Group Admin" role. - Go to [Business Partner] window and create a new one for testing purposes. [Currency field should be null] - Go to [Location/Address] subtab and create a new test location for the new business partner. - Go to [Sales Order] window and create a new sales order with the BP created in previously steps. - Filter by "Document No." field using the document number generated for the new sales order. [Only the new sales order should be displayed in the grid] - Sort by "Order Date" column and refresh the current data from the toolbar button. Check the record appears. - Sort by "Business Partner" column and refresh the current data from the toolbar button. Check the record disappears.

Revision	2017-05-04 13:42 by inigosanchez
Steps To Reproduce	1. Install the Spanish Professional Localization Pack [1]. 2. Go to modules folder, delete and clone this module [2]. Ensures that version 4.1.600 of the module is applied. 3. Login in the ERP as F&B International Admin role. 4. Go to [Enterprise Module Management] window and select "F&B España, S.A" organization. 4.1 Apply taxes dataset: Taxes: configuration for Spain (Impuestos de España) 1.2.202. 5. Refresh [Enterprise Module Management] window and select "F&B España, S.A" organization. 5.1 Apply 347 dataset: Spain AEAT Modelo 347 for APR - 4.1.600 - English (USA) 6. Go to [Tax Rate] and select a record with data in the [Tax parameter] subtab. For example "Adquisición B.Inmuebles 16%" record. 7. Sort by Tax column in [Tax parameter] subtab and refresh the current data from the toolbar button. Check the records appear. 8. Sort by Tax Report Parameter column and refresh the current data from the toolbar button. Check the records disappear. [1].- http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Professional-Localization-Pack-Spain-Espana-Cash-VAT [^] [2].- http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/ForgeModuleDetail/Spain-AEAT-Modelo-347-For-APR [^]

Revision	2017-05-04 13:41 by inigosanchez
Steps To Reproduce	1. Install the Spanish Professional Localization Pack [1]. 2. Go to modules folder, delete and clone this module [2]. Ensures that version 4.1.600 of the module is applied. 3. Login in the ERP as F&B International Admin role. 4. Go to [Enterprise Module Management] window, select "F&B España, S.A" organization and apply taxes dataset: Taxes: configuration for Spain (Impuestos de España) 1.2.202. 5. Refresh [Enterprise Module Management] window, select "F&B España, S.A" organization and apply 347 dataset: Spain AEAT Modelo 347 for APR - 4.1.600 - English (USA) 6. Go to [Tax Rate] and select a record with data in the [Tax parameter] subtab. For example "Adquisición B.Inmuebles 16%" record. 7. Sort by Tax column in [Tax parameter] subtab and refresh the current data from the toolbar button. Check the records appear. 8. Sort by Tax Report Parameter column and refresh the current data from the toolbar button. Check the records disappear. [1].- http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Professional-Localization-Pack-Spain-Espana-Cash-VAT [^] [2].- http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/ForgeModuleDetail/Spain-AEAT-Modelo-347-For-APR [^]

Revision	2017-04-07 10:34 by ngarcia
Steps To Reproduce	Install the Spanish Professional Localization Pack. http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Professional-Localization-Pack-Spain-Espana-Cash-VAT [^] Go to modules folder, delete and clone this module: http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Taxes-Configuration-For-Spain-Impuestos-Para-Espana [^] Go to modules folder, delete and clone this module: http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Tax-Report-Modelo-303-Spain [^] As Sytem Admin create a new client with below setup: Client = Test Issue 35073 Currency = EUR Include Accounting = NO Enter any password. Press OK. Log out and Log in. In Profile window select the new client and configure it as default. Run Initial Organization setup with below setup: Organization = Test Issue 35073 organization type = Legal with accounting. Currency = EUR Include Accounting = Yes Select "Plan general Contable 2017 (PYMES) Enter any password. Press OK. Create a Calendar for the organization, in the Fiscal Calendar window. Create the periods as well, for 2016 and 2017 (including Adjustment Period). Go to Organization window and select the organization just created. Select allow period control, enter the calendar and set it as ready. Go to Enterprise Module Management, select the organization and apply below datasets always for the organization and one by one and in the described order: First = Taxes: configuration for Spain (Impuestos de España) 1.2.202. Press ok. Second = Cash VAT Spain Taxes 1.0.101) Press ok. Third = Tax Report : Modelo 303 (Spain) 1.4.500 Press Ok. Forth = Tax Report : Modelo 303 (Spain) Cash VAT compatible 1.2.300 Press OK. Go to tax rate and filter by tax rate "Prestación servicios Bienes Inversión 21% -15%R (+21%)" Verify that some values are shown in Tax Parameter tab (if the grid is sorted by Tax column) Sort by Tax Report Parameter column and refresh the current data from the toolbar button. Check the records disappear Sort by Tax column again and and refresh the current data from the toolbar button. Check the records appear again

Revision	2017-01-27 15:43 by psanjuan
Steps To Reproduce	Install the Spanish Professional Localization Pack. http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Professional-Localization-Pack-Spain-Espana-Cash-VAT [^] Go to modules folder, delete and clone this module: http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Taxes-Configuration-For-Spain-Impuestos-Para-Espana [^] Go to modules folder, delete and clone this module: http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Tax-Report-Modelo-303-Spain [^] As Sytem Admin create a new client with below setup: Client = Test Issue 35073 Currency = EUR Include Accounting = NO Enter any password. Press OK. Log out and Log in. In Profile window select the new client and configure it as default. Run Initial Organization setup with below setup: Organization = Test Issue 35073 organization type = Legal with accounting. Currency = EUR Include Accounting = Yes Select "Plan general Contable 2017 (PYMES) Enter any password. Press OK. Create a Calendar for the organization, in the Fiscal Calendar window. Create the periods as well, for 2016 and 2017 (including Adjustment Period). Go to Organization window and select the organization just created. Select allow period control, enter the calendar and set it as ready. Go to Enterprise Module Management, select the organization and apply below datasets always for the organization and one by one and in the described order: First = Taxes: configuration for Spain (Impuestos de España) 1.2.202. Press ok. Second = Cash VAT Spain Taxes 1.0.101) Press ok. Third = Tax Report : Modelo 303 (Spain) 1.4.500 Press Ok. Forth = Tax Report : Modelo 303 (Spain) Cash VAT compatible 1.2.300 Press OK. Go to tax rate and filter by tax rate " Prestación servicios Bienes Inversión 21% -15%R (+21%)" Verify that some values are shown in Tax Parameter tab. Remove the filter and filter now by this tax "Prestación servicios nacional 21% -24%R (21%)". No record is shown. Edit this one and type it as Prestación servicios nacional 21% -24%R (+21%) Verify that some values are shown in Tax Parameter tab. Filter now by this tax rate: Adquisición Bienes Inversión 21% -1%R (+21%) Verify that some values are shown in Tax Parameter tab. There are sometimes that the tax parameter and NOT shown.

Revision	2017-01-27 15:27 by psanjuan
Steps To Reproduce	Install the Spanish Professional Localization Pack. http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Professional-Localization-Pack-Spain-Espana-Cash-VAT [^] Go to modules folder, delete and clone this module: http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Taxes-Configuration-For-Spain-Impuestos-Para-Espana [^] Go to modules folder, delete and clone this module: http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Tax-Report-Modelo-303-Spain [^]

Revision	2017-01-27 15:25 by psanjuan
Steps To Reproduce	Install the Spanish Professional Localization Pack. http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Professional-Localization-Pack-Spain-Espana-Cash-VAT [^] delete and clone this module: http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Taxes-Configuration-For-Spain-Impuestos-Para-Espana [^] delte and clone this module: http://centralrepository.openbravo.com/openbravo/org.openbravo.forge.ui/sso/ForgeModuleDetail/Tax-Report-Modelo-303-Spain [^]