create_expense_log
Public Function create_expense_log(ByVal onsite_objid As Long, _
ByVal id_num As String, ByVal creation_time As String, _
ByVal notes As String, ByVal perf_by As String, _
ByVal user_name As String, ByVal expense_type As String, _
ByVal quantity As Double, ByVal the_rate As Double, _
ByVal billable As Long, ByVal bill_to As String, _
ByVal resolution As String) As Integer
Description
This API allows creation of an expense log that is related to an onsite log. The OBJID of the onsite log or a case/subcase id must be supplied (but not both), and the other parameters are all optional. If you do not specify a billing rate, the employee's labor_rate field will be used.
Parameters
| Parameter Name | Required? | Description |
|---|---|---|
| onsite_objid | Yes | The OBJID of the onsite log this expense log is related to |
| id_num | No | The Id number for the Case if no onsite log is specified |
| creation_time | No | The time this expense log is created. If left blank, it will be the current time |
| notes | No | The note text for this expense log |
| perf_by | No | The user that is performing the actions associated to the onsite log |
| user_name | No | The user who is creating the onsite log. If left blank, the current user performs the create |
| expense_type | No | Value for the type of expense, from the EXPENSE_TYPE list in Policies and Customers. If left blank, the default value is used |
| quantity | No | The number of units that are being applied to the onsite log |
| the_rate | No | Billing rate (per unit). If no rate specified, the employee's labor_rate is used |
| billable | No | Indicates if this expense is billable |
| bill_to | No | Indicates who this expense log will be billed to, from the BILL_TO_EXPENSE list in Policies and Customers |
| resolution | No | Value from the Resolution Code list |
Returns
| Value | Meaning |
|---|---|
| 0 | No errors |
| -1 | Could not find specified EXPENSE_TYPE |
| -2 | Could not find specified BILL_TO_EXPENSE |
| -3 | Cannot find user in database |
| -4 | Cannot find employee record for user in database |
| -5 | Cannot find performing user in database |
| -6 | Could not find specified RESOLUTION |
| -7 | Cannot find employee record for performing user in database |
| -8 | Cannot find the 'T & E log' activity string with rank = 1800 |
| -9 | Cannot find case or subcase related to this expense log |
| -10 | Cannot find specified onsite_log record |
| -11 | Either Case Id or an onsite log objid must be specified |
| ret_objid | The objid of the new expense log object is returned by this parameter. |
| ret_objid2 | The objid of the new onsite object is returned by this parameter. |
Examples
Create a new expense log related to onsite log 268435499. The creation time is 10:30 am on September 11, 1998. A sample note is passed, and the resolution will be "Completed". The user will default, and the performing user will be set to "db". This default expense type is billable to the "Customer". Once created, the new objid will be placed in the el_objid variable.
Visual Basic:
Dim ret_int As Integer
Dim el_objid As Long
ret_int = fcfo.create_expense_log(268435499, "", "09/11/98 10:30:00", _
"expense log note", "db", "", "", 1, _
4.5, 1, "Customer", "Completed")
If ret_int = 0 Then
el_objid = fcfo.ret_objid
End If
JavaScript:
var ret_int = fcfo.create_expense_log(268435499, "", "09/11/98 10:30:00",
"expense log note", "db", "", "", 1,
4.5, 1, "Customer", "Completed");
if (ret_int == 0){ var el_objid = fcfo.ret_objid; }
Create a new expense log related to onsite log 268435463. The quantity is 1.5 units (at 3.33 each), non-billable. All other parameters will default.
Visual Basic:
Dim ret_int As Integer
Dim el_objid As Long
ret_int = fcfo.create_expense_log(268435463, "", "", "", "", "", _
"", 1.5, 3.33, 0, "", "")
If ret_int = 0 Then
el_objid = fcfo.ret_objid
End If
JavaScript:
var ret_int = fcfo.create_expense_log(268435463, "", "", "", "", "",
"", 1.5, 3.33, 0, "", "");
if (ret_int == 0){ var el_objid = fcfo.ret_objid; }