Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Importing Open Vendor ...
Finance forum
Suggested answer

Importing Open Vendor Invoices

Posted on by 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.

Categories:
  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 14,932 Super User on at
    RE: Importing Open Vendor Invoices

    Yes you can use general journal using invoice number, invoice date etc... but preference is vendor invoice journal

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 10,873 Super User on at
    RE: Importing Open Vendor Invoices

    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.

  • highroller1043 Profile Picture
    highroller1043 5 on at
    RE: Importing Open Vendor Invoices

    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?

  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 14,932 Super User on at
    RE: Importing Open Vendor Invoices

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans