Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Is there a way to exclude Freight Charges from sales discounts?

Posted on by 233
GP is calculating the sales discount based on the total invoice amount.   
 
But, freight charges (account 4430 in our system) and graphics charges (accounts 4200 through 4300) are excluded from discounts.  Only carton sales (account 4100) are subject to discount.

Example:
 
4100 Sales-Cartons     $1,000.00
4300 Graphics-Prep    $100.00
4430 Outside Freight  $50.00
 
Total $1,150.00
 
Terms 1% 10/Net 30
 
GP calculated a discount of $1,150 * .01 = $11.50.  but, it should only be $1000*.01 = $10. 
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,024 on at
    Is there a way to exclude Freight Charges from sales discounts?
    Thank you for including the example.  I would call your discount a "Terms Discount" (as opposed to the Trade Discount below the Subtotal on the Sales Transaction Entry window).

    Here is the Payment Terms Setup window where you can select which below-the-subtotal boxes in the Sales Transaction Entry window are included in the discount calculation:


    Here are the fields that the Discount/Freight/Miscellaneous/Tax checkboxes are referring to in the Sales Transaction Entry window:
    [There are similar fields in the Receivables Transaction Entry window.]

    Reminder:  Payment Terms are used for both customer and vendor transactions so be careful to name your Payment Terms ID to match the selections in the window.  
     

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans