ATS Template FAQs

The following transactions can be created using an ATS Upload:

• Journal Voucher 1 (JV1STND, JV1ADVN, JV1TRES, JV1BOND, JV1CL)

• Cost Accounting Journal Voucher (JVC)

• Accrued Receivables (ARE)

• Cash Receipts (CR)

• Charge Transaction Correction (CHC)

• General Accounting Expenditures (GAX)

• Internal Exchange Transactions (IET)

• Inventory Adjustments (IA)

• Invoices (IN)

• Manual Accruals (ACC)

• Receivables (RE)

For instructions on using an ATS Upload, check out the Uploading an ATS Spreadsheet job aid.

No, you must leave the worksheet named Sheet1. If you change the name of the worksheet, the PDI map that enables the upload will not be found, and you will receive an error message.

These requests should be directed to the CORE Governance Committee (CGC).  You can submit a request by using the New Requests Form located on the CORE Governance page.

Columns cannot be deleted from ATS Spreadsheet Uploads. If you delete columns, the template may be corrupted, and not work, and you will have to download a new template. If there are columns on the ATS template you do not wish to use, rather than deleting the columns, you may hide them.

Things to remember for ATS Spreadsheet Templates:

• Do not modify the template formatting settings.

• Only add the information needed for the transaction creation.

• If you need to, you can hide columns but do not delete them.

There are two CR based ATS templates available for creating transaction uploads to CORE

• Cash Receipt (CR)

• 10XX Account Cash Receipt (CR10XX)

The Cash Receipt (CR) upload should be used for the creation of standard Cash Receipt (CR) and Cash Receipt Treasury Walk in (CR3) transactions.   The 10XX Account Cash Receipt (CR10XX) transaction differs from the two other transactions in that CR10XX transactions

• Use external, approved bank accounts

• Should not reference Treasury Cash

Columns cannot be deleted from ATS Spreadsheet Uploads or they won't work and the template may be corrupted.  You can hide columns, but you cannot delete them. If any columns were deleted, you will have to download a new template.