Topic Options
#26474 - 03/07/11 04:40 AM AP Invoice Import
andromeda Offline
New Guy

Registered: 03/01/11
Posts: 6
Loc: Houston
HI - First attempt at Import. I receive the following messages when trying to import AP invoices:
Invalid Data 'AMEX Jan 11' for field called 'HdrTransaction Type (int)' of Record 1
Invalid data 'A' for field called 'Det-Record Type ('D) of record 1.
Invalid data 'D/1300' for field called 'Det-G/L Acct/Dept' of Record 1.

I followed the detailed instructions for loading the Headers and Detail as follows (Columns):
Hdr-Record Type = H
Hdr-Vendor Number
Hdr-Invoice Number
Hdr-Transaction Date (I inserted the invoice date using this format "03/01/2011")
Hdr-Reference
Hdr-Description
Hdr-Transaction Type (1)
Det-Record Type (D)
Det-GL Account
Det GL Dept
Det-amount Payable
DetDetail description.

It looks to me like the load is getting the columns confused. can anyone help? Thanks for your ideas!
Denise

Top
#26475 - 03/07/11 06:26 AM Re: AP Invoice Import [Re: andromeda]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4509
Loc: Wynnewood, PA
Hi Denise

The fields (columns) in your import file do not match the import template. That's about as much advice as I can give without seeing the import file and the import template.

Importing invoices involves a learning curve. My suggestion to you is to go into the sample data and import invoices there, and then when it works, check out how the import template matches the import file. Once you understand the relationship, then try it on your own data.

The other suggestion, as obvious as it sounds, is to ask your Adagio consultant for help. He/she has already gone up the learning curve and can diagnose the specific problem you are encountering.

Steve

Top
#26476 - 03/07/11 06:57 AM Re: AP Invoice Import [Re: Steve Schwartz]
andromeda Offline
New Guy

Registered: 03/01/11
Posts: 6
Loc: Houston
Thanks! That was my second line of attack - to ask the software support person. I'm sure it's something simple - just the first time for me.

Top


Moderator:  Softrak Support 
Who's Online
1 registered (Samuel Kopstick), 59 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30