Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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,