NAV design reports/templates in word

(0) Share

Report

Posted on by Community Member Microsoft Employee

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:

Quantity ordered
Quantity delivered
Quantity in backorder

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??

*This post is locked for comments

All responses (11)

Answers (2)

Community Member Microsoft Employee on at

Like (0)

Report

RE: NAV design reports/templates in word

Hi Jesper

I think the best way will be to post new questions, to make it easier for others to search for solutions.
Community Member Microsoft Employee on at

Like (0)

Report

RE: NAV design reports/templates in word

Hi Benny,

Are you up for one or two more or shall I post them as new questions?
Community Member Microsoft Employee on at

Like (0)

Report

RE: NAV design reports/templates in word

Fantastic!
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: NAV design reports/templates in word

Hi Jesper

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:
Community Member Microsoft Employee on at

Like (0)

Report

RE: NAV design reports/templates in word

Hi Benny,

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!

Thanks again.
Community Member Microsoft Employee on at

Like (0)

Report

RE: NAV design reports/templates in word

Hi Jesper

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);
Community Member Microsoft Employee on at

Like (0)

Report

RE: NAV design reports/templates in word

Hi Benny,

This is great - thanks it works great! Just one thing - there are too many decimals, how can I change this?
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: NAV design reports/templates in word

Hi Jesper

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.
Community Member Microsoft Employee on at

Like (1)

Report

RE: NAV design reports/templates in word

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: NAV design reports/templates in word

Hi Benny,

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!