| View file | ||
|---|---|---|
| ||
| View file | name | Cost Allocation.pdf
On this page:
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Overview
Cost Allocation is an alternate form of custom reporting field.
| Table of Contents | ||||
|---|---|---|---|---|
|
Benefits and Limitations
...
Task
...
Process / Helpful Hint
...
Benefit
Benefits
Max file size:
...
50MB.
Ability to upload files and set up an automated
...
feed.
Available on the desktop and mobile.
Cost Allocation allows for
...
Nesting and Tiered.
Nesting allows the user to choose a parent value and in turn, presents the option for the child value, nested under the parent value.
...
Tiered allows for multiple levels ex: project, task, subtask
Trip reporting data can be captured through PNR scripting.
Limitations
...
Standard Cost Allocation displayed on the purchase page, where Tiered Cost Allocation will display on the trip search page and again on the purchase page with the same value as the trip search page, but they can edit it if needed.
Unable to apply to
...
profile.
Comparison
...
Chart Custom Fields vs. Cost Allocation
...
Let’s Get Started
Enabling Cost Allocation - Who to Contact
Task
Process / Helpful Hint
Options | Custom Field | Cost Allocation |
|---|---|---|
Upload options | ||
Automated Feed option | ||
Desktop and Mobile | ||
Nesting Value | ||
Values written to PNR | ||
Values written to Profile | ||
Max size | 4,000 bytes | 50 MB file max |
Deem booking flow Placement | Trip Planner and Purchase page | Nesting - Purchase page Tiered - Trip Search and Purchase Page |
Contacts to Enable Cost Allocation
Channel Sales Director
If Automated feed is required
...
, submit a Statement of Work (SOW).
Deem Support Case
Open a Deem Support Case, to fully enable Cost Allocation per site
...
. Deem has a process they need to complete for the field to be fully active.
Note: You can start configuring the site and cost allocation file while Deem completes their process.
Gathering Information
...
Task
...
Reporting Values
Parent Value - Master field name.
Child Value - Secondary field name (Data is captured for reporting).
Note: Special Characters are not allowed other than slash, dot, or dash.
File type
Manual upload.
Automated.
Note:
...
If Automated feed is needed (Cost Item). Please open a Deem Support Case and contact your Channel Sales Director (provide case number)
...
.
Creating Cost Allocation Field
...
Task
...
Process / Helpful Hint
...
Open a Deem
...
Create Field
...
support case.
Select Site ID from the
...
dashboard home page.
Hover over Services and
...
select Expenses.
...
...
Creating Parent
...
Select Cost Allocation.
...
Select Edit to the far right within the Cost Segments.
...
Update Cost Segment (
...
parent).
Enter Name.
Entering Project Code for this example
Enter Description.
In this example, we are using Project Code Associated with Trip
...
If this is the parent field
...
, Subsegment
...
Of will be left at None (Independent segment).
...
Select Active
...
.
Enable Cost Allocation
...
.
Cost Segment Required?
...
Move to the bottom of the screen and click on Save
...
: Select Yes or No.
Select Save.
Select Add a New Segment
...
under Cost Segments box to create child cost segment.
...
Update Cost Segment (
...
child).
Enter Name
...
Entering Project Name for this example
...
Description
You can leave blank
Subsegment of - Click on Project Code
...
.
Enter Description.
Subsegment Of:select Project Code (this is the parent segment associated to this field).
...
Select Active.
Enable Cost Allocation
...
(inherited from parent segment
...
Move to the bottom of the screen and click on Save
...
).
Cost Segment Required?: Select Yes or No.
Select Save. Both parent and child cost segments
...
display in the Cost Allocation screen.
To confirm both the parent and child cost segments are active,
...
select each cost segment name under
...
Cost Segment
...
and look for a green check
...
Child showing Active
...
Fields have been created. Next, create the upload file.
under Active.
Parent showing Active
Important Upload File Criteria
...
Task
...
Process / Helpful Hint
...
Upload Template
Click on Upload Allocations button
...
To upload template:
Select Upload Allocations.
Select Instructions and Template.
...
Field Definitions and important information
Complete the allocations template. DO NOT remove any columns or headers from the file when uploading.
...
While they may not be required or may not be applicable for travel, they are critical for the upload to function properly.
Segment Name
...
: (Required
...
) Max character length 30
Allocation Name
...
: (Required
...
) Max character length 45
Allocation Description
...
Not Required
: (Do not Use) Not applicable for Travel.
Allocation Code: Max character length
...
45
Allocation Code
Required if you want to capture a numeric value or string
Parent Allocation Name: Max character length 45
...
Required
...
for Nesting one
...
allocation to another or Tiered.
Expense Approver ID
...
: (Do not Use) Not applicable for Travel.
Expense Approval Threshold Amount
...
: (Do not Use) Not applicable for
...
Travel.
Travel Approval External ID
...
: (Not Required)
...
Nesting Fields
In the case of a
...
Nested or Tiered segment, the Parent Allocation name must exist
...
and be configured, in order for it to upload successfully
...
File type
...
.CSV (Comma Delimited)
...
Character limits
...
.
Save file name as --- costallocation_siteid_yyyymmdd.csv
Special Characters: While it is not recommended to use special characters, they are supported in Segment Name, Allocation Name, and Allocation Code.
~ ` ! @ # $ % ^
...
* ( ) _ - + = { : ; } [ < , . > ] ? / " ' | \
Common issues that cause a failure:
Ensure ALL columns and headers are included in the file - use the template
...
and ensure the headers are added
...
correctly.
Input Segment Name is not present in the system.
Parent Segment not found in system for the input Parent Allocation name.
Input Parent Allocation name is not present in the system.
Linking active child allocation to inactive parent allocation.
Parent allocation's segment is not the parent of the segment that owns the child allocation.
Duplicate Allocation Names are NOT allowed.
Cost Allocation Upload
...
Task
...
Parent
...
field
...
To set up the Parent field within upload file
...
:
Enter Parent field name
...
in Segment Name column. Max character length is 30. In this example, Project Code is the parent field name.
...
Max character length 30
Enter Allocation Name
...
, the data field collection for Parent (
...
searchable on purchase page)
...
. Max character length is 45.
Leave Allocation Description
...
blank
...
Max character length 180
.
Enter the Allocation Code
...
, the number associated to this parent. Max character length is 45.
Note: This number cannot be reused for any new Parent fields and do not change once associated with the Parent field.
In this example, we started off with 12345 and then continued the numbering from there.
...
Max character length 45
...
Child
...
field
...
To set up the Child field within upload file (bottom
...
section):
...
Enter Child field name
...
in Segment Name. Max character length 30. In this example, Project Name is the child field name.
...
Max character length 30
Enter Allocation Name
...
, the data field collection for
...
Child (
...
searchable on purchase page)
...
. Max character length is 45.
Leave Allocation Description
...
blank.
Allocation Code: Enter child data field collection for child again
...
. Max character length is 45.
Parent Allocation Name: Enter parent data collection associated with the Child data field.
...
Max character length is 45.
...
Note: One to one parent child relationship only. Each entry for
...
parents must be associated with a child entry, and vice versa.
Save
...
file name as --- costallocation_siteid
...
_yyyymmdd.csv
This example: acme-agency_costallocation_20220817.csv
...
Upload File
Click Upload Allocations
...
Upload file
Select Upload Allocations.
Under Upload Template
...
select Choose File.
Find file and then
...
select Upload.
...
...
Confirmation screen will appear
...
Click Close
...
A confirmation screen displays. Select Close.
Select Recent Upload History
...
to validate if the file was successful or if there were errors indicated.
...
...
See if upload was successful
...
with no errors.
...
List of both parent and child fields you have uploaded
...
display at the bottom of the Cost Allocation home page
...
.
...
Select the field name listed under the Cost Segment box to see each list.
...
Customer Experience
...
...
Process / Helpful Hint
...
Client Experience
The Cost Allocation reporting field
...
displays on the Trip Search and Purchase page if Tiered, otherwise it display only on the Purchase page.
A pick list
...
displays as you type in the field. The list displays from both the child and the parent field names,
...
allowing the client to easily find the response they are looking for.
Example below searching for the letter
...
“y.” Results display any parent and child with “y” in any part of their name.
...
PNR
...
Task
...
Process / Helpful Hint
Scripting
Special scripting is required for Cost Allocation.
...
See Cost Allocation and PNR Edits for more information.