Line Amount -Discount

IoannaK
IoannaK Member Posts: 14
edited 2006-11-09 in NAV/Navision Classic Client
Hi to all members of the forum!

Is it possible to create a field in the invoice report that will represent the net amount of the item before having the discount?
Let's say:
quantity:1
unit price:100
line amount before discount:100
discount:10%
line amount:90

I will appreciate your help.
Thanks :D

Answers

  • Waldo
    Waldo Member Posts: 3,412
    You could always create a text box with the following in the SourceExpr-property:
    "Sales Line".Quantity * "Sales Line"."Unit Price"

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • IoannaK
    IoannaK Member Posts: 14
    I would never imagine that it was so simple!
    Thanks a lot! :D
  • Waldo
    Waldo Member Posts: 3,412
    C/SIDE is all about simplicity. \:D/

    Glad to be able to help.

    Can you put [Solved] in the title?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • IoannaK
    IoannaK Member Posts: 14
    OK done!
    If it's so simple I will be able to give it a glance!
  • Savatage
    Savatage Member Posts: 7,142
    also,

    "Amount Including Tax" + "Line Discount Amount"
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org

Categories