Note: When I say "Bill" here I mean a Bill from a Vendor to us.
I'm trying to import a CSVĀ  file to AP and also have it create the 
corresponding Bill.I have 100+ of these to import else a lot of labor to do it 
by hand...

So... to experiment I exported the Entities AP register as a CSV file.Then 
deleted all transactions except one... just to keep it simple.So now I have 3 
comma separated lines...- Column Title line- Transaction 1 line 1- Transaction 
1 line 2
Now with the AP register still open I click...File > Import > Transactions from 
a CSV fileI then...- select the file to import- tell the importer to ignore 
line 1... the Column Title line- tell the importer the date format to use
Next I start telling the importer the titles of the columns...I leave some 
column titles set to "none" like...Transaction-ID, Number, Commodity/Currency, 
Void Reason, to name a fewI do choose titles for these columns to 
import...Date, Description, Notes, Action, Memo, 

Now I'm stuck...The "Exported" sample shows the next four columns titled as...- 
Full Account Name- Account Name- Amount with Symbol- and Amount Num
BUT... the importer doesn't offer these column name options...
My Question: Which Column Name do I choose from the Importer for the above 4 
lines?
I don't know, for instance, if the Amount with Symbol and the Amount Num should 
have their columns named Withdrawal or Deposit... as those titles seem to go 
with a checking account.
I also don't know how to make the importer identify the double entry accounts 
for each imported transaction... like...- Accounts Payable and Utilities... 
or...- Accounts Payable and Office Supplies... etc
Thanks for any help.


_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Reply via email to