Open Forum

Expand all | Collapse all

Multiple Price for Same Item & Customer/Variant Code?

  • 1.  Multiple Price for Same Item & Customer/Variant Code?

    TOP CONTRIBUTOR
    Posted Oct 04, 2019 09:13 AM
    Hello,

    We are currently using NAV 2015.

    Over the last few months, we brought on a new customer with multiple plants.  Our typical process is to set up one customer with multiple ship to codes.  Our customer usually makes payment for all plants on one payment.

    We sell product to each plant and have found we sell the same item to multiple plants at different prices based on our agreement.

    We currently use the sales prices tab from the item card to identify customer specific pricing.  With the situation above, our current process does not allow us to have multiple prices for the same item and customer.

    How do other companies with similar situations handle the set up?  Do you use variant codes?  What are the positive and negative aspects of variant codes?  Or what ultimately made you decide to use them or not use them?

    Thank you for your feedback!

    ------------------------------
    Kristina Frank
    Controller
    Cline Tool & Services
    Newton IA
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Multiple Price for Same Item & Customer/Variant Code?

    Posted Oct 04, 2019 10:44 AM
    Kristina

    You could look at the Parent/Child relationship by using the "Bill To" on the customer card. This enables you to have different pricing schemes for each Child Customer, yet still applying the A/R to the Parent Customer. The individual Child Customers will not have an A/R.

    Something to think about.

    Good Luck!

    ------------------------------
    Alfredo Zelaya
    Sr. Systems Analyst
    Megadyne Americas LLC
    Fairfield NJ
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Multiple Price for Same Item & Customer/Variant Code?

    TOP CONTRIBUTOR
    Posted Oct 07, 2019 07:24 AM
    This one is tricky.  A have heard several ideas about how to address this.  One is to create logic that applies a dimension based on the ship-to OR even to add logic that allows the ship-to address to be included in the logic for OOB pricing.  This means instead of pointing to a specific customer for special pricing, you would have to create logic that points to the ship-to's.  All of this requires code.  It will be interesting to see if anyone has addressed this OOB.

    Please share what you implement.  Thank you.

    ------------------------------
    Jason Nicolaou
    Engagement Manager
    Sikich, LLP
    ------------------------------

    Conference-BCNAVUG_200x200


  • 4.  RE: Multiple Price for Same Item & Customer/Variant Code?

    GOLD CONTRIBUTOR
    Posted Oct 07, 2019 07:55 AM
    Are the prices different by ship-to because the prices are different, or are they different because of things like freight?

    ------------------------------
    Kyle Hardin
    NAV Developer
    ArcherPoint Inc.
    Duluth GA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 5.  RE: Multiple Price for Same Item & Customer/Variant Code?

    TOP CONTRIBUTOR
    Posted Oct 07, 2019 10:10 AM
    Hi @Kyle Hardin,

    The prices are different based on our agreement with the customer.  Our cost from the vendor is the same, only the price we charge the customer is different.  Freight is charged on our customer's freight account so this does not play into our pricing.

    Thank you,​

    ------------------------------
    Kristina Frank
    Controller
    Cline Tool & Services
    Newton IA
    ------------------------------

    Conference-BCNAVUG_200x200


  • 6.  RE: Multiple Price for Same Item & Customer/Variant Code?

    SILVER CONTRIBUTOR
    Posted Oct 07, 2019 10:21 AM
    Hello @Kristina Frank!

    Due to some changes with our company, we had to create a new customer per ship-to. Previously, we were able to have numerous ship-to's so long as the bill-to was the same.

    The only reason I bring that up is that we ALSO utilize the customer price group function within Nav (we are on 2016). We currently have 5 price groups, dependent on the discount or mark-up required. We did need to create a price group called ALLCUST, otherwise we had issues with the EXPORT group. This may be something to consider, as you can do a quick import for the sales price groups with the configuration package. Additionally, you can mark the customer as a certain group within the invoicing tab on the customer card.

    If you want to keep the customer as-is and not create new customer cards, you could add the price group at the sales order in the invoicing tab BEFORE adding any items.

    Let me know if you have any questions. :)​

    ------------------------------
    Taylor Boardman
    Materials Coordinator
    Motan Inc
    Plainwell MI
    ------------------------------

    Conference-BCNAVUG_200x200


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