You are here

Creating Base Prices

Creating Base Prices

Concept

When you create a base price, the system requires you to complete these fields:

 

Item Number or Item Group and Customer Number or Customer Group: The system requires item or item group number and customer or customer group number based on the preference hierarchy selection.

 

Adjust Prices by Selection: You can enter a unit price or a credit price when creating base prices. For base pricing, the system does not enable you to create adjustments by percentage or amount.

 

Branch/Plant, Location, and Lot Number: The system requires the branch/plant, location, and lot number depending on the setting in the Sales Price Level field in the Item Master Revisions form.

 

Currency Code: You must set up the base price for each currency that you use with the item.

 

Effective Dates: You must specify the effective from and through dates for each base price that you enter. Effective dates are the start and end dates for the base price. If you do not enter the effective from and through dates, the system populates the effective from date with the date on which the base price was entered. The system provides the effective through date from the last system date.

 

Unit of Measure (UOM): The system searches for base prices based on the unit of measure that is set up in the system constants in the Sales Price Retrieval UOM field. The options for the Sales Price Retrieval UOM field are:

• Blank: Primary UOM

• 1: Transaction UOM

• 2: Pricing UOM

• 3: Sales UOM Seq. and Primary

• 4: Sales UOM Seq. and Transaction

• 5: Sale UOM Seq. and Pricing

• 6: Secondary UOM

 

You define the sales unit of measure sequence in the Item Unit of Measure Conversions program (P41002). The sequence enables the system to search over multiple units of measure and perform the conversion to another unit of measure for pricing.

 

You can copy base prices from one item or item group to another. The system duplicates the pricing information but does not duplicate the item number or item group information. The system does duplicate the customer and customer group information when copying records based on item or item group.

 

Two ways to copy base prices exist:

• From one item to another using the Copy button on the Work with Preference Base Price form.

• Within an item for different characteristics using the Copy selection on the Row menu on the Base Price Revisions form.

 

Prerequisites

Before you begin this task, verify that you have set up:

• Customer price groups in user-defined code (UDC) table 40/PC

• Item price groups in UDC 40/PI

• Price hierarchy 51

Procedure

In this task, you will set up pricing for an item and customer group.

Step Action
Navigate to the Base Price Revisions program (P4106) on the Price Management menu (G4222).

Click the Price Management link.

Click the Base Price Revisions link.

Use the Work With Preference Base Price form to review existing prices for an item.

Step Action
Click the Add button.

Use the Preference Hierarchy Selection form to select the price category. The system displays selections based on the hierarchy search sequence.

Step Action
Click the Item and Customer Group option.

Click the Select button.

Use the Base Price Revisions form to create or update pricing for an item.

Step Action
Click in the Item Number field.

Use the Item Number field to identify the item for which you are adding pricing information.

 

Enter the desired information into the Item Number field. Enter “210“.

Click in the Cust. Price Group field.

Use the Cust Price Group field to identify the value from UDC 40/PC for which you are adding pricing information.

Enter the desired information into the Cust. Price Group field. Enter “WHOLE“.

Click in the Branch/ Plant field.

Use the Branch/Plant field to specify the business unit in which the price is effective.

Enter the desired information into the Branch/ Plant field. Enter “30“.

Click in the UM field.

Use the UM (Unit of Measure) field to specify the unit of measure for the price. You can set up different prices for each unit of measure that you use for an item.

Enter the desired information into the UM field. Enter “EA“.

Click in the Cur Cod field.

Use the Cur Cod (Currency Code) field to specify the currency for the price. You can set up different prices for each currency in which you sell the item.

Enter the desired information into the Cur Cod field. Enter “USD“.

Click in the Unit Price field.

Use the Unit Price field to specify the price for the item. When you enter a sales order, the system applies the price if all criteria match.

Enter the desired information into the Unit Price field. Enter “715“.

Click the OK button.

Click the Cancel button.

Step Action
Click the Close button.

Step Action
Click in the Item Number field.

Enter the desired information into the Item Number field. Enter “210“.
Click in the Cust. Price Group field.

Enter the desired information into the Cust. Price Group field. Enter “WHOLE“.
Click the Find button.

Step Action
Click the Horizontal scroll bar

You did not specify effective dates when you added the price record. The system populates the Eff Date From field with the current system date and the Eff Date Thru field with the last date that was set up in the system.

Step Action
Click the Close button.

You have successfully added price information for an item number and customer group combination.

End of Procedure.

Ayman Refat
Over 20 years of experience in IT area, working as Oracle JD Edwards Developer with expertise in Windows Server, SQL Server and Microsoft Exchange Server, experience in Linux operating systems (Debian and Redhat), VMWare ESX / ESXi, Novell Netware, relational databases like Oracle 10/11g and backup solutions from Computer Associates. Large experience in high-end servers from Dell and HP, having the following certifications: Microsoft: MCP, MCSE, MCDBA, MCSA and MCT (2008 ~ 2013), Computer Associates: Technical Specialist – Storage and Backup Solutions,
http://www.AymanRefat.com

Leave a Reply

Top