News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP forum Is there a way to excl...

Microsoft Dynamics GP forum

Suggested answer

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

(0) Share

Report

Report

Posted on by PattiK323

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.

Categories:

Administration and Setup

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Lisa at AonC.com 3,024 on at

Like (0)

Report

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.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 228,683 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans