Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
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 | Talent TechTalks | Upcoming TechTalks
I have produced a Data Entity for exporting Open Item data from Dynamics 365. The base table that I use for this is the CustTrans table, and I'm trying to identify the link between this table, and the WMSBillOfLading table.
I have tried to include the CustInvoiceJour table in the data entity, and this causes my project to fail to build.
Does anyone have any knowledge of how the two are linked?
We do not export line level invoice data, so if the Bill of Lading directly relates to specific lines on an invoice, this may not be possible.
Any help with this would be greatly appreciated.
WMBillOfLading table is associated with shipments, i do see relation with sales table but it's no where close to custInvoiceJour or CustTrans table.
You need to see data in your system and see if InventTransRefId is storing the sales order related information, if yes then you can somehow link the tables but it may not be ideal for all scenario Or provide you accurate information. Here is what you can do..
Link CustTrans table with CustInvoiceJour. From custInvoiceJour identify customer and sales order number.. using sales order number and customer number, get data from bill of lading (What if you have multiple shipments and multiple bill of lading.. multiple records). For the error message that you are getting when joining tables, suggest that you open a separate thread. but before you do that do some data analysis to see if what i have proposed make sense.
Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.
Thanks for the response.
That's about where I got to with this, the CustInvoiceJour table contains a BillOfLadingID, which I would have exported if the join was successful. I think in this case, I need to identify why the join is causing errors.
It sounds like the InventTransRefId may not always contain sales order related information? If that is the case, unfortunately I will not be able to use that method. This data entity has to be applicable to multiple instances of Dynamics 365 FO, as it is sent to our customer's for us to then extract the data we need from their environments.
My understanding of bill of lading is very limited, but from what you suggest it sounds like you could potentially have multiple bill of lading's per invoice?
Business Applications communities