Recurring Vouchers

• Monthly Rental Property

• Monthly Utility Bill

• Monthly Phone Bill

• Recurring Vehicle Loan Payment

Above are some examples of the vouchers that must be keyed on a recurring basis. There may be slight dollar variations but the name IDs and items on the voucher are the same.
AGRIS now provides the ability to import from spreadsheets. This option gives you the chance to create a standard import where you could update the dates and dollar totals of multiple vouchers, and then import them into AGRIS to create new transactions.

How to Setup

1. Enter a document to be the template in A/P.

2. Run the standard voucher report for that document.Voucher Export Spreadsheet (AGEXPIMP)

3. Now you have a spreadsheet that you can use to copy more vouchers and edit the dates and dollar amounts.

What to Edit for Vouchers

• Blank out voucher number (the AGRIS system will assign the next available document number)

• Edit voucher date (6 characters)

• Edit original (aka ledger) date (6 characters)

• Edit due date (6 characters)

• Edit discount date (6 characters)

• Blank out 1^st invoice/settlement number (this is at the end of the record)

• Edit voucher amount and ledger amounts

• Save file as CSV

Open

How to Process

1. AGRIS – Reports – Import Procedures – Standard Import

2. Edit the File Extension from FIL to CSV

3. Click OK to View Import review

   Open

   

4. Click OK to see import options.

5. Select 1) Begin Import Processing

6. Review import file.You can now see that there are new vouchers in AGRIS V9 for 2009-Feb Expenses.

A/P Voucher Import Report