Not able find AXDB tbales in Dataverse

[Perumal]

Dear Team,

The D365 AXDB database contains the InventTransOrgin table, but I am unable to find the same table in Dataverse.

Could you please guide me on how to sync the InventTransOrgin table from AXDB to Dataverse in D365 configuration?

Your assistance would be greatly appreciated.

Best regards,

Perumal

[v-kpoloju-msft · Accepted solution]

Hi @Perumal,

After thoroughly reviewing the details you provided, I have identified few alternative workarounds that may help resolve the issue. Please follow these steps:

The InventTransOrigin table in Dynamics 365 Finance & Operations (AXDB) is not directly available in Dataverse by default. This is because only specific tables (or entities) are synced through Dual-write or made accessible via the Data Export Framework.

To sync the InventTransOrigin table from AXDB to Dataverse, follow these steps:
Open Dual write in D365 Finance & Operations. Navigate to Dual-write mappings (Data Management > Dual-write). Search for a mapping related to InventTransOrigin. If there is no mapping, you must create a custom one.

To create a Custom Table in Dataverse, open Power Apps (make.powerapps.com), go to Dataverse > Tables, and click New Table to define fields matching InventTransOrigin. Configure Dual write in D365 Finance & Operations by creating a mapping between AXDB. InventTransOrigin and the new Dataverse Table, ensuring correct field mappings and enabling the mapping. Insert or update records in InventTransOrigin in AXDB. Verify if records sync to Dataverse.

To enable a Data Entity for InventTransOrigin, navigate to D365 FO > Data Management. Verify if InventTransOrigin is listed as a Data Entity. If it is not available, create a Custom Data Entity in Visual Studio. Configure the Data Export Framework to export data to Azure SQL or Azure Data Lake. Then, set up a Power Automate flow or an ADF pipeline to transfer data from Azure SQL/Data Lake to Dataverse.

To access data in Dataverse without storing it: use virtual tables with OData endpoints to expose InventTransOrigin or use a custom API with Azure Function or Logic Apps to fetch and expose InventTransOrigin data.

 
kindly please refer to the below following link for more information:
Guidance for dual-write setup - Finance & Operations | Dynamics 365 | Microsoft Learn
Build and consume data entities - Finance & Operations | Dynamics 365 | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you.

[v-kpoloju-msft]

Hi @Perumal,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-kpoloju-msft]

Hi @Perumal,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-kpoloju-msft]

Hi @Perumal,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.