Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »


Introduction

Looking for an easier way to get a batch of invoices entered?

You can now import a spreadsheet of invoice information into a new A/P batch.

Table of Contents

Where Is It Found

File Format

 

 

When you have multiple rows for an invoice for multiple Distributions (columns G-I) or Scheduled Payments (columns J-K), then columns C-F are only considered on the first row for the invoice.

 

Note: A manual check batch may not have scheduled payments (due date and amount due fields) imported.

For a Manual check import for an existing invoice, the following fields may be left blank as their contents will be ignored, the values in the existing invoice will be loaded:

C. Invoice Date

D. Invoice Amount

E. Invoice Description

Importing via menu AP IDM, option EIN

  1. Add the batch header as you normally do for invoice entry:

    1. OR as a manual check batch
  2. The option to import (F1 - Upload Xls file) is only available on a new batch with no invoices entered.
  3. After Pressing F1, the window for the file selection appears. Now select your file and click Open.
  4. The selected spreadsheet is displayed. 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.
  5. If there are any errors, they will be shown in the Error Msg column and your only option is F7 to cancel the import. Then correct the spreadsheet and try again.

 

 

  • No labels