Versions Compared

Old Version 2

changes.mady.by.user Danielle Chamberlain

Saved on

compared with

New Version 3

changes.mady.by.user Danielle Chamberlain

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width60%


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

Table of Contents
excludeTable of Contents|Introduction

Column
width40%
Panel
titleArticles Referenced in this Article
Outgoing links
spacesDOC,HDHDZ,AMSU,GS
labels-cct,-zzz
Panel
titleArticles that Reference this Article
Incoming links
spacesDOC,HDHDZ,AMSU,GS
 
Panel
titleCentral Table References
Outgoing links
spacesDOC
labelscct,zzz

 

 

Where Is It Found

Ui expand
titleWhere to find it

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

File Format

 

Ui expand
titleStandard Format

Column format of your spreadsheet:

Column

Contains

Comments

A

Vendor #

Required on every line

B

Invoice #

Required on every line

C

Invoice Date

Required for new invoices.  MM/DD/CCYY or MMDDYY format

D

Invoice Amount

Required for new invoices.

E

Invoice Description

 

F

Hold Status

WD (when due) / NC (next check) / WS (when scheduled)

G

G/L Account

When blank, system will pull vendor default account or APG.

H

Distribution Amount

When blank, system will assume Invoice Amount.

I

Distribution Description

 

J

Scheduled Due Date

Only for scheduled payments  (Hold Status WS)

K

Scheduled Amount Due

Only for scheduled payments  (Hold Status WS)

L

Check Date

Manual Check batches:  required on 1st line of invoice

M

Check ID

Manual Check batches:  required on 1st line of invoice.

Up to 6 digit check number or full 12 digit e-payment id.

Checking account code (CKA) per batch header.

N

Check Amount Paid

Manual Check batches:  required on 1st line of invoice.

O

Discount Taken

Manual Check batches:  optional.

Ui expand
titleDataServe Format

Column

Contains

Comments

A

DataServ DIN

Dataserv Id Number for the invoice

B

Location

AMS account

C

Invoice No

Vendor’s invoice ID

D

Inv Total

$

E

Inv SubTotal

$

F

Inv Date

 

G

Vendor Num

AMS vendor#

H

Hold Status

AMS hold code

I

Agriculture Inv?

‘1’ = invoice applies to Agriculture Management Module, bypass this invoice.

J

Check Memo

 

K

Cost Center

Ignored

L

Main & SubAcct

Full GL account# for Distrib Amt to be applied to

M

Task

Applies to Ag Mgmt invoices only

N

Block

Applies to Ag Mgmt invoices only

O

Distrib Amt

$

P

Distrib Desc

 

 

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.

 

Info

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

Ui expand
titleStep 1: Step 1 Title
Step content
Ui expand
titleStep 2: Step 2 Title
Step content
Ui expand
titleStep 3: Step 3 Title
Step content

Feature Overview & Examples

Thing 1

Sub Thing 1

Thing 2

Sub Thing 2

Thing 3

...

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. Image Added
      OR as a manual check batch
    2. Image Added
  2. The option to import (F1 - Upload Xls file) is only available on a new batch with no invoices entered.
    1. Image Added
  3. After Pressing F1, the window for the file selection appears. Now select your file and click Open.
    1. Image Added
  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.
    1. Image Added
  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.
    1. Image Added