Export to Text Check Option
The Check option for the Export to Text feature produces a text file that has a fixed format that you cannot change.
When you select the Check option in the Export to Text field on the Bank Codes tab of , the text files that are created in Accounts Payable and Employee Expense Payment Processing are formatted as follows:
-
Lines start with a character that defines the detail of that line.
-
Double quotation marks are used as delimiters or text qualifiers between fields in a line.
-
Lines that begin with C contain the following check information: "C""Check No""Check Date"""Check Amount""Payee name""Payee Address1""Payee Address2""Payee Address3""Payee Address4""City""ST""ZIP""COUNTRY""Vendor ID""AccountID"
-
Lines that begin with E contain the following Electronic Funds Transfer (EFT) information: "E""BankID""Account""Account Type""EFT Amount"
-
Lines that begin with D contain the following voucher details for the check stubs: "D""Invoice Date"""Invoice Number"""Voucher""Invoice Amount""Discount""Previous Pay""Net Amount"
-
Lines that begin with T contain the following totals for the check stub: "T""InvAmtTotal""DiscountTotal""NetTotal"
-
Voided checks have the word "Void" as the amount.
Example
The following lines are from a text file that uses the Check format and contains two checks:
"C""Check No""Check Date"""Check Amount""Payee name""Payee Address1""Payee Address2""Payee Address3""Payee Address4""City""ST""ZIP""COUNTRY""Vendor ID""AccountID"
"E""BankID""Account""Account Type""EFT Amount"
"D""Invoice Date"""Invoice Number"""Voucher""Invoice Amount""Discount""Previous Pay""Net Amount"
"D""Invoice Date"""Invoice Number"""Voucher""Invoice Amount""Discount""Previous Pay""Net Amount"
"D""Invoice Date"""Invoice Number"""Voucher""Invoice Amount""Discount""Previous Pay""Net Amount"
"D""Invoice Date"""Invoice Number"""Voucher""Invoice Amount""Discount""Previous Pay""Net Amount"
"D""Invoice Date"""Invoice Number"""Voucher""Invoice Amount""Discount""Previous Pay""Net Amount"
"T""InvAmtTotal""DiscountTotal""NetTotal"
"C""Check No""Check Date"""Check Amount""Payee name""Payee Address1""Payee Address2""Payee Address3""City""ST""ZIP""Vendor ID""AccountID"
"E""BankID""Account""Account Type""EFT Amount"
"D""Invoice Date"""Invoice Number"""Voucher""Invoice Amount""Discount""Previous Pay""Net Amount"
"D""Invoice Date"""Invoice Number"""Voucher""Invoice Amount""Discount""Previous Pay""Net Amount"
"D""Invoice Date"""Invoice Number"""Voucher""Invoice Amount""Discount""Previous Pay""Net Amount"
"T""InvAmtTotal""DiscountTotal""NetTotal"