5
I would like some expert advice on how to import open vendor invoices via Data Management Framework. I would like to know what are the steps to load invoice header and line information using the General Ledger data entity.
Yes you can use general journal using invoice number, invoice date etc... but preference is vendor invoice journal
Hi,
You can use following entities:
- "General journal" - Vendor invoices will be imported to general journal
- "Vendor invoice journal line" - On Account payable > Invoices > Invoice journal.
You can create the journal header manually and then create the first journal line. Then export the entity to excel format and try to fill out the Excel file with require information (e.g. Vendor ID, amount, invoice number) and import the excel file via the entity.
Thanks Saurabh for taking the time to reply. Much appreciated!
I actually just meant invoice lines. But are you saying that I don't need to break up the invoice by lines but just upload open vendor invoices as one invoice per vendor invoice journal line data entry? Can I also use the General Journal data entity and insert vendor number in the accountdisplayvalue column? Which data entity do you suggest I use?
You can use vendor invoice journal line data entity to upload invoice.
Now when you say header and lines, what do you mean by that? Are you saying you are going to upload invoices by the item breakup like how we do against purchase order?
Normally when we do legacy system data migration or opening balance migration, We directly upload vendor balance using invoice number, date etc... for which you can use vendor invoice journal line data entry.
#1
André Arnaud de Cal...
292,884
Super User 2025 Season 1
#2
Martin Dráb
231,758
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
