Good afternoon,
I'm trying to import invoices using AP module. In order to import many invoices, i'd to code jobs & info on the excel then import a file as a CSV file.
Looks like there's no obvious mistake, AP keep reject my imported file. i tried =trim() to get rid of spaces as well.
any thoughts? how do i solve this.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA |
API | VendID | 02272017Concur | 02/27/17 Concur Expense Batch | 200000 | 0 | 0 | 0 | 2/27/2017 | 3/1/2017 | 2/27/2017 | ||||||||||||||||
APD | 1-68-00-6086.00 | NoTax | 447 | CATAVI-expense 1 | ||||||||||||||||||||||
APD | 1-68-00-6086.00 | NoTax | 523.45 | CATAVI-expense 2 | ||||||||||||||||||||||
APD | 1-88-00-6010.00 | NoTax | 47.6 | CATAVI-expense 3 | ||||||||||||||||||||||
APD | 1-88-00-6010.00 | NoTax | 35.92 | CATAVI-expense 4 |
API,VendID,02272017Concur,02/27/17 Concur Expense Batch,200000,0,0,0,2/27/2017,,3/1/2017,2/27/2017
APD,,,,,,,,,,1-68-00-6086.00,,NoTax,,,447,,,,,,,,,,,CATAVI-expense 1
APD,,,,,,,,,,1-68-00-6086.00,,NoTax,,,523.45,,,,,,,,,,,CATAVI-expense 2
APD,,,,,,,,,,1-88-00-6010.00,,NoTax,,,47.6,,,,,,,,,,,CATAVI-expense 3
APD,,,,,,,,,,1-88-00-6010.00,,NoTax,,,35.92,,,,,,,,,,,CATAVI-expense 4
This is Text version.i used to save my file as SCV. Please help me with this.