Personalized Community is here!
Quickly find the content you seek
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
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 created a dataport in Navision to import Engineering BOM lines from a text file. I wasn't able to successfully import the lines into Navision, and i wasn't getting any error messages at all. i pretty new to designing dataport. I would gladly appreciate your help.
Can you post a snapshot of the dataport what you have designed.
Here is a copy of the dataport
Try putting Engineering BOM lines.INSERT at the end.
I did, but it still wouldn't import the data, and i get no errors at all :(
I was able review the codes and was able to import the data, but my issue now it to match Quantity to Quantity Per.
In your dataport fields you only have No. and Quantity, how are you getting the BOM Number, if you include all the fields in the file & in the dataport fields then you don't need to add any code, the dataport will import it. Include your BOM Number, Line Number and for Description you can add the code to retrieve it. Check the standard dataport like 5901.
I took your advice, and added those columns but i am really not sure how to write the code to pull in the item description into the Engineering BOM line. I would appreciate your help.
In OnAfterImportRecord Trigger just add this code
IF Item.GET("No.") THEN
"Description" := Item.Description;
IF NOT INSERT THEN
I was able to complete the dataport import process, this is my final code.
You don't need to use Item.INIT statement and the IF condition to check for type::Item since you already have Item.GET statement. After Line No. Insert you just need this code
"Description" := Item.Description;
Great, it works as well. Thanks for the help Suresh, i am not a developer, but i have been thrown into this role. I do have another issue i need help with.
The report in 2009 is called Order Pick Ticket report, and and the dataitem used is the sales line, there is a code in the back end that pull the information from the item specifically the shelf no, but for the life of me not sure how to use this information to create a sorting in the report.
IF Item.GET("Sales Line"."No.") THEN BEGIN
ShelfNo := Item."Shelf No.";
Are you using the classic version or RTC version ?
2009 Classic SP1
unfortunately you cannot sort based on the Variable value it should be a field, then you can create a key and sort the dataitem based on that field.
Business Applications communities