Import Accounts Payable Multicurrency Vouchers
Use this preprocessor to import vouchers that are not in Costpoint's functional currency using an ASCII file, comma-separated values (CSV) file, or input tables.
The data to be imported must be in a single currency. Multiple currencies require a separate upload file or rows in the tables. You can import both open payables and paid vouchers in this screen.
- To view and edit the transactions loaded by this process, use the Manage Accounts Payable Vouchers screen.
- To review the transactions loaded by this process, use the Print Voucher Edit Report screen.
There are two ways to work with input files in Costpoint:
- You can access the input file from the network by using Alternate File Locations.
- You can upload the input file to the Costpoint database; in which case, no further access to network folders is necessary.
If you decide to use the first option, click in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.
Fields Validated by Company
The following fields are validated by company:
- Vendor
- Vendor Employee
- 1099 Flag
- Pay Vendor
- Pay Vendor Address Code
- Project
- Project Abbrev Code
- Project Account Abbrev Code
- Organization
- Organization Abbrev Code
- Voucher/Fiscal Year
- Account Entry Group
- Subperiod Journal Status
- AP Account
- Cash Account
- Sales/Use Tax Code
- Reference ID
- General Labor Category
- Project Labor Category
Fields Controlled by Company
The following fields are controlled by company:
- Suspense Values
- Voucher Settings
- Vendor Settings
- Multicurrency Settings
Input File Excel Template
Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.
- Related Topics:
- Display the Import Accounts Payable Multicurrency Vouchers Screen
You access the Import Accounts Payable Multicurrency Vouchers screen from the Accounting domain. - Contents of the Import Accounts Payable Multicurrency Vouchers Screen
Use the fields and options to configure the Import Accounts Payable Multicurrency Vouchers screen. - Table Information for the Import Accounts Payable Multicurrency Vouchers Screen
Changes to the Import Accounts Payable Multicurrency Vouchers screen update several tables. - Subtask of the Import Accounts Payable Multicurrency Vouchers Screen
The Import Accounts Payable Multicurrency Vouchers screen has the Exchange Rates subtask. - Related Topics for the Import Accounts Payable Multicurrency Vouchers Screen
Use this section to view special topics related to importing accounts payable multicurrency vouchers.