Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0015140 | Openbravo ERP | 09. Financial management | public | 2010-11-09 11:42 | 2012-05-25 12:10 |
|
| Reporter | dalsasua | |
| Assigned To | vmromanos | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Ubuntu 9.04 |
| Product Version | pi | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0015140: C_TaxPayment_Post procedure retrieves incorrectly the GL Categories |
| Description | In C_TaxPayment_Post we can see:
select max(gl_category_id)
into v_gl_category_id
from gl_category where name='Standard';
where is not filtering by ad_client_id, so it could retrieve the gl_category_id belonging to a different client. Actually, after Initial Client Setup refactor project, this gl_category elements can be defined at an organization level. |
| Steps To Reproduce | |
| Proposed Solution | Change mentioned sql by another one that:
1.- Tries to retrieve the gl_category elements belonging to the suitable organization.
2.- If none, then belonging to the suitable client.
3.- If none, the one defined for client with ad_client_id='0' |
| Additional Information | |
| Tags | VMA-Reviewed |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2010-11-09 11:42 | dalsasua | New Issue | |
| 2010-11-09 11:42 | dalsasua | Assigned To | => dalsasua |
| 2011-07-20 18:17 | dalsasua | Assigned To | dalsasua => jonalegriaesarte |
| 2011-10-29 18:28 | psarobe | Status | new => scheduled |
| 2011-10-29 18:28 | psarobe | fix_in_branch | => pi |
| 2012-02-15 19:04 | iciordia | Assigned To | jonalegriaesarte => vmromanos |
| 2012-02-16 17:22 | vmromanos | Tag Attached: VMA-Reviewed | |
| 2012-05-04 11:40 | naiaramartinez | Note Added: 0048370 | |
| 2012-05-08 19:20 | hgbot | Checkin | |
| 2012-05-08 19:20 | hgbot | Note Added: 0048478 | |
| 2012-05-08 19:20 | hgbot | Status | scheduled => resolved |
| 2012-05-08 19:20 | hgbot | Resolution | open => fixed |
| 2012-05-08 19:20 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/35f4310c1d259e49734859ac07bc71c378ce8dae [^] |
| 2012-05-08 19:21 | mirurita | Note Added: 0048480 | |
| 2012-05-08 19:21 | mirurita | Status | resolved => closed |
| 2012-05-25 12:10 | hudsonbot | Checkin | |
| 2012-05-25 12:10 | hudsonbot | Note Added: 0049067 | |
|
Notes |
|
|
|
Test Plan:
Go to Tax Register Type window and create new record:
Organization: F&B US, Inc.
Sales transaction: no
The selected G/L item has to have an accounting schema.
Go to lines tab create new record:
tax: NY Sales Tax - US State Sales Tax
Document type: AP Invoice
Create another tax regster type:
Organization: F&B US, Inc.
Sales transaction: yes
The selected G/L item has to have an accounting schema.
Go to lines tab create new record:
tax: NY Sales Tax - US State Sales Tax
Document type: AR Invoice
Go to G/L Category window:
Select the record that has 'Standard' as name.
Chagne the Organziation and set 'F&B España - Región Norte'
Go to Tax Payment window and create a new record:
Organization: F&B US, Inc.
Press Process button and notice that an error message is shown.
Now, go back to G/L Category window:
Select the record that has 'Standard' as name.
Change the Organziation and set '*'
Go back to Tax Payment window. Select the newly created record. Press Process button. Notice that now the tax payment is processed. |
|
|
|
(0048478)
|
|
hgbot
|
|
2012-05-08 19:20
|
|
Repository: erp/devel/pi
Changeset: 35f4310c1d259e49734859ac07bc71c378ce8dae
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Tue May 08 14:02:33 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/35f4310c1d259e49734859ac07bc71c378ce8dae [^]
fixed bug 15140 in c_taxPayment_post add an organization and client validation
this is done to retrieve correctly the GL Categories
---
M src-db/database/model/functions/C_TAXPAYMENT_POST.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
|
|
|
|
(0048480)
|
|
mirurita
|
|
2012-05-08 19:21
|
|
|
|
|
|
|