Symbol SPT 1700, Product Reference Manual

Page: 299 / 317

B-5
Creating a Custom Expense Report
Because your Expense data maps to row and column areas of your final report, different
Sections require different definitions for the data mapping. To create additional Sections with
different mapping, create corresponding additional lines to the mapping table file named
Maptable.xls. This procedure is explained later in this appendix.
If a section contains cells for prepaid (company paid) expenses, create an additional line in
the mapping table for “prepaid.” This will count as an additional section in the mapping
table. The only data that differs in the prepaid section (from the non-prepaid section) is the
row/column numbers for the expense type.
Analyzing Your Custom Expense Report
If you already have a custom Excel expense report, you can use it with a modified mapping
table. However, before you can create a Maptable.xls file that corresponds to your custom
Expense Report, you must first analyze the characteristics of your report.
Perform the following before you begin a custom mapping table:
! Print a copy of your custom expense report. Activate the Row and Column Headings
option in the Sheet settings of the Page Setup command. This enables you to quickly
Section 1
(not prepaid)
Section 2
(prepaid)
Section 3