NAV design reports/templates in word

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (11)

Answers (2)

Community Member on at

Like (0)

Report

Hi Jesper

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;

END;

This mean you will have to create the variables and put them in the report yourself.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Benny,

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

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:

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Fantastic!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Benny,

Are you up for one or two more or shall I post them as new questions?

Was this reply helpful? Yes No