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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009190
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-05-26 17:202009-06-06 00:00
ReporterRenateNieuwkoopView Statuspublic 
Assigned Toeduardo_Argal 
PrioritynormalResolutionfixedFixed in Versionpi
StatusclosedFix in branchpiFixed in SCM revisiond4a53cc517e1
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP1SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009190: Imported Client: Tax Payment errors

DescriptionAs stated on issue 8208, I have the same issue that happened for the Purchase Plan also for the Tax Payment execution.

My assumption is that the problems are caused by the import Client, since it appears to be working in Openbravo/openbravo.

I have been waiting for over a month already since it supposed to be fixed according to the comment on issue 8208, but now that we have MP1 I still have the same error. Please urgently look into this.
Steps To ReproduceAs communicated on 8208:

First of all I'm using an imported client.

Financial Management || Receivables & Payables || Setup || Tax Payment
create a register type for Sales Tax (checkbox Sales transaction selected)
for AR Invoice and for Purchase Tax (checkbox Sales transactions not
selected) for AP invoice

Then enter and complete a Sales Invoice and a Purchase Invoice

Financial Management || Receivables and Payables || Transactions || Tax
Payment
for starting date 1st of this month, end date last day of the month
select 'generate payment'
Click 'Create VAT Registers'

Then the error message appears: see the snapshot I added
Proposed SolutionSince the fix on issue 8208 worked for the Purchasing Plan, I assume you know the root cause of the problem.
TagsNo tags attached.
Attached Filesjpg file icon 260509ErrorTaxPayment.jpg [^] (191,835 bytes) 2009-05-26 17:20

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0016663)
hgbot (developer)
2009-05-26 19:10

Repository: erp/devel/pi
Changeset: d4a53cc517e1f916980ea8a20131aa13e20945cd
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue May 26 19:08:11 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d4a53cc517e1f916980ea8a20131aa13e20945cd [^]

Fixes bug 0009190: Imported Client: Tax Payment errors

---
M src-db/database/model/functions/C_TAXPAYMENT_POST.xml
---
(0016664)
eduardo_Argal (developer)
2009-05-26 19:26

The problem is related with UUID

C_TAX_PAYMENT_POST.xml (data base procedure)
line 74:
old ---> v_glitem_acct NUMBER;
new ---> v_glitem_acct VARCHAR2(32);

Solved
(0016686)
RenateNieuwkoop (reporter)
2009-05-27 17:39

Thanks Eduardo for your help! I have retested the fix and the
Tax Payment processes successfully now.

thanks
Renate
(0017016)
sureshbabu (reporter)
2009-06-05 13:11

Tested working fine

- Issue History
Date Modified Username Field Change
2009-05-26 17:20 RenateNieuwkoop New Issue
2009-05-26 17:20 RenateNieuwkoop Assigned To => rafaroda
2009-05-26 17:20 RenateNieuwkoop File Added: 260509ErrorTaxPayment.jpg
2009-05-26 19:08 eduardo_Argal Status new => scheduled
2009-05-26 19:08 eduardo_Argal fix_in_branch => pi
2009-05-26 19:08 eduardo_Argal Assigned To rafaroda => eduardo_Argal
2009-05-26 19:10 hgbot Checkin
2009-05-26 19:10 hgbot Note Added: 0016663
2009-05-26 19:10 hgbot Status scheduled => resolved
2009-05-26 19:10 hgbot Resolution open => fixed
2009-05-26 19:10 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d4a53cc517e1f916980ea8a20131aa13e20945cd [^]
2009-05-26 19:26 eduardo_Argal Note Added: 0016664
2009-05-27 17:39 RenateNieuwkoop Note Added: 0016686
2009-06-05 13:11 sureshbabu Status resolved => closed
2009-06-05 13:11 sureshbabu Note Added: 0017016
2009-06-05 13:11 sureshbabu Fixed in Version => pi
2009-06-06 00:00 anonymous sf_bug_id 0 => 2802039


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker