Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Discount Amount

Posted on by 305

Hi friends,

i need to add a discount for particular customer, i have added the discount percentage in header level(Cash Discount), when put the sales line for particular customer i want add that discount percentage to all sales line , unit price Excl i need to write a code for discount after that i can get the discounted Amount in  line Amount Excl Tax please give any suggestion.

current-error.png

Thank you

*This post is locked for comments

  • Prabakaran.R Profile Picture
    Prabakaran.R 305 on at
    RE: Discount Amount

    Hi Alexander

    Thank you for reply i  want to create a discount for particular customer not to all customer but  customer discount group i can nt create a discount for 1 customer, please give any  suggestions to achieve this.

    Thank You

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Discount Amount

    I did not get why can't you use standard Customer (or Group of Customers) discount, applied only for specific customers? See here: Calculating Invoice Discounts on Sales msdn.microsoft.com/.../jj552507(v=nav.90).aspx and here: msdn.microsoft.com/.../hh178959(v=nav.90).aspx

  • Prabakaran.R Profile Picture
    Prabakaran.R 305 on at
    RE: Discount Amount

    Hi mahana

    Thank you reply

    i have added this code on unit price  even though my cash discount is not calculated

    "Cash Discount%" :=

    ROUND(ROUND(Quantity * "Unit Price",Currency."Amount Rounding Precision") * "Line Discount %" / 100,
    Currency."Amount Rounding Precision")

    "Inv. Discount Amount" := 0;

    "Inv. Disc. Amount to Invoice" := 0;

    please help me on this one.

    Thank you

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Discount Amount

    ok. so you are going to add extra discount for some customers and you have setup for that.

    then you need to identify code where ever line discount is calculated and add your extra cash discount calculation to it.

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Discount Amount

    you can give line discounts to particular customers also and not all customers.. is this what you mean or different?

    line-disc.PNG

  • Prabakaran.R Profile Picture
    Prabakaran.R 305 on at
    RE: Discount Amount

    Hi Mohana

    This cash discount i have taken from customer master who are customer having cash discount that customer will get (cash Discount%  and Line Discount%) other customer will have only Line discount%, so need write a code at unit excl  price for cash discount mam please suggest me to do this.

    Thank You in advance

  • Prabakaran.R Profile Picture
    Prabakaran.R 305 on at
    RE: Discount Amount

    Hi Mohana

    thank you for reply i want add a cash Discount for particular customer not all customer frequent customer i will give some discount (cash discount) i want to add that cash discount  before line discount apply for only few customer only but line discount will apply for all customer please give any suggestion to solve this issue.

    Thank You

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Discount Amount

    isnt it working if you validate line discount % with cash discount %?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans