Open Forum

Expand all | Collapse all

INV PO Purchase Price Discount Setup

  • 1.  INV PO Purchase Price Discount Setup

    Posted Aug 11, 2021 12:58 PM
    Our purchasing team is wondering if there's a way to setup layered purchase prices in GP for an item.  They're negotiating bulk purchase discounts and would like to setup and pull that into GP vs going to a spreadsheet to look up and manually change the price with every PO that's created.  Ex: $10 each or $8 each for 100-500 ordered or $5 for 500-1000 ordered, etc.

    We don't use any add-on products for purchasing and we're on GP2015.  If this isn't doable in GP, do you have a recommendation for a product that can accommodate this?  Thanks!

    ------------------------------
    Kristy James
    Financial Controller
    Dairyland Electrical Industries, Inc
    Stoughton
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: INV PO Purchase Price Discount Setup

    TOP CONTRIBUTOR
    Posted Aug 11, 2021 07:23 PM
    We used to do it inside GP using the Item Pricing capabilities of IV/SOP by setting up a Price List called ZPURCH and then maintaining all the associated price/cost breaks for EACH, CASE, PALLET, TRUCK and quantities for the Items.

    With a little VBA code on the PO Entry window, we would fetch the UNITCOST from the IV00108 table for the appropriate ZPURCH, UOFM and Quantity (if exists) and use that price/cost for the PO Line else default normal GP costs

    Now because effective dates for prices are so valuable to set up for hundreds of items in advance and VBA is going bye bye, the old way is less desirable so now I would look at the Vendor Price Management Enhancement from dynavistics.  There are a coupe people who are very good at it if you need a referral.

    https://www.dynavistics.com/vendor-price-management-enhancement-for-dynamics-gp


    ------------------------------
    Thaddeus Suter
    Retus, Inc
    HELOTES TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: INV PO Purchase Price Discount Setup

    Posted Aug 12, 2021 10:27 AM
    Thanks for the recommendation Thaddeus!

    ------------------------------
    Kristy James
    Financial Controller
    Dairyland Electrical Industries, Inc
    Stoughton
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: INV PO Purchase Price Discount Setup

    GOLD CONTRIBUTOR
    Posted Aug 12, 2021 06:57 AM
    Kristy,
    I would also look at Willoware Vendor pricing module
    MFG PowerPack Vendor Pricing (willoware.com)

    ------------------------------
    Andrew Kennedy
    Principal Consultant
    Velosio
    Seven Hills OH
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: INV PO Purchase Price Discount Setup

    Posted Aug 12, 2021 10:28 AM
    Thanks for the recommendation Andrew!

    ------------------------------
    Kristy James
    Financial Controller
    Dairyland Electrical Industries, Inc
    Stoughton
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role