Stored Procedure

A forum for User Initated & Scheduled Workflows
Posts: 1
Joined: Tue Dec 04, 2012 12:21 pm
Brief Company Description: Land Surveying
Deltek Vision Version: 6.1
Number of Employees: 100
Company Position: Admin
Number of Offices: 0
Year Vision Installed: 2009

Stored Procedure

Postby Phil.Jones » Tue Dec 04, 2012 12:34 pm

Hi, All.

I'm trying to do something I thought would be easy: In Vision 6.1(SP4) when an employee wins a project, I'd like to be able to choose his/her name from an employee look-up field (CustContractWonBy) on the project record. On save their yearly goal is then automatically populated (CustYearlySalesGoal) from a field listed on their Employee file (CustSalesGoal).

Attached is the workflow and SQL code, which I adopted from another stored procedure that performs a similar function. However, it doesn't work--I get "Error converting data type varchar to numeric. Error occurred in: Projsalesgoal[CRLF]Error occurred on line 25".

Admittedly, I am an SQL novice, so any help, or an easier way to do this, would be greatly appreciated.
The Code
(24 KiB) Downloaded 176 times
The Vision settings
(11.94 KiB) Downloaded 195 times

Emma Howard
Posts: 28
Joined: Fri May 25, 2012 6:19 am
Brief Company Description: WSP Group Africa - 900 users in Africa, subsidiary of WSP Group PLC - 9000 users worldwide, Deltek Vision user since 2009. Engineering company supplying all engineering services from Mechanical through to Green Energy
Deltek Vision Version: 6.1
Number of Employees: 900
Company Position: Deltek Project Manager
Vision Modules: Info Centres, Accounting, Time and Expense, CRM, Custom Proposals
Number of Offices: 0
Year Vision Installed: 2009

Re: Stored Procedure

Postby Emma Howard » Mon Jan 14, 2013 7:01 am

Hi Phil - you need to check what type of field is to be updated as well as the type of the field you are using to update the record. So for example:

In EmployeeCustFields - YearlySalesTotal might be a numeric field
In ProjectCustFields - YearSalesTotal might be a character field

If this is the case you will not be able to update the numeric field with the character field, or vice versa

Hope this makes sense

Posts: 195
Joined: Thu Nov 05, 2009 10:36 pm
Brief Company Description: Deltek Vision Consultant
Deltek Vision Version: 6.1
Number of Employees: 2
Company Position: Owner/Consultant
Vision Modules: ALL
Number of Offices: 0
Year Vision Installed: 2005
Vision User Group: Utah

Re: Stored Procedure

Postby meaglin » Sat Feb 02, 2013 11:44 am

Without a full understanding, you should be able to do this from a standard workflow. I kind of doubt that a SP would even be required.

Mel Eaglin
Visionary Reporting Solutions
San Diego, CA 92109
Phone: (858) 245-8956
"Skype Name: mel.eaglin"

Return to “User Initiated & Scheduled Workflows”

Who is online

Users browsing this forum: No registered users and 1 guest