Is there any way or possibility for Entity creation in D365 FNO based on below scenario.?

(0) Share

Report

Posted on by Charan140

Hi,

I am trying to create the entity based on the below scenario. I need to retrieve the records from Standard Table VendInvoiceTrans records having the status Invoiced and the new Custom Table (ISV) having invoice lines but fields more than the standard table having the status New.

I tried composite entities, but it was not possible because there was no relation between the tables.

I tried UnionQuery, but I still get errors that it is not working as per the limitations. Reference: How to: Combine Data Sources in a Union Query | Microsoft Learn

Purpose: using this entity in OData integration with Power Apps

can please assist anyone who worked on this scenario earlier

Charan

I have the same question (0)

All responses (3)

Answers (0)

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

Like (0)

Report

This seems to be a duplicate, or at least a continuation, of Is there any way or possibility for Composite Entity creation in D365 FNO based on below scenario.?. Are you sure that a new thread is needed?

Unfortunately, the problem description ("I still get errors that it is not working as per the limitations") is very vague. Please tell us more, such as where are you getting errors and what the error messages say.

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (0)

Report

Hi,

Can you provide more information (such as business scenarios or screenshots of error messages) to help us better answer questions? At this time, the information you have provided is not sufficient to support us in proposing a solution.

Best regards,

Kevin

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Your problem statement is not clear.

Can you rephrase this statement?

"new Custom Table (ISV) having invoice lines but fields more than the standard table having the status New"

Was this reply helpful? Yes No

Join the conversation

Community site session details

Is there any way or possibility for Entity creation in D365 FNO based on below scenario.?

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

Is there any way or possibility for Entity creation in D365 FNO based on below scenario.?

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