Spreadsheet Voucher Process Edits

Spreadsheet voucher edits exist in the spreadsheet, the VOUCHER_BUILD application message, and the Voucher Build process. Valid data must exist in each stage of the process before further processing is performed.

Spreadsheet Voucher Edits

The spreadsheet voucher does not perform major editing. In addition to basic Microsoft Excel spreadsheet validation edits, the spreadsheet voucher edits include:

  • Control Group ID always defaults to NEXT.

  • Voucher Style always defaults to REG (regular).

  • Voucher Source always defaults to XLS.

  • Voucher ID always defaults to NEXT.

  • Required fields contain data.

    See Spreadsheet Voucher Data Fields.

  • Voucher comments are 254 characters or less. (optional)

  • All date fields are either empty or contain a valid date. (optional)

  • Chartfields do not have a trailing space. For example, "DEPT ". (optional)

If one of these validations fails, the generate XML will stop immediately, and the error message will indicate you where and why the validation failed. The optional validations can be turned on or off on the Template page.

EXCELUPLOADFORVOUCHER Message Edits

You must correct EXCELUPLOADFORVOUCHER message errors before the data passes to the Voucher Build process. Edits include data type validations (for example, format, field characters, and file length). The EXCELUPLOADFORVOUCHER message also validates that the business unit entered on the spreadsheet is a valid PeopleSoft Payables business unit.

Voucher Build Process Edits

The Voucher Build process can result in pre-edit errors or vouchers in recycle status. Pre-edit errors prohibit the transaction from being processed by voucher edit processing. Vouchers without pre-edit errors pass to the voucher edit subprocess. The voucher edits are the same edits performed by the Voucher component (VCHR_EXPRESS).

Some of the pre-edits include:

  • Valid business unit.

  • Valid supplier.

  • Valid default location for supplier.

  • Invoice ID required.

  • Invoice date required.

  • Voucher line information present.

  • Distribution information present.

Related Topics