[thanebower]

Hello all,

Doing our normal weekly csv import of vendor bill transactions, I had an error today that said “Please choose an item to add”. I haven’t had to add that previously as I am importing expenses not items (I made the REQ Null). I looked at the REQ(uirements) and there weren’t any more added. Then I saw a new key symbol next to both the bill and items fields called orderline… anyone know what that equates to?
This is a cached copy. Click here to see the original post.

[elham]

Please open a Support case and post the number here. We will investigate the problem.

[northern_brewer]

RE: CSV Import Vendor Bill

Anything to report? I too want to import vendor bills with expenses only. It seems impossible.

EDIT: Looks like you can’t do it as a single CSV — you need to import multiple CSV files to get access to Vendor Expense fields.

[carrie.roesner@centro.net]

RE: CSV Import Vendor Bill

I would like to import vendor bills with expenses only as well – did anyone figure out how do this?

Thanks!

-Carrie

[dan.aronson@safemart.com]

RE: CSV Import Vendor Bill

I just tested CSV importing vendor bills with expenses (no items) in Sandbox and it worked.

To do this I used “Multiple Files to Upload”:

1) Primary file had all the required Item fields with no values and had an External ID for each transaction record (plus fields for date, period, vendor, terms and liability account)

2) Linked file had fields for External ID, Expense Account and Amount for each transaction record and the External ID matched the record in the Primary file that I wanted to link the expense account and amount to.

If someone has a better way, please let me know.

Hope this helps.

[JayJ]

RE: CSV Import Vendor Bill

I’ve just spent the last couple of hours trying every possible combination of files and columns to try to import vendor bills with expense account lines, without success. I’ve done virtually every other kind of CSV import for years. I must be missing something. Anyone have a hint for me?

[JayJ]

RE: CSV Import Vendor Bill

Here’s what the problem was: If you name a column “Amount,” it automatically maps to an item line amount and NetSuite then requires an item.

When I renamed the Amount column to “Total,” everything was fine. I think this is a gotcha that should either be fixed or put into the documentation.

[garyr14]

RE: CSV Import Vendor Bill

Does that mean you did it with one file? If you don’t mind, exactly what fields did you use?

Thanks

[JayJ]

RE: CSV Import Vendor Bill

No, I did it with two files, one for the bill and the other for the expense line(s). Fields:

1) Bills

External ID (match to line)

Date

Memo

Reference No.

Vendor Internal ID

Posting Period

Terms

Due Date

2) Expense Line

External ID (match to body)

Reference No.

Account

Total (not named “Amount” )

Memo

[garyr14]

RE: CSV Import Vendor Bill

Thank you! Very helpful.

[ms_cherrie]

I just want to share this. I had imported bills using a single csv file with only expense items. The link below is the proof that it’s possible. HOWEVER, for unknown reason, when I tried to do it again, it’s not available anymore. The “Vendor Bill Expenses” are no longer available. This is weird. I tried to do the same thing for our other client and it allows me to import a single csv file.

What causing it to allow it before and not anymore but allowed to ther accounts is really baffling. I checked maybe a feature was disabled but I can’t see anything has changed. I called the Help Desk and they can’t explain to me what happened. Rather, they told me the workaround, which is uploading 2 csv files.

here’s the file.

https://docs.google.com/viewer?a=v&p…lZDAz&hl=en_US

[ddestefano@bit9.com]

Thanks for this thread. Solved the difficulty I had as well. One other “gotcha” – the G/L account needed to be Number “Space” Name. i.e. “6710 Airfare”.

I did the 2 files – worked fine.

[Gaurav Agrawal]

Rename all Column Headers in csv (no column name should be meaningful). This forces NetSuite not to map any of the fields. Do the mapping manually and import happens error free!!

[sheetal]

hi,

I also using CSV import to import Vendor bill and got success in both single and multiple files.

here I am giving some reference id , which is very help ful to import Vendor bill using CSV in netsuite.

Answer Id: 25460,10020,19043,23338,24098

hope this is helpful

[Author]

Posts