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
