Personalized Community is here!
Quickly customize your community to 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 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 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 am trying to export form the Sales Header Table the field "Completely Shipped" as an Integer. This field will export just fine however the program that this .csv file is importing into needs an Integer. I have tried everything I can find online to no avail. I know you can use c/al code to assign variables but this is where I am having my issue. No matter how I have tried to do this I keep getting the error "Conversion error of illegal type Boolean:=Integer"
Thank you in advance for any and all help.
Based on the value set an integer variable and use that field as an export field instead of completely shipped.
That is what I have been trying to do but I cannot seem to get it to work.
Add this in the OnBeforePassVariable trigger of the field
IF "Sales Line"."Completely Shipped" THEN
CompletelyShipped := FORMAT(0)
CompletelyShipped := FORMAT(1);
and in the xmlport, source type should be Text.
Thank you for the help. I did go into C/AL Globals and add CompletelyShipped as a TEXT input as well as the field property. Now it is compiling however when the export happens it is passing a blank field. I need to assign it an integer.
IF "Sales Header"."Completely Shipped" THEN
Sorry this is probably something very simple but as I am very very new at this I am struggling.
Completely Shipped on the Header is a flowfield, so you need to use
"Sales Header".CALCFIELDS("Completely Shipped");
Mark the answer which helped you to resolve the issue.
Thank you Suresh. I am working on this now. I will let you know how it comes out.
I am still just not getting it. I don't know how to use the CALCFIELDS Function. I am digging into learning it.
Thank you for all your help.
I feel like I am closer. My issue is that when exported to .csv it is only passing "No". I need it to pass the integer or text of 0 or 1. Here is what I have for my code, if you can help. I have declared in C/AL Globals 0 as Text and 1 as Text
root - Export::OnBeforePassVariable()
IF "Sales Header"."Completely Shipped" = FALSE THEN
"Completely Shipped" := "0" ELSE
"Completely Shipped" := "1";
You cannot set "Completely Shipped", change that row to Text and name it CompletelyShipped and assign the value to it. Check the attached image
That made it work. I can now assign whatever I want as an Integer.
Thank you so much for your help.
I use this format to convert analytical genetic sequences. This method is based on a comparison of the known sequences that are in the databases. This site https://gradesfixer.com/ help me write a textual description. Description of our results is a long process that requires knowledge of scientometric databases.
Business Applications communities