DataAreaId and entities

(0) Share

Report

Posted on by PrachiGupta97

152

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

Between :

1)CustInvoiceTable and CompanyInfo tables

2)CompanyInfo and DirPartyTable

3) dirPartyPostAddressView and DirPartyTable

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

nmaenpaa 101,162 Moderator on at

Like (1)

Report

Hi,

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).

Was this reply helpful? Yes No
PrachiGupta97 152 on at

Like (0)

Report

Hi,

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!

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

Hi,

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.

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

Moved to D365 Finance forum.

Was this reply helpful? Yes No

Join the conversation

Community site session details

DataAreaId and entities

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

DataAreaId and entities

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