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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,206
André Arnaud de Cal... 847 Super User 2025 Season 2
Sohaib Cheema 596 User Group Leader
