Spreadsheet Voucher Data Fields

Most data fields in the regular voucher entry process are included in the spreadsheet voucher. You can configure the voucher spreadsheet for the appropriate data entry required.

Note:

SpeedCharts are not supported by Excel Voucher Upload.

However, certain fields must contain data in order to properly convert the data into an XML file.

The fields requiring data are:

Record Type Field

Voucher Header

  • BUSINESS_UNIT

  • INVOICE_ID

  • INVOICE_DT

  • VENDOR_ID

  • GROSS_AMT

Voucher Line

  • BUSINESS_UNIT

  • VOUCHER_LINE_NUM

  • MERCHANDISE_AMT

Voucher Distribution

  • BUSINESS_UNIT

  • VOUCHER_LINE_NUM

  • DISTRIB_LINE_NUM

  • ACCOUNT

  • MERCHANDISE_AMT

Note:

You do not have to enter voucher line numbers or distribution line numbers. VB macros generate that data based on the location of the data.