web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Data Integration - purchase invoices

(0) ShareShare
ReportReport
Posted on by 5

Apologies if this appears twice, I am not seeing any confirmation that my previous attempt was accepted so am trying again.

The world of Dynamics seems large, and I want to quickly get to the essentials so any pointers to simple, step by step guides would be greatly appreciated. 

What I need to do is send purchase invoice data from a vertical market application to Dynamics365. 

Every other interface I have written in the past boiled down to populating CSV or XML files with the correct fields and I assume D365 is no different. I am pretty sure it will be a question of mapping source data fields to fields expected by D365.

Where can I find a list of the required fieldnames in D365?

I will be sending supplier invoice data so the fields I am looking for are ones such as:
Supplier Account Code
Invoice Transaction Date
Invoice Payable Date (optional)
Invoice Nett Amount
Invoice Tax Amount
Invoice Gross Amount

Detail Lines:
Item Description
Item Quantity
Item Unit Price
Item Nett Price
Item Tax Code
Item Tax Amount
Item Gross Amount

All rather standard items which I am sure D365 handles with ease. Yet in my initial searches I didn't find anything that explained the names of the fields. 

I had a look here but couldn't quickly find a link to where I find out the fieldnames, and ideally some sample files or sample code.
docs.microsoft.com/.../data-management-api

Thanks for any info.

I have the same question (0)
  • WillWU Profile Picture
    22,363 on at

    Hi Steven Harris,

    There is no such OOB data entity.

    Please check the VendInvoiceJour table and VendInvoiceTrans table.

  • Steven Harris Profile Picture
    5 on at

    Many thanks for the info.

    Unfortunately I am researching this based on customer request and I don't have D365 installed so I cannot check those tables.

    Is there not any Microsoft documentation on this?

    In the past, vendors of accounting software such as Sage have supplied pretty clear documentation on how data can be imported. I assume Microsoft has the same, although I admit that after spending an hour or so searching and looking at the D365 documentation site I couldn't find it. Hence my post.

  • Steven Harris Profile Picture
    5 on at

    For example with quickbooks they have this:

    To import a list in the CSV format, you need to install the QuickBooks Import Excel and CSV toolkit.

    The toolkit contains: Import from Excel and CSV Manual â€“ a PDF document with instructions, best practices, and notes.

    CSV Examples Folder â€“ 4 sample CSV files, one for each type of list. XLS Example Folder â€“ a sample Excel file containing 4 worksheets, one for each type of list.

    Allowed fields â€“ a reference guide explaining what fields are available for Excel and CSV import.

    Anything similar to this in D365?
    In particular I am looking for something akin to the "Allowed Fields" in quickbooks.
    A reference guide explaining what data fields or entities are available for import of Purchase Invoice data into D365.

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.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 732 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 413 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 289 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans