0006643: Create AP Expense Invoices process does not work correctly when run with newly created user (having non-numeric user_id)

Description

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...)

Steps To Reproduce

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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0005674

2.50

closed

shuehner

Audit for missing to_number in XSQL for Postgresql from v8.3 and excessive to_number in ID fields

Notes
(0011519) svnbot (reporter) 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 [^]

Issue History
Date Modified	Username	Field	Change
2008-12-18 13:25	shuehner	New Issue
2008-12-18 13:25	shuehner	Assigned To	=> shuehner
2008-12-18 13:25	shuehner	sf_bug_id	0 => 2445128
2008-12-18 13:25	shuehner	Regression testing	=> No
2008-12-18 13:26	svnbot	Checkin
2008-12-18 13:26	svnbot	Note Added: 0011519
2008-12-18 13:26	svnbot	Status	new => resolved
2008-12-18 13:26	svnbot	Resolution	open => fixed
2008-12-18 13:26	svnbot	svn_revision	=> 11360
2008-12-19 16:33	shuehner	Relationship added	related to 0005674
2009-01-02 07:51	krishna	Status	resolved => closed