Automatic Price Selection: To Explore Warehouse-Specific Prices

In this activity, you will learn how to configure sales prices for a particular warehouse.

Attention: This activity is based on the U100 dataset. If you are using another dataset, or if any system settings have been changed in U100, these changes can affect the workflow of the activity and the results of the processing. To avoid any issues, restore the U100 dataset to its initial state.

Story

Suppose that the sales manager of the SweetLife company decided that on 01/30/2023, the company will start selling one of its products (a 96-ounce jar of lemon jam, defined in the system as LEMJAM96 from the WholesaleWarehouse (WHOLESALE) at special prices.

Acting as a SweetLife accountant, you need to configure the sales price of the LEMJAM96 stock item for this particular warehouse effective on the specified date. You also need to record the sale of 10 jars of lemon jam, 5 of which are sold from the Wholesale warehouse.

Configuration Overview

In the U100 dataset, the following tasks have been performed for the purposes of this activity:

On the Warehouses (IN204000) form, the WHOLESALE and RETAIL warehouses have been created.
On the Stock Items (IN202500) form, the LEMJAM96 stock item has been created
On the Units of Measure (CS203100) form, the PIECE units of measure has been created.
On the Customer Price Classes (AR208000) form, the LOCAL customer price class has been created.
On the Customers (AR303000) form, the GOODFOOD customer has been created and assigned to the LOCAL customer price class.

Process Overview

On the Sales Prices (AR202000) form, you will view sales prices configured for a particular warehouse. By using the same form, you will configure a sales price of a particular item from a particular warehouse (that is, a warehouse-specific sales price).

To test this configuration, you will create a sales order on the Sales Orders (SO301000) form, add lines to it (at least one for the item being sold from the particular warehouse for which you have added the sales price, and at least one for the item at another warehouse), and review the sales prices the system uses for these lines.

System Preparation

To prepare the system, do the following:

Launch the MYOB Advanced website with the U100 dataset preloaded, and sign in as an accountant by using the following credentials:
- Username: johnson
- Password: 123
In the info area, in the upper-right corner of the top pane of the MYOB Advanced screen, make sure that the business date in your system is set to 1/30/2023. If a different date is displayed, click the Business Date menu button and select 1/30/2023. For simplicity, in this lesson, you will create and process all documents in the system on this business date.
On the Company and Branch Selection menu, also on the top pane of the MYOB Advanced screen, make sure that the SweetLife Head Office and Wholesale Center branch is selected. If it is not selected, click the Company and Branch Selection menu button to view the list of branches that you have access to, and then click SweetLife Head Office and Wholesale Center.

Step 1: Viewing Sales Prices for a Particular Warehouse

To view the sales prices configured for the WHOLESALE warehouse, do the following:

Open the Sales Prices (AR202000) form.
In the Warehouse box of the Selection area, select WHOLESALE.
Notice that the table shows no records, because no sales prices that are specific to this warehouse have been configured in the system.

Step 2: Defining a Sales Price of a Particular Item at the Wholesale Warehouse

To create a sales price for the LEMJAM96 stock item at the Wholesale Warehouse, do the following:

On the Sales Prices (AR202000) form, click Add Row on the table toolbar, and specify the following settings in the added row:
- Price Type: Base
- Inventory ID: LEMJAM96
- UOM: PIECE
- Warehouse: WHOLESALE
- Price: 43
- Effective Date: 1/30/2023
On the form toolbar, click Save.
In the Inventory ID box of the Selection area, select LEMJAM96, clear the value in the Warehouse box, and review the prices that are defined in the system for the LEMJAM96 item.

Now in the Price column, two prices are shown: the LEMJAM96 price (for which the warehouse is not specified) in the amount of $49.49, and the LEMJAM96 price (for which the WHOLESALE warehouse is specified) in the amount of $43.00.

Step 3: Creating a Sales Order

To make sure the system is inserting a different price for the item when it is sold from the WHOLESALE warehouse than when it is sold from another warehouse, you will create a sales order with two lines from different warehouses. Do the following:

Open the Sales Orders (SO301000) form.
On the form toolbar, click Add New Record, and specify the following settings in the Summary area:
- Order Type: SO
- Customer: GOODFOOD
- Date: 1/30/2023
- Description: Lemon jam 96 oz.
On the table toolbar of the Details tab, click Add Row, and specify the following settings for the first order line:
- Branch: HEADOFFICE
- Inventory ID: LEMJAM96
- Warehouse: WHOLESALE
- UOM: PIECE
- Quantity: 5
Notice the value in the Unit Price column. Because you specified the WHOLESALE warehouse, the system has inserted the unit price ($43) that you have specified for this warehouse in Step 2.
Figure 1. Unit price updated on the basis of the warehouse-specific price of the LEMJAM96 stock item
On the table toolbar of the Details tab, click Add Row, and specify the following settings for the second order line:
- Branch: HEADOFFICE
- Inventory ID: LEMJAM96
- Warehouse: RETAIL
- UOM: PIECE
- Quantity: 5
Notice the value in the Unit Price column, which is shown in the following screenshot. Because no sales price has been specified for this stock item specific to the RETAIL warehouse, the system has inserted the base price for this stock item ($49.49).
Figure 2. Base price and warehouse-specific price of the LEMJAM96 stock item
On the form toolbar, click Save to save the sales order.