[mmelanson99]

I am doing an import of AP Vendor Bills from a legacy ERP system. If I have an AMEX bill for one month that was expensed to multiple Accounts, what is the Vendor Bill and Vendor Expense File format?

I know how to import single Vendor Bills from this thread

https://usergroup.netsuite.com/users…ad.php?t=22103

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

Any help is greatly appreciated,

Thanks,
This is a cached copy. Click here to see the original post.

[mmelanson99]

I figured it out, so I will talk to myself an post the answer here for the next person…

Two files

Bills – this is the Header File

External id

Date

Reference No.

Vendor internal id

Vendor

Account (NOTE – this is the Accounts Payable account)

Account_total (Note – this is the Total of the bill, it should sum the individual line items assoicated to it)

Posting Period

Due Date

Expense – this is the expense line

External ID

Reference No.

Account (NOTE this is the individual accounts the expenses are assigned to)

Total (the total of each line… the sum of the expense line must add to Account_total)

Memo

Here is an example…. I wish everyone gave examples like this, I am a visual learner….

Bills

External id,Date,Reference No.,Vendor,internal id,Vendor,Account,Account_total,Posting Period,Due Date

1,4/25/2010,42510,849,AMERICAN EXPRESS,00.211.0000 ACCTS PAYABLE – OTHER,1000,Apr 2011,5/10/2010

Expense Line

External ID,Reference No.,Account,Total,Memo

1,42510,01.712.0003,T & E PLANE FARES,100,Memo 1

1,42510,01.712.0004,HOTEL,100, Memo 2

1,42510,01.712.0006 ,T & E N MISC,100, Memo 3

…..

[phoebez]

Good job mmelanson99. Thank you the solution. I had the same question before and I figured out by myself by never record it. I am pretty sure I forgot how to do i already. Now I am going to keep you post as a reference.

[dwaltmire]

I attempted your suggested file formats and they don’t work.

[Cher Russell]

RE: How to import Vendor Bills with multiple Expense Lines

I am a new user of Netsuite. We are having a software program built to capture weigh scale information. I am looking for an import file for vendor bills that I can pass along to our developer so he can create an import/export file that will capture the information from this other program for importing into Netsuite vendor bills. If any one has a copy of the csv file, I would appreciate a copy.

[felix.guinet]

Hi guys,

For the record : Vendor bills with Items lines can be loaded with only 1 file, but Vendor bills with Expense lines REQUIRE that you use 2 files, 1 for the header info of Bills and 1 for lines.

Cher Russell, I sent you a message, just give me your email and I’ll send you the Bill template I use.

Thanks

[Author]

Posts