Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006643Openbravo ERP08. Project and service managementpublic2008-12-18 13:252009-01-02 07:51
shuehner 
shuehner 
normalminorhave not tried
closedfixed 
5
pi 
 
Core
No
0006643: Create AP Expense Invoices process does not work correctly when run with newly created user (having non-numeric user_id)
This process fails when the ad_user_id value of the currently logged in user contains non-numeric characters. This is true for all newly created users in 2.50 but not the old users (openbravo...)
Create a new user and i.e. assign in the Openbravo admin role
Log in with the new user
go to: Project & Service Management || Transactions || Expense Sheet
Create a header and one line, process the header
Go to: Project & Service Management || Transactions || Create AP Expense Invoices || Create AP Expense Invoices
- enter filters containing the newly created expense sheet
The process should create one purchase order for the created expense sheet
Go to the purchase order
Enable the audit fields
See that created by is empty
No tags attached.
related to defect 00056742.50 closed shuehner Audit for missing to_number in XSQL for Postgresql from v8.3 and excessive to_number in ID fields 
Issue History
2008-12-18 13:25shuehnerNew Issue
2008-12-18 13:25shuehnerAssigned To => shuehner
2008-12-18 13:25shuehnersf_bug_id0 => 2445128
2008-12-18 13:25shuehnerRegression testing => No
2008-12-18 13:26svnbotCheckin
2008-12-18 13:26svnbotNote Added: 0011519
2008-12-18 13:26svnbotStatusnew => resolved
2008-12-18 13:26svnbotResolutionopen => fixed
2008-12-18 13:26svnbotsvn_revision => 11360
2008-12-19 16:33shuehnerRelationship addedrelated to 0005674
2009-01-02 07:51krishnaStatusresolved => closed

Notes
(0011519)
svnbot   
2008-12-18 13:26   
Repository: openbravo
Revision: 11360
Author: huehner
Date: 2008-12-18 13:26:31 +0100 (Thu, 18 Dec 2008)

Fixed 6643
Remove wrong to_number call from created_by field (containing a uuid)

---
U trunk/src/org/openbravo/erpCommon/ad_process/ExpenseAPInvoice_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11360&sc=1 [^]