Dynamics Community Forum Thread Details

How to extend a standard table for adding the custom fields?

Hi folks, I have a requirement in D365 Commerce of adding a custom field to the salestable. For that I have created an Extension table as suggested by Microsoft https://docs.microsoft.com/en-us/dynamics365/commerce/dev-itpro/commerce-runtime-extensibility#scenario https://docs.microsoft.com/en-us/dynamics365/commerce/dev-itpro/channel-db-extensions .

I have implemented post trigger correspond to the CreateOrderFromCartResponse but I am getting SalesId as null but transaction id is there. I tried to look up the RetailTransaction table for SalesId using transaction id but the SalesOrderId is null in that table as well.

I am using Commerce SDK (Commerce Scale Unit) https://github.com/microsoft/Dynamics365Commerce.ScaleUnit for development and deployed the Package with SQL script for table creation and CRT for post trigger using the same.

Here I have following concerns:-

Whether the way which I am using is correct or I have missed something?
How can view the Extension table in F&O?
For which DataRequest or Response I can get the SalesOrderId that I can use in my extension table?

Thanks,

Aman Soni

Quick Links