I have to say really loving the Dataverse Virtual Tables. But a HUGE miss is the associated CRM GUID aka Primary Key.
Use Case\Story
I am wiring up CRM to BC by pushing Completed Invoices to BC directly from CRM. Not wanting to complicate the system with Sales Orders (I know this works OOTB) but CRM delivers a higher quality Invoice with Grouping, and custom pricing than BC can (there's a lot happening in the background, Azure function/PowerBI,Flow Logic and Canvas Apps deployed to the field)
Ok back on point. The Goal is to push a CRM Invoice to BC. So using PowerAumate I have triggered on CRM Invoice Add/Mod and the flow creates the BC Sales Invoice. Next is the difficulty. That is having to take a CRM Product Item, go into BC based on Display Name (terrible idea) lookup the Item ID for every line item. Then do the same thing for Item UOM each line item
All of those unecessary lookups back to BC could be avoided by simply putting the CRM ID into the Dataverse BC Item table (and the same for the Item Unit of Measure).
Since BC is ALREADY sync'ing the item with CRM product somewhere somehow BC knows the items CRM primary GUID key.
Where is it and how can I get this into the BC Virtual Table
