Import Matrix: Expense Report Items
Technical Documentation
Menu > Admin/Manager > System Setup > Purchasing > Expense Report Items
Available Fields
Active
Always use Unit Rate for Gross Amount
Billing Item ID
Class ID
Department
Expense Account Number
Item ID
Item Name
Markup
Sales Account Number
Standard Description
Tax 1 Applies
Tax 2 Applies
Unit Cost
Unit Rate
Use Description on Expense Report
Matrix
Field Name |
Key Field |
Required |
Valid Values |
Table Validation |
Table |
Field Validation |
Comments |
Item ID |
Yes |
Yes |
|
|
|
|
|
Always use Unit Rate for Gross Amount |
|
|
Yes No |
|
|
|
|
Billing Item ID |
|
|
|
Yes |
Billing Items |
Billing Item ID |
|
Class ID |
|
See Comments |
|
Yes |
GL Classes |
Class ID |
If Require Class in the GL Tracking Options is Yes then Class ID must be a valid Class |
Department |
|
See Comments |
|
Yes |
Departments |
Department ID |
If Require Department in the GL Tracking Options is Yes then Department must be a valid Department |
Expense Account Number |
|
|
|
Yes |
GL Accounts |
Account Number |
|
Active |
|
Yes No |
|
|
|
|
|
Item Name |
|
Yes |
|
|
|
|
|
Markup |
|
|
Numeric |
|
|
|
|
Sales Account Number |
|
|
|
Yes |
GL Accounts |
Account Number |
|
Standard Description |
|
|
|
|
|
|
|
Unit Cost |
|
|
Numeric |
|
|
|
|
Unit Rate |
|
|
Numeric |
Yes |
|
|
This field is only used it the “Always us Unit Rate for Gross Amount” is Yes |