Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0021149 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 09. Financial management | major | always | 2012-07-19 11:00 | 2012-08-30 11:05 | |||
Reporter | VictorVillar | View Status | public | |||||
Assigned To | jecharri | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | bb0e53075e6c | ||||
Projection | none | ETA | none | Target Version | 3.0MP15 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 3.0MP12.1 | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0021149: With the G/L Category ES Standard you could not process a tax payment | |||||||
Description | With the G/L Category ES Standard you could not process a tax payment. You should change the name to Standard in order to complete the c_tax_paymentpost process. In this process line 134: select count(*) into v_gl_category_count from gl_category where name='Standard' AND ad_isorgincluded(v_org_id, gl_category.ad_org_id, v_client_id)<>-1 AND gl_category.ad_client_id = v_client_id; if (v_gl_category_count>0) then select max(gl_category_id) into v_gl_category_id from gl_category where name='Standard' AND ad_isorgincluded(v_org_id, gl_category.ad_org_id, v_client_id)<>-1 AND gl_category.ad_client_id = v_client_id; else RAISE EXCEPTION '%', '@OrgForStandardGLCategory@'; --OBTG:-20000-- end if; We can see that if the g/l category name is different as Standard and error message appear: "There is no 'Standard' G/L category defined for this organization." | |||||||
Steps To Reproduce | As group admin role, Go to Purchase Invoice, Create a new register date: today Complete it Go to Tax register type Create a new register Org: España g/l item: Capital social sales transacition: No Go to Lines tab Adquisiciones IVA 16% - IVA Normal Document type: AP invoice create the second register org: España g/l item: capital Social Sales trx: yes go to lines tab: Arrendamiento 16% (cobros) - IVA Normal Document Type: AP invoice Go to tax payment window org: España name: pago Business partner: Restaurantes starting date and ending date have to include the invoice date Click in Create VAT registers button Process it We can see the following error: "There is no 'Standard' G/L category defined for this organization." If you change the name of the g/l category ES Standard for the Organization España to Standard it works fine. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0051506) hgbot (developer) 2012-08-23 14:31 |
Repository: erp/devel/pi Changeset: bb0e53075e6c70f8b977e5c7fc1f80e588ccab5b Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Thu Aug 23 14:31:02 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/bb0e53075e6c70f8b977e5c7fc1f80e588ccab5b [^] Fixes issue 21149: With the G/L Category ES Standard you could not process a tax payment --- M src-db/database/model/functions/C_TAXPAYMENT_POST.xml --- |
(0051507) hgbot (developer) 2012-08-23 14:42 |
Repository: erp/devel/pi Changeset: 39098d52307fd23800d104a3fe8910d2c4ed7a5a Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Thu Aug 23 14:41:24 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/39098d52307fd23800d104a3fe8910d2c4ed7a5a [^] issue issue 21149: With the G/L Category ES Standard you could not process a tax payment. I have changed the message to adapt to new sql --- M src-db/database/model/functions/C_TAXPAYMENT_POST.xml M src-db/database/sourcedata/AD_MESSAGE.xml --- |
(0051667) VictorVillar (developer) 2012-08-30 11:05 |
verified |
Issue History | |||
Date Modified | Username | Field | Change |
2012-07-19 11:00 | VictorVillar | New Issue | |
2012-07-19 11:00 | VictorVillar | Assigned To | => mirurita |
2012-07-19 11:00 | VictorVillar | Modules | => Core |
2012-07-19 11:00 | VictorVillar | Resolution time | => 1348351200 |
2012-07-19 11:00 | VictorVillar | Issue Monitored: networkb | |
2012-07-19 11:06 | mirurita | Assigned To | mirurita => jonalegriaesarte |
2012-07-25 12:49 | jonalegriaesarte | Assigned To | jonalegriaesarte => ioritzCia |
2012-08-10 10:15 | ioritzCia | Assigned To | ioritzCia => jonalegriaesarte |
2012-08-10 11:06 | jonalegriaesarte | Assigned To | jonalegriaesarte => jecharri |
2012-08-23 14:31 | hgbot | Checkin | |
2012-08-23 14:31 | hgbot | Note Added: 0051506 | |
2012-08-23 14:31 | hgbot | Status | new => resolved |
2012-08-23 14:31 | hgbot | Resolution | open => fixed |
2012-08-23 14:31 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/bb0e53075e6c70f8b977e5c7fc1f80e588ccab5b [^] |
2012-08-23 14:42 | hgbot | Checkin | |
2012-08-23 14:42 | hgbot | Note Added: 0051507 | |
2012-08-30 11:05 | VictorVillar | Note Added: 0051667 | |
2012-08-30 11:05 | VictorVillar | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |