Voucher Export File (AGEXPIMP)

Overview

Use this job aid to create the Voucher Export File (AGEXPIMP). The file is sorted by voucher number . The report generates a text file output to the current dataset directory and is limited to vouchers dated on the current day and excludes any vouchers voided. A report is not printed.

To create the voucher export file:

1. From the Toolbar, click ACP for Accounts Payable.
2. From the Accounts Payable menu, select Report Manager, and then select A/P Voucher Reports.
3. Select Print A/P Voucher Report.
4. Select A/P Voucher Export File (AGEXPIMP.FIL).
5. In any of the Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the range, or type the range you want to print the accounts payable report for. Or click the calendar icon and select a date range.
6. Click OK.
7. In any of the Beginning and Ending boxes, click Lookup or type * and press Enter, and then select the range, or type the range you want to print the accounts payable report for.
8. Click OK.
9. In any of the Opt boxes, type an Option Code (0 = all values; 1 = equal to; 2 = not equal to; 3 = greater than; 4 = greater than or equal to; 5 = less than; 6 = less than or equal to) and then type an amount that the Option Code will qualify with.
10. Click OK.
11. In the Subtotal Option Box, type a subtotal option.
12. In the Print A/P Voucher Detail? box, type Y to include voucher detail lines, or type N to summarize numeric values at the subtotal level only.
13. In the Print Grand Total Information? box, type Y to accumulate numeric values for grand totals and indicate the total number of records included in the report, or type N to print without accumulating grand total information.
14. In the Replace Name Id Number with Alternate Name Id#? box, type Y to print the report with Alternate Name Ids instead of the Actual Name Id, or type N to print the report with the actual name id.
15. Click OK.
16. In the Print Disbursement Detail? box, type Y to print the disbursement detail, or type N to omit the detail.
17. In the Print GL Distribution Detail? box, type Y to include the general ledger distribution detail (accounts/amounts, etc.), or type N to omit the general ledger detail.
18. In the Print Voucher Line Item Detail? box, type Y to include the voucher line item detail on the report, or type N to omit the voucher line item detail.
19. In the Print Voucher Remarks? box, type Y to include the remarks, or type N to omit the detail.
20. Click OK.
21. In the Discount Calculation Date box, click the calendar icon, and select a date or type a date that the discount should be calculated for.  If you do not want to calculate a discount, leave this box blank.
22. Click OK.
23. In the Beginning Cash Forecast Date box, click the calendar icon , and select a date or type a date that the cash forecast should be calculated for. If you do not want to calculate a cash forecast, leave this box blank.
24. In the Days to Increment Categories boxes, type the number of days you want to increment your aging categories.
25. Click OK.
26. At the Creating New File prompt, click OK.

Learn more about the Voucher Reports feature:

• Accounts Payable Report
• Voucher Register
• Daily Voucher Report
• Cash Requirements Report
• A/P - G/L Distribution Report
• Voucher Export File (AGEXPIMP)
• Company Owned Unpaid Commodity Voucher Report