Notifications
Announcements
No record found.
Can you setup customer pricing by ship to location?
*This post is locked for comments
If you mean different price per each delivery address for a customer, I do not think you could do that.
We have solved this problem by handling each customer delivery address as a different customer account, and have created relationship between them. We have used the idea of the Organizational hierarchies and customized it for our needs: technet.microsoft.com/.../hh209258.aspx
Each customer has a top level account, like a hotel chain. Then the 2nd tier customer account is tied to the delivery address, which means there are hotels for the same chain but in different locations/cities/countries whatsoever. This way you could set up individual prices for each hotel, and set the invoice account as the 1st tier customer (hotel chain's headquarters) if you want to see payments in a central place for example. We have additional 3rd and 4th level tiers like if there is a separate buffet, bar, pool or whatsoever account within a hotel that needs to track their expenses and purchases separately, but that is not relevant for your situation.
So the bottomline is, with a bit of customization to create a customer hieararchy per delivery address, you could achieve the required price structure.
Hi Vilmos,
thread got bit of my interest.
how you guys are managing billing? do you guys send invoices to single invoice account or it depends upon customer how they want?
and how you deal with situations like customer account statement. lets suppose I need to send external account statement to a customer who has got 10 hotels in different location. now as per solution if I have 10 customer account for this customer and on other end customer asks me a single account statement? did it required you to do more development with such things as combined reporting?
Hi nmirhan,
You could if each location was a customer account (an order account) which share the same invoice account.
Sohaib, it depends for each account how they want to do it.
The reason is quite obvious for the need of setting prices per delivery address for a distribution company, because you have to factor in road access fees and highway tolls, fuel prices, congestion charge within London, how easily can you access that area, or if it is in a High street sector.
We can mark a "default" one. That means if a restaurant closes down at one address, and opens up at another location we verify if the business owner has changed, and create a new 2nd tier account for that address/business and mark it as default, and deactivate the other customer account. Orders and invoices will be raised for the only account that is active on the 2nd tier, and usually that is the default one.
If it is a hotel so they have multiple addresses, they could decide for central billing in which case we just set the invoice account to be the hotel chain on tier 2/3, or if it is a 3rd tier entry and charge only per hotel address then the orders are raised for the pool/bar/restaurant etc. but their invoice account is set as the 2nd tier account. That way they pay the bills collectively, but they have a breakdown of who consumed how much at that address.
Of course this adds a bit of complications like how to handle their credit limit and a couple of other areas, but it works excellent for these type of B2B wholesale distribution scenarios due to the upside of many other areas like setting the prices. Customer account statement is straightforward due to the use of invoice accounts since you immediately see who is the parent.
Payment terms and method of payment also plays a role depending on how you trust your customer, some have advance payment, some do it monthly, some are ok with cash up front, and we also process credit and debit cards online and onsite too.
To keep to one customer code then you have to find a way to either adding a service cost collector or to modify each line price. for example a location specific variant and price but I would not go that way
You can look at applying a location specific misc charge.
You can also look at setting up a maximum price in a trade agreement, then apply a different discount to it to each order,/order line based on a unique, location specific salesman who processes the order for that site. there other variations on the same theme.
You also need to consider how the customer will view different charges for the same item, and whether you have different delivery addresses within the same order for different lines.
It might be simpler to charge the extra as an additional service cost line. Set up a service item with a price of 1 and then make the qty as many units as you need to get the desired price surcharge. Its then a cogs for the customer, but not for each item - but maybe that makes more sense anyway.
Thank you all for the responses. We end up creating new customer accounts for each location and assign one invoice account.
Great. Make sure you mark all helpful answers next to each post to resolve the topic.
Thank you vilmous for your input.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
