Module 1: Expense Report Overview and Basic Setup Module Overview
Module 1: Expense Report Overview and Basic Setup Module Overview
Module 1: Expense Report Overview and Basic Setup Module Overview
BASIC SETUP
Module Overview
Travel and Expense Management uses the Enterprise Portal and the Microsoft
Dynamics AX® client. Most administration and configuration is performed in the
Microsoft Dynamics AX client while most users will access Travel and Expense
Management functionality from the Enterprise Portal to enter expense reports and
cash advance requests. This chapter covers the overview and basic setup of Travel
and Expense Management in Microsoft Dynamics AX 2012.
Objectives
Travel and Expense Management has tight integration with other Microsoft
Dynamics AX modules of Accounts payable, General ledger and Project
accounting.
Cash Advances
You can use the Cash Advance Request page to request a cash advance from your
employer. You might request a cash advance for several reasons, such as to pay
for parking at a sales meeting or if you plan to have lunch with a customer. Value
Added Tax (VAT) on purchases that are made with a cash advance is not eligible
for recovery. Cash Advance Requests are entered in Enterprise Portal.
Travel Requisitions
Before you travel for business and incur expenses that you charge to your
organization, you may be required to create and submit a travel requisition. The
travel requisition contains information about the projected costs of your travel.
The expense costs that you enter in a travel requisition do not have to be exact.
You only have to enter an estimate of the expense costs that you may incur.
Travel Requisitions are entered in Enterprise Portal.
Expense reports are entered through the Enterprise Portal. They cannot be
entered through the rich client. The expense report is in a typical header and lines
format. The expense report header contains basic information about the report
such as the employee, the location and the date. The lines contain the detail of
the expense transactions.
Submit Expenses
After you have entered all of the information in your expense report that is
required by your organization and attached any required expense receipts, the
next step is to submit the expense report for approval. Expense reports are
submitted through the Enterprise Portal.
Workflow Approvals
The Dynamics AX workflow module routes the expense reports for approval.
Approval actions can be completed in the enterprise portal or in the rich client.
Specific workflow for Expense reports are addressed later in this course.
The approved expense report is posted through a ledger journal. This is posted by
an administration person in the rich client.
There may be times when you incur a credit card expense, and the transaction
that appears on the credit card statement is incorrect. If this scenario occurs, first
contact the merchant where the expense was incurred. However, if you cannot
resolve the issue by contacting the merchant, you can create a credit card expense
dispute. This dispute is then sent to the credit card institution.
You can assign another worker as a delegate to submit a credit card expense
dispute on your behalf. Adding delegates are discussed later in this course. Credit
card disputes are entered in Enterprise Portal.
Travel Locations
Use the Travel Locations form to enter standard locations of travel. This field can
be entered on the expense report header and is optional. This field is used to
specify where the travel occurred. It can also be used as a condition in the
workflow configuration and/or expense policy rules.
1. Click Travel and expense > Setup > Optional setup > Travel
locations.
2. Click New to create a new location.
3. Type an identifier in the Location field.
1. Click Travel and expense > Setup > Disputes > Dispute reason
codes.
2. Click New to create a new location.
3. Select the Credit card type and Dispute type for the code.
4. Enter a name for the dispute code and a reason for the dispute that
explains the dispute type that you selected in step 3.
Expense Purpose
Use the Expense purpose form to create a standard list of expense purposes, such
as trade show, conference, or training. The expense purpose is optional and can be
entered on the expense header. Users can enter any description on the expense
header; they are not limited to these options. Entering common purposes in this
form will make data entry easier for user. This information can be used for reporting
and analysis
1. Click Travel and expense > Setup > Optional setup > Expense
purposes.
2. Click New to create a new purpose.
Payment Methods
Use the Payment Methods form to set up different forms of payment for travel
and entertainment expenses. Users must indicate the method of payment which
they used for each expense line on the report.
To open the Payment methods form click Travel and expense > Setup > Travel
and expense entry > Payment methods. The Payment method form uses the
following fields to define each payment method used in Travel and Expense
Management.
Field Example
Payment Method and Description Credit Card
Expense Owner Employee
Offset Account Type and Offset Bank Account, 1103
Account
Note: For more information on Payment method setup and accounts, refer to
the Payment Methods chapter of this course.
Expense Categories
Use the Expense categories form to setup the type of expense transactions that
the company would like to track. There are various standard expense types which
affect what type of information can be recorded about the expense.
1. Click Travel and expense > Setup > Travel and expense entry >
Expense categories.
2. Click New to create a new expense category and then type in the
Category ID.
3. Select the Use in Project check box if the expense category will be
used to track expenses in the Project module. If you select this check
box, the Project, Cost accounts, and Revenue accounts Fasttabs
become available in this form.
Click on one of the following Fasttabs to enter appropriate information for the
expense category:
Note: For a complete list of fields associated with the Fasttabs use the Help
files in Microsoft Dynamics AX 2012.
FastTab Description
Project View project category information. This
FastTab is available only if you select the
Use in Project check box. The
following fields are available if the
expense category is linked to a project:
Depending on how your organization uses expense categories, there are many
options to further define expense categories. Use the buttons on the top of the
Expense Category form to further define how the categories are used. The
following table describes the available buttons.
Button Description
Transactions View the transactions that are related to
the selected category.
Shared Categories
Shared expense categories that can be used across all of the legal entities in your
organization. For example, if you create a shared expense category for Meal
expenses, the Meals category name and description will be used by all of your
legal entities.
1. Click Travel and expense > Setup > Travel and expense entry >
Shared categories.
2. Click New to create a shared category.
3. Type an identifier in the Category ID field and a Category name.
4. Select the Can be used in Expense check box to allow this category
to be used in Travel and Expense Management.
Merchants
Merchants are specified for various expense categories. Common merchants can
be setup to make data entry easier for users. Users must select from this list during
expense entry if they want to indicate the merchant
Use the Merchant form to create a list of merchants that workers can select from
when entering line item expenses in an expense report.
1. Click Travel and expense > Setup > Optional setup > Merchants.
2. Click New and enter the name of the Merchant or organization.
3. Select the Expense type that this merchant might be associated with.
4. Select the Preferred check box if the merchant is preferred by your
organization. For example, a merchant might be preferred if it is a
hotel that offers a 5% discount to employees of your organization.
Contoso has decided to track Expenses for internet and phone use. To do this they
have decided to create a category called Internet and Phone and will be tracked
as a miscellaneous expense type with a default method of payment of Company
Credit Card. These expenses should be posted to the account 601500, Travel
expenses. This Expense is a shared category and can be used in Project and
Expense.
Detailed Steps
1. Create a shared expense category called Internet and Phone and
assign Miscellaneous as the expense type.
a. Click Travel and expense > Setup > Travel and expense entry
> shared categories.
b. Click New to create a new expense category and then type
“Internet and Phone” as the Category ID and Category name.
c. Select the Can be used in Project and Can be used in Expense
check boxes.
d. Select Miscellaneous as the Expense Type and click Close.
e. Click Expense categories on the left hand navigation pane.
f. Click New and then select Internet and Phone as the Category
ID.
General Setup
This lesson provides general setup needed to streamline processes and improve
productivity when using travel and expense procedures. This includes the
following:
• Setting up delegates
• Specify display field
• Create statistic groups
• Define expense policies
• Define general parameters
Delegates
Use the Delegate setup form to define one or more users who can enter, update,
delete or view expense reports on another's behalf for a specified date range.
The Delegate is the user who can see or enter expense reports for the Employee.
1. Click Travel and expense > Setup > Travel and expense entry >
Delegates.
2. Click New and then select a Worker.
3. Select a Delegate.
4. Enter the Start date for the period that the delegate will be active.
5. Enter the ending date for the period that the delegate will be active.
Note: It is also possible for the employee to set up Delegates for themselves in
Employee Self-Service Portal (EES). If a user accesses this from the portal, they can
only enter delegates who can enter report on behalf of themselves.
Note: Delegates can also enter travel requisitions and manage credit card
disputes.
Display Fields
Use the Display fields form to specify which fields should be visible on the
enterprise portal. This allows you to customize the fields shown on the enterprise
portal without needing to access the development environment. These changes
will affect all workers entering expense reports. This is a global setting and any
changes to this table will be applied to all companies running the application.
All available fields on the expense report header are listed on the Header fields
tab. All fields in the expandable section on the expense report lines are listed on
the Transaction fields.
1. Click Travel and expense > Setup > Travel and expense entry >
Display fields.
2. Select the Labels you would like to edit and then select the
appropriate Visibility option for that Label.
3. Use the Copy settings button to apply the selections that you make
in this form to other legal entities.
Statistic Groups
Use the Statistics Groups form to setup expense reporting groups. The expense
categories can be placed into a statistics group on the Expense categories form.
These groups are used in the Statistics on cost groups report (Travel and
expense > Reports > Statistics > Statistics on cost groups).
To define statistic groups click Travel and expense > Setup > Statistics >
Statistic groups, then click New, and enter a Statistics group name and
Description.
Policies
Organizations have different ways to exercise control over any travel and expense
costs. Travel and Expense policy is usually formulated on an enterprise basis, with
some provision for adaption at the legal entity level, operational unit level, or
even a more granular level to accommodate various conditions. The policy
violations framework allows you to setup rules that workers must follow when
entering, submitting, or approving expense reports. Implementing expense
policies can help manage expenses effectively.
Procedure: Policies
1. Open Travel and Expense > Setup > Policies > Expense.
2. Click Policy in the New group of the Action pane.
3. Enter a Name for the policy, and optionally enter a detailed
Description.
4. In the Policy organization tab, choose the Select Organization
hierarchy.
5. Select the desired organization entity from the Available
organizations node, and then click Add >>; the entity will move to
the Selected organizations node.
6. Click Create policy rule in the Policy rules tab.
The Travel and expense parameters form is used this to set up default
information, rates, and calculations for Travel and expense. To open this form click
Travel and expense >Setup > Travel and expense parameters.
Link Description
General Set parameters for mileage rates, personal
expenses, travel requisitions, distributions,
expense policies, and project drillback. You
can also configure display options.
Financial Set parameters for ledgers, ledger journals,
and taxes. You can also select default
parameters for encumbrances, and for
travel requisitions and expense reports that
are over budget.
Corporate Card Set the default account for credit card
disputes. You can also add links to your
organization's process for handling credit
card disputes and links to related
information
Per diem Set parameters for per diem expenses
Fax Cover pages If receipts that are related to expense
reports are sent by fax, enter the
instructions and default information that
are included on the cover pages of the
faxes.
General Parameters
To open the General parameter link click Travel and expense >Setup > Travel
and expense parameters > General link. Use the following fields to define
general parameters throughout the Travel and Expense module.
Field Description
Standard rate of mileage Enter the company standard rate paid
for mileage. This is expressed in the
company currency and will be applied
to the number of miles entered on the
expense report for Mileage type
expense categories.
Financial Parameters
To open the Financial parameter link click Travel and expense >Setup > Travel
and expense parameters > Financial link. Use the following fields to define
financial parameters throughout the Travel and Expense module.
Field Description
Ledger daily journal Enter the journal name that should be
name used when creating the journal to post
the expense report.
Enable tax recovery from Select this check box to recover taxes
expenses for eligible expenses.
Post cash advances immediately Select this check box to immediately
post an expense report to the general
ledger. If this check box cleared, a
journal is created but not posted.
Tax included Select this check box to indicate that
sales tax is included in the worker's
expense amount by default.
Release encumbrances on closing Select this check box to release
travel requisitions encumbered funds when an approved
travel requisition is closed.
Allow travel requisition submit Select this check box to allow workers
on budget over run for general to submit travel requisitions that
ledger budget and project exceed either the allowed budget that
budget is set in the general ledger or the
allowed budget for a project.
Allow expense report submit on Select this check box to allow workers
budget over run for general to submit expense reports that exceed
ledger budget and project either the allowed budget that is set in
budget the general ledger or the allowed
budget for a project.
Allow expense report approval on Select this check box to allow
budget over run for general managers to approve expense reports
ledger budget only that exceed only the allowed budget
that is set in the general ledger.
To open the Corporate card parameter link click Travel and expense >Setup >
Travel and expense parameters > Corporate card link. Use the following fields
to define Corporate card parameters throughout the Travel and Expense module.
Field Description
Dispute default account Select the default account for disputes
about credit card transactions.
Link to dispute process Enter the link to information about your
organization's process for handling disputes
about credit card transactions.
Link to dispute-related Enter the link to frequently asked questions
FAQs (FAQs) or related information about disputes
about credit card transactions.
To open the Per Diem parameter link click Travel and expense >Setup > Travel
and expense parameters > Per Diem link. Use the following fields to define Per
Diem parameters throughout the Travel and Expense module.
Field Description
Minimum hours for per diem Enter the minimum number of hours
that a worker must work in a day to be
eligible to receive a per diem.
Meal percent Enter the default percentage of the per
diem for meals that is used on the first
and last days. The work day on the first
and last days may be shorter than a
standard work day. Therefore, the
amount of the per diem on these days
may differ from the standard amount.
Hotel percent Enter the default percentage of the per
diem for hotel expenses that is used on
the first and last days. The work day on
the first and last days may be shorter
than a standard work day. Therefore, the
amount of the per diem on these days
may differ from the standard amount.
To open the Fax cover pages parameter link click Travel and expense > Setup >
Travel and expense parameters > Fax cover pages link. Use the following
fields to define Fax cover pages parameters throughout the Travel and Expense
module.
Field Description
Instructions Enter the instructions that workers must
follow when they create a cover page for
a fax that is used to send receipts that are
related to an expense report. Click
Translations to select the language that is
used for the instructions.
Expense report overview Select this check box to include an
overview of the expense report on the
cover page of the fax.
Julia Funderburk, worker code 000131, will be entering expense reports on behalf
of Charlie Carson, worker code 1000. Setup Julia as a delegate for Charlie Carson.
Detailed Steps
1. Use the Delegate form to assign Julia Funderburk as a delegate.
a. Click Travel and expense > Setup > Travel and expense entry
> Delegates.
b. Click New to create a new delegate.
c. Select Charlie Carson as the Worker and click Select.
d. Select Julia Funderburk as the Delegate and click Select.
e. Click Close.
Module Review
This lesson provides an overview of the Travel and Expense functionality and
describes how setting up parameters can enhance the functionality as well speed
up data entry in Enterprise Portal.
Sequencing Activity
Steps
Plan how the policies should be organized.
Create travel and expense policies.
Begin the travel expense reporting process.
Setup travel and expense policy parameters.
( ) True
( ) False
( ) True
( ) False
MODEL ANSWER:
Travel and Expense Management has tight integration with other Microsoft
Dynamics AX modules of Accounts payable, General ledger and Project
accounting.
Sequencing Activity
Steps
1 Plan how the policies should be organized.
3 Create travel and expense policies.
4 Begin the travel expense reporting process.
2 Setup travel and expense policy parameters.
(√) True
( ) False
(√) True
( ) False