Hi,

I am trying to import a csv file to AP as an invoice batch but I am receiving a import validation error. Below is a sample of the csv file I am importing:

CSV FILE FORMAT:

"H","VENDOR","INV #"
"D","DIST CODE","PAYABLE AMOUNT"

EX:

"H","MARAME","70930-001"
"D","CODE1","100.00"

PLS COMMENT ON THIS....

THANKS,

NORMAN PASCUA

CA COMPUTER SYSTEMS

Hi Norman,

What is the validation error you are getting? Typically a message like "Vendor number 'MARAME' on record 1 is invalid". That might help in identifying the issue.

There is one required field missing in the Header section, 'Hdr-Transaction Type'. This identifies the transaction as an invoice, credit note or debit note. Perhaps you need to include this in your import file.

If you have questions for what fields are required, the Help file has a layout for importing and all the required information. From the main help screen, choose 'Importing and Exporting', then choose the bold link 'Import and Export Format notes'.

Hi,

I checked the help notes and I made some changes with the import csv file and in the invoice import template as follows:

IMPORT FILED SELECTION:

Hdr-Record Type ('H')
Hdr-Vendor Number
Hdr-Invoice Number
Hdr-Transaction Date
Det-Record Type ('D')
Det-Distribution Code
Det-Amount Payable


FIELD DEFAULTS:

Hdr- Trasaction Type(string)------ Value=Invoice
Det- Detail Type ------ Value=Purchase


SAMPLE CSV FILE FORMAT:

"H","MARAME","70930","20070930"
"D","CODE1",100.00


ERROR MESSAGE: "Invalid Data for field called Det-Record Type ('D') of record 1"

PLS COMMENT...

THANKS,

NORMAN

CA COMPUTER SYSTEMS

Hi Norman,

Thanks for the error message - that is useful.

With that template layout and import information, I was successful in importing the invoice with Payables 8.1A.

Do you have the option 'Header fields on each record' selected? If so, this is a problem because you have the 'H' and 'D' portions on separate rows. Having this checkbox selected gives the error you reported. Because you (correctly) have H a dn D lines on separate rows, you should not use the 'header fields on each record' option when importing. This option is really for Excel-format files, where all the H and D fields are on the same row, and the H values are repeated for each detail.

Hi,

Thanks a lot...you are right as soon as I uncheck the Include header check box, the import process went through fine..


Thanks a million,

norman