Dynamics 365 Managing Sales and Purchase Pricing

Friday, November 1, 2019

1 There are number of ways to set pricing for a item. In this tutorial we are use the simplest method. We are going to set a simple sales and purchase price for an items at product level. The first step click the menu on the right hand side  

Step 1 image

2 When the menu opens click on the modules section. In the list which expands click on the Product information management menu option

Step 2 image

3 The product management workspace is now displayed. In this screen we are navigating to the products sections and we will click the Released products menu option

Step 3 image

4 This screen displays all the released products in the system. Lets look at item 1000. Click on the Item number column to open the product screen

Step 4 image

5 In the product screen which is open  there are a number of sections. We are interested in Sales and purchase sections. Review the price in the purchase section. Scroll down and review Price 

Step 5 image

6 Now scroll down to the sales section. Under based sales prices 10 dollars is displayed. I know it's dollars at the default current for the supplier is dollars

Step 6 image

7 Now lets change the pricing. Scroll up to the top of the page and click the edit button on the blue menu bar. This will open the product for editing

Step 7 image

8 Navigate back to the purchase section and enter a price

Step 8 image

9 In this section we enter a base purchase price for the item. When we create a purchase order and add this item as purchase line. This is the base price of the item which we will purchase the item for.

Step 9 image

10 Next scroll down enter a base sales price.

Step 10 image

11 In the base sales prices I am going to enter 1000. This means than when we create a sales order this is the cost of the item to the customer. 

Step 11 image

12 Now we have finished entering our pricing lets save our sales order. Click Save or use the hotkeys (Alt+S) to save our product and it's new pricing

Step 12 image

13 Click Close or (Esc) to exit the product screen

Step 13 image

14 Now lets test create a sales order to test our changes in a sales order. Let click the menu on the right hand side again and choose the Accounts receivable workspace

Step 14 image

15 We are not in the account receivable work space. Click All sales orders menu option under the orders menu

Step 15 image

16 This screen displays the list of sales orders. Click New, (Alt+N) to create a new sales order 

Step 16 image

17 In the panel which opens on the left select a customer account, ideally for this example lets pick a US customer. I've picked US-001, once this is selected Click OK, (Alt+Enter) to create a new sales order 

Step 17 image

18 Now the sales order screen is displayed lets enter our product in the sales order lines below 

Step 18 image

19 In the Item Number cell, click no the item header to search for the Item number which we have changed. In this case the item is 1000 as per the previous steps. Select the item in search results

Step 19 image

20 Now the item has been added to the sale order. Scroll right and check the Unit price. It is now displaying the 1,000 USD which we have entered for the sales price of the item. 

Step 20 image

21 Click highlight

Step 21 image

22 Click Save or (Alt+S) to save our sales order. Now lets investigate where our sales price has come from.

Step 22 image

23 When a line has been highlighed in the sales order lines, click the Financials menu on the top of the grid. This opens a financials sub menu 

Step 23 image

24 In the drop down menu click on the Find prices options , this will open the pricing screen

Step 24 image

25 On this screen we can review the Sales price and where it has come from. We can see that the price has come from a value on the product information and not a trade agreement 

Step 25 image

26 We can also see the purchase price.

That's all from creating simple prices on the item card.

Step 26 image