Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Early Payment Purchases Discount for AP

  • 1.  Early Payment Purchases Discount for AP

    Posted 09-21-2015 03:51 PM

    Does anyone know of a set up within AP that would only calculate discounts for merchandise? With our current set up, it is taking AP purchase discounts on the entire invoice, including freight, handling, tax, etc. Our vendors only allow us to take early pay purchases discounts on line items/merchandise. Has anyone had any luck in dealing with this? Thanks!

    ------------------------------
    Heidi Box
    Accounting Supervisor
    John Henry Foster
    Saint Louis MO
    ------------------------------



  • 2.  RE: Early Payment Purchases Discount for AP

    Posted 09-21-2015 04:54 PM

    Hey Heidi,

    How are you controlling the discounts?  Are the existing ones total discounts?  You should be able to create product-specific discounts that would allow you to calculate discounts on a product by product basis.

    -Jake

    ------------------------------
    Jacob Roder
    Sr. Solution Consultant
    Dynamic Consulting
    Chicago IL
    ------------------------------




  • 3.  RE: Early Payment Purchases Discount for AP

    Posted 09-21-2015 06:09 PM

    This is only for early pay discounts on the accounts payable side. So all products for specific vendors, but not the entire invoice. And then, of course, if we don't pay on time, we don't get the discount, so I can't run it by product. For example we get 2% net 10 for a certain vendor, but they only allow us the discount on items, not on items plus freight. Currently AX is taking 2% off the TOTAL of the invoice (items plus freight), not the SUBTOTAL (just items).

    ------------------------------
    Heidi Box
    Accounting Supervisor
    John Henry Foster
    Saint Louis MO
    ------------------------------



  • 4.  RE: Early Payment Purchases Discount for AP

    TOP CONTRIBUTOR
    Posted 09-24-2015 11:55 AM

    I don't think the functionality you need comes out of the box.

    As you noted yourself, the discount is taken in the accounts payable sub ledger, at the time of payment where there is no longer a direct and simple link to the original  purchase order, and the different items contributing to the amount.

    From the top of my head  (and in a slightly irresponsible way, but hey, it's free advice), I can envision a fairly simple customization that will get you what you need.

    1. Add a new field to the vendor transaction table ("VendTrans") titled "amount eligible to cash discount"

    2. When the purchase is order is posting, add code to populate this field with the total of the PO lines eligible for cash discount.

    3. Modify the cash discount functionality to look at that field rather than the "invoice total" field when performing the calculation of how much cash discount can be taken.

    ------------------------------
    Zvika Rimalt
    Business Analyst
    ZR Technology Consulting
    Vancouver BC
    ------------------------------




  • 5.  RE: Early Payment Purchases Discount for AP

    Posted 17 days ago
    I am faced with the same issue. Is there a way to mark the item at the released products or product level so the PO could read that a certain line item is not eligible for discount? We have multiple companies on our system who share the same part numbers for freight and would like to find a way to make this happen automatically.

    ------------------------------
    Beth Jones
    P2P Systems Analyst
    Leggett & Platt
    Carthage, MO
    ------------------------------