Populating Vendor Invoice Entities from OCR

(0) Share

Report

Posted on by Hight.io

I am trying to create a Proof of Concept to update invoices directly into MS Dynamics 365 Finance (using a Sandbox) from an OCR application. I can see in the Common Data Model Documentation that there are 19 entities relating Vendor Invoices.

https://docs.microsoft.com/en-us/common-data-model/schema/core/operationscommon/entities/finance/accountspayable/vendadvancedinvoiceentity

I can't find any documentation relating to which of these objects needs to be populated. For example, I can see the following 2 entities:

VendAdvancedInvoiceEntity Which contains a field (attribute) for Invoice Total

VendorInvoiceHeaderEntity Which doesn't appear to contain an Invoice Total field

Can anyone clarify which tables/entities I need to populate?

Also are the same entities used for MS Dynamics 365 Finance as are used for Dynamics 365 Business Central?

Thanks,

Rob.

I have the same question (0)

All responses (4)

Answers (1)

Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

VendAdvancedInvoiceEntity is a an entity for advance invoices, which is feature specific to a few countries in central Europe (you can check out CountryRegionCodes property of the entity in D365FO).

VendorInvoiceHeaderEntity and VendorInvoiceLineEntity are main entities for vendor invoices.

Was this reply helpful? Yes No
Hight.io 5 on at

Like (0)

Report

Hi Martin,

Thanks for the swift reply. As mentioned in my initial post, having reviewed the attributes in VendorInvoiceHeaderEntity I don't see an attribute for Invoice Total. Is this held somewhere else or is it simply a calculation from the total of the VendorInvoiceLineEntity entries?

Also, I have a Sandbox for MS Dynamics Business Central and I don't see either of these entities in there. Do you know what the equivalent entities are in Business Central? I have seen documentation on the Incoming Document app in Business Central but haven't yet had an opportunity to play with it (I only installed my Sandbox on Monday). Where do supplier invoices imported via Incoming Documents end up?

Thanks again,

Rob.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

Totals are indeed calculated - from lines, miscellaneous charges, tax setup and such things. If they were set from outside, it could easily lead to data inconsistency.

I can't comment on Business Central, that's why I didn't. Try asking in Dynamics 365 Business Central Forum.

Was this reply helpful? Yes No
Hight.io 5 on at

Like (0)

Report

Hi Martin,

I will indeed post a question on the Business Central Forum. Thanks again for your help.

Rob.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Populating Vendor Invoice Entities from OCR

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Populating Vendor Invoice Entities from OCR

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates