Personalized Community is here!
Quickly customize your community to find the content you seek.
Now Available in Community - New TechTalk Videos for 2020
Read More about New TechTalks for 2020
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
In my report , when I select a record from CustInvoiceTable, then I need to get the address of the entity of that record from the Organization Administration-organisation-legal entities.
Where theprimary address is yes.
The address datasource is dirPartyPostAddressView.
CompanyInfo is the table which stores the name and DataArea of the legal entity and DirPartyTable.name stores the name of the entity.
Could you give me a code or relation
1)CustInvoiceTable and CompanyInfo tables
2)CompanyInfo and DirPartyTable
3) dirPartyPostAddressView and DirPartyTable
is this question about Dynamics AX or Dynamics 365 for Finance?
If you are talking about D365, I suggest you look at the existing FreeTextInvoiceEntity.
Normally, for reports, companies are interested in the posted invoices. Those you will find in CustInvoiceJour table. CustInvoiceTable is just a "journal" for inserting invoice data. But the actual posted invoice (that also goes to your ledger) is in CustInvoiceJour/CustInvoiceTrans, and SalesInvoiceHeaderEntity/SalesInvoiceLineEntity.
Anyway, about your question.
Relation between CustInvoiceTable and current company is CustInvoiceTable.DataAreaId = CompanyInfo.DataArea
CompanyInfo actually extends DirPartyTable (via DirPartyTable - DirOrganizationBase - OMInternalOrganization so you have all the fields of DirParty table available in CompanyInfo buffer.
DirPartyPostalAddressView and DirPartyTable are related via DirPartyPostalAddressView.Party = DirPartyTable.RecId
You can find this information by studying table relations and table hierarchies in AOT, as well as using the cross references tool (right click object in AOT -> View references).
This is for D365. I am creating a custom report for free text invoice.
Could you tell me what is a Journal?
What is companyinfo buffer?
Thank you so much for your help!
it seems you have some new questions. Please create a new discussion for every question.
Your original question was related to DataAreaId and entities and you have marked the answer as verified.
And I recommend you to study the out of the box Free text invoice report, it will help you find most of the data that you need on your custom report. For example, it contains the information of the sender company.
Moved to D365 Finance forum.
Business Applications communities