Sales & Purchase Prices in Microsoft Dynamics NAV 2015
In this video I am going to focus on sales prices and purchase prices. I have been selling the coffee mug and buying the coffee mug over and over again in these videos but I have usually been typing in the sales price and the purchase price, sort of ad hoc.
The customers are getting a little bit tired of me negotiating every single sale so I have decided to set a standard price for the coffee mug and then I have a special relationship with The Canon Group so I want to set up a special price for them. So let me go ahead and show you how that is done.
Go into the Item List
I’m basically here in my Item List and I’m going to browse to my coffee mug.
And I’m going to go straight into the Item Card. Now on the Item Card in the Invoicing Tab I can see I have Unit Cost.
This Unit Cost is calculated based on my purchases of that item so that is a calculated cost I cannot put in a cost here. The Unit Price however is a field there I can input a price and that is sort of the standard price for this item.
Setting the Standard Price
I’m going go ahead and I’m going to set the standard price to be $20 for a coffee cup. It’s a really nice one. Ok, now that is a standard price that goes to all customers.
Setting the Special Price
Now I really would like to have a special price for The Cannon Group. Now how would I do that? Well there is something up here if I go into Navigate > Sales Prices.
So this is a price table for my coffee mug. Here I can set up different parameters and different prices for different customers.
Basically I have an option here called Sales Type where I can select whether I want the price to apply to only one Customer Price Group, All Customers or a Campaign.
I could have, instead of putting a standard price for the item, I could have just put All Customers and given it a price and that would have been the same thing.
In this case I’m just going to specify one customer.
I’m going to look for The Cannon Group.
The Unit of Measure here is Pieces. There is no minimum quantity; I could have put that in here if I wanted them to buy at least something to get a good price. But there is no requirement for that. I’m going to give them $15 and the Start Date and End Date of this is open meaning that there is no period that it only applies to.
So now I’m going to close out and show you how that works on the Sales Order.
Create a New Sales Order
Go to the Sales Order right here.
Create a new one.
Now first I’m going to sell to somebody else than The Cannon Group. Will sell to New Concepts Furniture who are going to offer a free coffee mug with every desk they sell.
I go to the Item, Coffee Mug and I’m going to sell out the BLUE location and put 15. Standard price is $20 and we’re good.
Create another New Sales Order
Now let’s create a new sales order.
This one is going to go to The Cannon Group. And let’s take notice to the price. Coffee Mug, and the price is now $15. We have effectively created a price structure for the Coffee Mug depending on who we are selling it to.
Looking at Purchase Prices
Now if we take a look at the purchases prices, go back to my Items.
Go to my Coffee Mug.
I can take a look at the prices on the purchase side.
And set up for a vendor - a Custom Metals.
That we are going to buy piece, no minimum for $10. That’s a negotiated price.
Create a New Purchase Order
Now I go back, I go to a purchase order. It’s the same concept as the sales.
Create a new purchase order.
This one goes to Custom Metals. The Item is Coffee Mug. Notice the cost comes in at $10.
And that was explaining how the sales prices and purchases prices work in NAV for our dear and beloved Coffee Mug.