Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Commerce updates!Learn about the key capabilities and features of Dynamics 365 Commerce and experience some of the new features.
Download overview guide | Watch Commerce video
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I spend some time to look for some reliable relationship betweent RetailTransactionSalesTrans and CustInvoiceTrans and at first I thought the InventTransId will be the way but in RetailTransactionSalesTrans this inventtransid occurs not all the time which is quite a shame.
I need this connection because from all transactions in POS there will be an invoice after statement posting and I'm working on report showing all sales from POS and from HQ.
Any ideas? Thanks in advance
Moved to the Dynamics 365 Commerce forum.
Every retail transaction will be posted to a sales invoice using the sales orders. Probably, you can first find the reference between the retail transactions and sales order lines. Then you can use the InventTransID from the sales order lines to have the link with the sales invoice transactions.
Thanks for response! I thought about that unfortunately in SalesLines and RetailSalesLines there is no field which I can use to join RetailTransactionSalesTrans. I also looked for relation table but without success.
you can get custinvoicetrans of retail transactions using salesorderid and invoiceid in RetailTransactionTable .
No direct relation between RetailTransactionSalesTrans and custinvoiceTrans but you can use RetailTransactionTable to get custinvoicetrans records.
Business Applications communities