Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Kristina Frank]

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
——————————

[Alfredo Zelaya]

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
——————————
——————————————-

[Jason Nicolaou]

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
——————————
——————————————-

[Kyle Hardin]

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
——————————
——————————————-

[Kristina Frank]

Hi ,

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
——————————
——————————————-

[Taylor Boardman]

Hello !

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
——————————
——————————————-