Exclude Freight from Payment Discount

jvancleve

Hello,

My client is assigning freight costs as a G/L account line item for Purchase Orders. I need to be able to exclude this cost when Navision calculates Payment Discounts. For example, a vendor grants us a 1% discount if the invoice is paid within 10 days. The PO has $1,000 worth of items and $100 in freight. The discount should be 1% of $1,000, not the total $1,100. This post describes the same situation:
http://www.mibuso.com/forum/viewtopic.p ... t+discount

Is there a way to accomplish this without modifying codeunit 12? I am new to Navision development and hesitant to modify such an important function.

How do Item Charges work and can I exclude them from Payment Discounts? Any advice would be greatly appreciated! We are running NAV 5.0 - North America.

Thanks,
Jamison VanCleve

ara3n

You can go to the vendor ledger and manually change the discount amount, or
you write a processing report that could go through all the vendor ledgers and change discount amounts.

You also have to put that on your invoice that the payment NET 30 at 2% excludes freight.

I would suggest to ask your NSC to make the change.