Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Vendor settlement discount terms net of freight and tax

(0) ShareShare
ReportReport
Posted on by

Our vendors generally allow a settlement (payment) discount for the invoice amount net of freight and tax, if paid within the discount terms. Our current solution is to enter an invoice in two parts, one payable invoice for the materials (which can be discounted), and another payable invoice for the amount of freight and tax (which cannot be discounted). This duplicate entry is inefficient. Since the freight can vary from shipment to shipment, we cannot precalculate a discount percentage that, when applied to the whole invoice, would result in the correct discount for just the materials. If there was a way to override the terms discount amount at AP entry, this would prevent us from having to enter every invoice twice. 

Any suggestions would be appreciated.

*This post is locked for comments

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 997 Moderator on at
    RE: Vendor settlement discount terms net of freight and tax

    Maybe you can contact the companies behind some of these apps on app source and check if they have this functionality:

    appsource.microsoft.com/.../PUBID.thetasystemslimited|AID.advanced_landed_cost|PAPPID.8ebdc541-0ea9-415e-9532-b25b8ebdc541

    appsource.microsoft.com/.../PUBID.k3businesstechnologygroup|AID.k3_landed_cost|PAPPID.b470c09e-b96e-4383-91d5-6fdaf8ccd75b

    appsource.microsoft.com/.../PUBID.tecman|AID.clever-landed-costs|PAPPID.7ff61b2b-2255-4542-a4b3-adda0aba69ff

    I have not used any of them but they kind of have solutions around the area of costing of goods.

  • TeeJ Profile Picture
    TeeJ 5 on at
    RE: Vendor settlement discount terms net of freight and tax

    Great question, we are curious this same!  We use Dynamics 365 V16 and cannot take a discount on the material without freight.  Hopefully someone has any possible solutions?

    thansk!

  • RE: Vendor settlement discount terms net of freight and tax

    No, this is in the US. It wasn't "tax on freight," it was "tax and freight." Our payables invoices have materials, freight and tax on them, but the settlement discount can only be taken on the materials portion. The automatic settlement discount calculation takes the total invoice into account, when we want it to calculate on the subtotal before tax and freight. Alternatively, the ability to manually override the calculation and enter a specific payment discount amount would be fine. However, there is no apparent field to enter a settlement discount amount.

  • Ari Profile Picture
    Ari 259 on at
    RE: Vendor settlement discount terms net of freight and tax

    Hello,

    Can I assume that since you are referring to tax on freight that your company and freight movements are Canadian? If this is the case, there is a TMS solution for NAV 2015 can "split" out the A/P transactions between product cost and freight. On the product cost you can take a discount on payment terms and the normal A/P freight spend will include a calculation of QST and PST etc. that you can pay after the freight bill is audited.

    - Ari Smith

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans