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 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 have made reports in Word for packing slip (208), sales Qoute (1304), sales confirmation (1305), sales invoice (1306) and sales creditnote (1307).
I have different information missing, but to start with the packing slip (208), I can only get the Quantity of delivered products on it. I need to have all these three on the product line:
I have tried all the XML RTF's available, and can only get the Quantity delivered on the packing slip!
Anyone know what I can do??
In order to find "Quantity Ordered" and "Quantity in backorder" in report 208 you will have to find the order line connected to the shipment line. Something like this:
IF SalesLine.GET(SalesLine."Document Type"::Order,"Order No.","Order Line No.") THEN BEGIN
QtyOrdered := SalesLine.Quantity;
BackOrderQty := SalesLine.Quantity - Quantity;
This mean you will have to create the variables and put them in the report yourself.
Okay - I have looked at this, but it's a Little outside my league! I have been in the Development, and looked at the report C/AL Code, but it doesn't mean alot to me!
welcome to the wonderful world of NAV where plebian users are not able to do much of anything without paying their 'partners' a toll of some sort.
Here is a step by step guide to define your variables and put them in the report:
When you choose design at the report choose menu "View" and then "C/AL Globals":
In this window you create the variables:
Back in the dataitem window you add your Quantity variables as columns:
On the dataitem "Sales Shipment Line" press F9 to enter the code area:
Now add the code:
You should now be able to add the columns to your layout.
This is great - thanks it works great! Just one thing - there are too many decimals, how can I change this?
If you want 2 decimals you can round the result like this:
QtyOrdered := ROUND(SalesLine.Quantity,0.01);
BackOrderQty := ROUND(SalesLine.Quantity - Quantity,0.01);
I'm beginning to see the "logic" in the coding and different areas to enter columns and so on. Could you show me an example where I get the order no. on the report 208? Working with the different examples really help understanding and working in the development!
This is an easy one, since the value is present in the "Sales Shipment Header" you just have to add a new column under the "Sales Shipment Header" dataelement:
Are you up for one or two more or shall I post them as new questions?
I think the best way will be to post new questions, to make it easier for others to search for solutions.
Business Applications communities