Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021149Openbravo ERP09. Financial managementpublic2012-07-19 11:002012-08-30 11:05
ReporterVictorVillar 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP12.1 
Target Version3.0MP15Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021149: With the G/L Category ES Standard you could not process a tax payment
DescriptionWith 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 ReproduceAs 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.
    



Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-07-19 11:00VictorVillarNew Issue
2012-07-19 11:00VictorVillarAssigned To => mirurita
2012-07-19 11:00VictorVillarModules => Core
2012-07-19 11:00VictorVillarResolution time => 1348351200
2012-07-19 11:00VictorVillarIssue Monitored: networkb
2012-07-19 11:06miruritaAssigned Tomirurita => jonalegriaesarte
2012-07-25 12:49jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2012-08-10 10:15ioritzCiaAssigned ToioritzCia => jonalegriaesarte
2012-08-10 11:06jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-08-23 14:31hgbotCheckin
2012-08-23 14:31hgbotNote Added: 0051506
2012-08-23 14:31hgbotStatusnew => resolved
2012-08-23 14:31hgbotResolutionopen => fixed
2012-08-23 14:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/bb0e53075e6c70f8b977e5c7fc1f80e588ccab5b [^]
2012-08-23 14:42hgbotCheckin
2012-08-23 14:42hgbotNote Added: 0051507
2012-08-30 11:05VictorVillarNote Added: 0051667
2012-08-30 11:05VictorVillarStatusresolved => closed

Notes
(0051506)
hgbot   
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   
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   
2012-08-30 11:05   
verified