Finance | Project Operations, Human Resources, ...

Data entity containing field from GeneralJournalAccountEntry and InventTrans

(0) Share

Report

Posted on by Mohamed Amine NAIJA

Hello,

I'm trying to create a custom Data Entity that retrieves data from two tables: GeneralJournalAccountEntry and InventTrans.

I created the entity manually, meaning, I created a Query, which primary datasource is InvenTrans, then a View then a data entity based on this view, the problem is that i cant find a direct relation between these two tables.

Could anyone help me with this, I would much appreciate it.
Thanks.

I have the same question (0)

All responses (3)

Answers (0)

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Mohamed,

could you explain what kind of information you want to export? Once you have drafted how the output should look like, perhaps you will notice what kind of data sources and links are needed.

Was this reply helpful? Yes No
Mohamed Amine NAIJA 9 on at

Like (0)

Report
Copy link

Link copied!

Hey Nikoalos,

My client, an automotive distributor using Annata Solution, would like to set up a business intelligence cube, one of this cube's tables is called Vehicle Ledger Entry and it has to be populated with some fields mainly from InventTrans (such as ItemId, DateFinancial, CostAmountPosted, Qty, etc..) and another field from GeneralJournalAccountEntry which is the AccountDisplayValue. Now I know these two tables are somehow connected and i need to find the path bewtween them both to create the custom Data Entity for the data export batch jobs.

I was thinking about a solution but i dont know it works, which consists in creating an table extension and adding a new relation with GeneralJournalEntry using these fields: Voucher and DateFinancial. Do you think this could work ?

I really hope it was clear enough, this is the best way i could describe this need.

Thanks and have a great day.

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohamed,

There is no direct connection between GJAE and InventTrans and you need to use InventTransPosting + InventTransOrigin in between.

Are you planning to use BYOD or EntityStore?

In the case of BYOD, my recommendation is to make (or re-use if exists in standard) entity per each table and make relation outside F&O entity. Usually mentioned tables contain a huge amount of records and it's better to utilize change tracking to reduce the amount of data transferred between, but if you will have a lot of data sources on the entity, export performance can be degraded significantly.

You can check also a similar article community.dynamics.com/.../linking-inventtransposting-to-its-posted-value

Was this reply helpful? Yes No