Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
How to import Vendor Bills with multiple Expense Lines
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,
0