Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Vendor Settlement Discount

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Mohana Yadav Profile Picture
    Mohana Yadav 60,050 Super User 2024 Season 2 on at
    RE: Vendor Settlement Discount

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee 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
    Jens Glathe 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
    Corina Soare 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
    Mohana Yadav 60,050 Super User 2024 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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans