Symbol Technologies SPT 1500 - Manual (Page 245)

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, you 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, you need to 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:
t 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
determine the size of the Section(s), as well as the numbers for the start rows and
columns.
Section 1
(not prepaid)
Section 2
(prepaid)
Section 3