Importing your Grape Contract Spreadsheet into Accounts Payable

Check with your Controller to make sure you're allowed to make entries to Accounts Payable before proceeding. Since accounts payable sends out money, it can be a big deal if you enter something to Accounts Payable without being authorized to do so. If not authorized just provide the spreadsheet to your Controller for loading Grape Contract payments to AP.
On the Accounts Payable Invoices and Distribution menu, choose EIN – Enter Invoices and/or Manual Checks.


Add the batch header as you normally do:

The option to import (F1 – Upload File, red box below) is only available on a new batch with no invoices entered yet:


After pressing F1, the window for file selection appears. Select your file and click Open.

NOTE: If the file you're importing is open the import will fail.
You'll receive an error message on the status line. If you receive this error, cancel your import. Then on the A/P Invoice Entry Options Screen choose Option D (Change batch detail data) to retry your import after closing the Excel file.

The selected spreadsheet is displayed. Note you can choose to omit lines using the checkboxes on the left side of the screen. In our example, below, the system elected to skip the heading line.

If this is the data you want to import, press F1 to continue, otherwise, press F7 to cancel the import and you will be returned to the option screen.
If there are any errors, they will be shown in the Error Msg column and your only option is F7 to cancel the import (F7), correct the spreadsheet and try again.

In our example, above, we're asked to acknowledge we're skipping a heading row. Press F1 to acknowledge and continue. Or press F7 to cancel the import.
Asking you to confirm any exceptions is a safety step to assure you're not inadvertently skipping the upload of some of your data.
If no errors are found, you will see the data as it is going to be imported.
When no G/L account was entered in the spreadsheet, the system will show you either the vendor's default account or the vendors default APG code and description. Payment terms and discounts will also be shown.
Press F1 to complete the import.

The data is imported into the batch and you are returned to the options screen.
Note the status message: Import Request Completed.
You may edit the data that has been imported.