web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Vendor Settlement Discount

(0) ShareShare
ReportReport
Posted on by

Hi - hope someone can help.

 

I have a new customer who wants settlement discount for a Vendor to be taken against the Net amount of the Invoice not the Gross amount. They do not want the VAT to be discounted.

 

Scenario:-

Invoice received for a Nett amount of £1000, VAT is standard 20% = £1200 Gross

Settlement discount applied to payment terms is 3%.

In the General Ledger Setup, i have unticked Payment Disc Excl VAT and I have ticked Adjust for Payment Discount. In the testing I have been doing the invoice posts:-

Net - 1000.00

VAT - 200.00

Gross - 1200.00

 

When invoice is paid within terms, discount available is calculated at 3% of £1200 = £36.00, therefore paying £1164.00.

My customer is expecting it to calculate 3% of the Net amount, therefore £30 discount, paying £1170.00

Are there any other options I can test?

 

Thank you

*This post is locked for comments

I have the same question (0)
  • Mohana Yadav Profile Picture
    60,604 Super User 2025 Season 2 on at
    RE: Vendor Settlement Discount

    hi, if your question is answered, please verify. thx.

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Vendor Settlement Discount

    Hi..

    I think this can be set in 'Structure' setup.

    Take a look by creating new tax structure.

    Code

    Calculation Order

    Type

    Tax/Charge Group

    Tax/Charge Code

    Calculation Type

    Calculation Value

    CVD

    CVD Payable to Third Party

    CVD Third Party Code

    Quantity Per

    Base Formula

    Include Base

    Include Line Discount

    Include Invoice Discount

    Check the bolded area..

    Something may work

  • Suggested answer
    Jens Glathe Profile Picture
    6,092 on at
    RE: Vendor Settlement Discount

    Hi Julie,

    when the flag is set and the customer pays a new invoice, what is the payment discount possible in the customer/vendor ledger entry? Apparently the payment discount possible is one thing that is calculated differently (at posting time) when using this option. It also means that entries posted before setting this flag will have a too high payment discount possible when you want to pay it. The VAT correction on application will be off, though.

    The easiest way to correct it would be to run a batch over all open entries and recalculate payment discount possible after setting the flag.

    with best regards

    Jens

  • Suggested answer
    Corina Soare Profile Picture
    585 on at
    RE: Vendor Settlement Discount

    Hi Julie,

    You can go to GL Setup and check the Pmt. Disc. Excl. VAT check box.

    If you need more information, press F1 to access the help page for this function.

    Hope this helps! :)

  • Verified answer
    Mohana Yadav Profile Picture
    60,604 Super User 2025 Season 2 on at
    RE: Vendor Settlement Discount

    But the help says you have to tick Payment Disc Excl VAT.

    msdn.microsoft.com/.../Hh170578(v=nav.71).aspx

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans