Microsoft Dynamics NAV (Archived)

Net price and profit % pr. pcs on orderlines and reports 1304, 1305, 1306, 1307

(0) Share

Report

Posted on by Community Member

This question might need to be divided into 2:

Order lines - I would like to have a column with the "netprice pr. pcs. after discount" and a column with our profit %. Most of the time we have more than 1 pcs. on an orderline, and need to see what the pcs. price is after discount and our profit % on this line.
Reports 1304, 1305, 1306 and 1307 need to have the variable available so we can show the netprice pr. pcs. after discount.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Community Member on at

Like (0)

Report

RE: Net price and profit % pr. pcs on orderlines and reports 1304, 1305, 1306, 1307

This is great - thanks very much Benny - I much apreciate your help.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Net price and profit % pr. pcs on orderlines and reports 1304, 1305, 1306, 1307

One other thing, when you have entered your descriptions in the multilanguage editor remember to press the OK button if not your descriptions will be lost and you will have to start over again.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Net price and profit % pr. pcs on orderlines and reports 1304, 1305, 1306, 1307

Hi Jesper

The labels are defined the same place as the variables, just under "Text Constants" tab:

when you push the button with the 3 dots or press F6 while standing in the column to the right you can define the description in the languages you may need:

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Net price and profit % pr. pcs on orderlines and reports 1304, 1305, 1306, 1307

Thank you Benny - it works great!

Where is it possible to make a label for this column? (NetUnitPrice_Lbl) and where can I change the output text of the labels?

I will see where or how I can take this course, but I think I am near the end of alterrations.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Net price and profit % pr. pcs on orderlines and reports 1304, 1305, 1306, 1307

Hi Jesper

Adding netprice pr. unit in report 1305:

First you create a new variable:

Next you will add the variable as column under the line dataitem:

And last you will add the code to calculate the netprice:

If you have to make a lot of report changes, I can recommend you to take course in RDLC reporting for Dynamics NAV.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Net price and profit % pr. pcs on orderlines and reports 1304, 1305, 1306, 1307

Hi Benny,

Could you walk me through this as you did with the other issue I had. I keep getting faults and it is probably because I don't know how to input the calculation code correctly.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Net price and profit % pr. pcs on orderlines and reports 1304, 1305, 1306, 1307

Hi Jesper

1. You will need a developer license to add these to the order line page, and if you don't have a developer license you will have to talk to your NAV partner and have them make it.

2. In the reports you will have to create a variable "NETUNITPRICE" which you will put in as a column under the "Line" dataitem. The code to calculate the "NETUNITPRICE" should be something like this:

NetUnitPrice := "Line Amount" / Quantity;

Was this reply helpful? Yes No