Excluding Freight when determining available discount

  • Excluding Freight when determining available discount

    Posted by DSC Communities on December 9, 2016 at 9:42 am
    • Peter Stockemer

      Member

      December 9, 2016 at 9:42 AM

      In NAV 2009 R2, is there a way to exclude Freight Dollars that are entered on a PO/Invoice from the calculation of the payment discount?

      On our POs, when invoicing, our users currently enter a G/L line for the appropriate Freight Account.  These dollars should not be included in the discount calculation.

      I know that they can manually put in the discount on the Statistics form in the ‘Vendor Stated Discount’ field with the appropriate Discount dates, but for the amount of transaction volume that we have, this is a large task to do for every invoice.

      Any input is appreciated.

      ——————————
      Peter Stockemer
      IT Project Manager/Systems Analyst
      Champion Home Builders, Inc.
      Troy MI
      ——————————

    • David Wiser

      Member

      December 9, 2016 at 11:11 AM

      Our company had the same issue and solved with a modification.  Standard NAV does not address this easily.  The mod we added included adding a checkbox on the purchase line to indicate whether to allow the payment discount.  Then there was code to remve that line from the payment discount if the box on that line was unchecked.  

      ——————————
      Dave Wiser
      Controller
      Beckwith & Kuffel
      Seattle WA
      ————————————————————————-

    DSC Communities replied 7 years, 5 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Excluding Freight when determining available discount’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!