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 4 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

The import feature is within the same menu option to add a new batch of invoices. APIDM.EIN

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.
  6. 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 your import

                    b.

    Note: You may be required to acknowledge certain things, such as in a manual check batch, when a payment is being made on an existing invoice. The message will instruct you to press F1 to acknowledge an issue or F7 to cancel the import.

  7. The data is imported into the batch and you are returned to the options screen. You may edit the data that has been imported
    Imported scheduled payment information is not accessible in this menu option.

 

          

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • No labels