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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0021149
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2012-07-19 11:002012-08-30 11:05
ReporterVictorVillarView Statuspublic 
Assigned Tojecharri 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionbb0e53075e6c
ProjectionnoneETAnoneTarget Version3.0MP15
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP12.1SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021149: 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.
    



TagsNo 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
Powered by Mantis Bugtracker