Topic Options
#41749 - 05/30/14 09:37 AM AP invoice import .csv layout
Davis Offline
Casual

Registered: 10/10/13
Posts: 13
Loc: Madras, Oregon USA
Looking for the layout of what a .csv file should be to import invoices to AP.

Have reviewed \softrak\apwin\samdata *.csv files. When you go to do an import is defaults to APINVIM.CSV the the layout of this file looks too simple.

APINVIM.CSV:

H "INT01"
D "INV" 450
D "INV" 150
H "BEN01"
D "INV" 89.95
D "INV" 50
H "CHE01"
D "INV" 119.99
H "SPO01"
D "INV" 100
H "SPO01"
D "INV" 55

Any direction would be helpful.
Thanks,
Davis

Top
#41750 - 05/30/14 10:12 AM Re: AP invoice import .csv layout [Re: Davis]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4505
Loc: Wynnewood, PA
Open up the file \Softrak\APWIN\Samdata\APINV.XLS and you will see what a sample layout should be. You can skip fields you don't need to include, but it is pretty complete.

I recommend using Excel and not CSV when importing.

Steve

Top
#41757 - 05/30/14 12:08 PM Re: AP invoice import .csv layout [Re: Steve Schwartz]
Davis Offline
Casual

Registered: 10/10/13
Posts: 13
Loc: Madras, Oregon USA
Thanks Steve. This looks like what were looking for!

Davis

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 69 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14449 Topics
70594 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