Skip to main content

Notifications

Announcements

No record found.

Supply chain | Supply Chain Management, Commerce
Unanswered

New custom field in F&O, CDS and the Prospect to cash solution

(0) ShareShare
ReportReport
Posted on by 24

I added a new custom field to the SalesTable in F&O and need it to be available for BYOD export and the Prospect to cash solution we currently use (CRM Sales to SCM Sales orders/lines, see links below). Everything looks good in UAT with the exception of being able to add a mapping for the field in the Data integration project in Power Platform. Our VAR that implemented our D365 had added a custom field during our implementation and it shows up for selecting with a mapping so I know I should be able to add another. I’m not seeing this field available though.

I added the field to the following tables:

  • SalesTable

  • SalesOrderHeaderV2Staging

  • SalesOrderHeaderCDSStaging

I added it to the following entities:

  • SalesOrderHeaderV2Entity

  • SalesOrderHeaderCDSEntity

From what I can tell, the key table and entity for the Prospect to cash solution are for CDS/Dataverse. I have refreshed the data entities and generated the mapping for the entities in UAT. I assumed this would make the field available in Power Platform, but no luck. Is there anything that I am missing? Does a batch job need to be run?

https://learn.microsoft.com/en-us/dynamics365/supply-chain/sales-marketing/prospect-to-cash

https://learn.microsoft.com/en-us/dynamics365/supply-chain/sales-marketing/sales-order-template-mapping-direct-two-ways

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans