Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009190Openbravo ERP09. Financial managementpublic2009-05-26 17:202009-06-06 00:00
RenateNieuwkoop 
eduardo_Argal 
normalmajoralways
closedfixed 
5
2.50MP1 
pi 
Core
No
0009190: Imported Client: Tax Payment errors
As 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.
As 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
Since the fix on issue 8208 worked for the Purchasing Plan, I assume you know the root cause of the problem.
No tags attached.
jpg 260509ErrorTaxPayment.jpg (191,835) 2009-05-26 17:20
https://issues.openbravo.com/file_download.php?file_id=1346&type=bug
jpg
Issue History
2009-05-26 17:20RenateNieuwkoopNew Issue
2009-05-26 17:20RenateNieuwkoopAssigned To => rafaroda
2009-05-26 17:20RenateNieuwkoopFile Added: 260509ErrorTaxPayment.jpg
2009-05-26 19:08eduardo_ArgalStatusnew => scheduled
2009-05-26 19:08eduardo_Argalfix_in_branch => pi
2009-05-26 19:08eduardo_ArgalAssigned Torafaroda => eduardo_Argal
2009-05-26 19:10hgbotCheckin
2009-05-26 19:10hgbotNote Added: 0016663
2009-05-26 19:10hgbotStatusscheduled => resolved
2009-05-26 19:10hgbotResolutionopen => fixed
2009-05-26 19:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d4a53cc517e1f916980ea8a20131aa13e20945cd [^]
2009-05-26 19:26eduardo_ArgalNote Added: 0016664
2009-05-27 17:39RenateNieuwkoopNote Added: 0016686
2009-06-05 13:11sureshbabuStatusresolved => closed
2009-06-05 13:11sureshbabuNote Added: 0017016
2009-06-05 13:11sureshbabuFixed in Version => pi
2009-06-06 00:00anonymoussf_bug_id0 => 2802039

Notes
(0016663)
hgbot   
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   
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   
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   
2009-06-05 13:11   
Tested working fine