11. Item Pricing

Item Pricing section.

11.1.  Item List Price

To create or modify the List Price for an Item, select the "Item List Price" option. The following screen will appear:

Item List Price

Note

List Prices may also be created or modified in the Item master for an Item. Changes made to an Item's List Price in either location will be reflected application-wide.

When creating an Item List Price, you are presented with the following options:

Item Number

Enter the Item Number of the Item you want to create or modify a List Price for.

UOM

Inventory Unit of Measure.

List Price

Enter the List Price for the specified Item.

Price UOM

Displays the Price UOM for the specified Item.

Inv./Price Ratio

Displays the ratio between the Price and Inventory Units of Measure for the specified Item.

Inventory UOM Price

Displays the Inventory Unit of Measure Price for the Item.

Cost

Displays Standard Cost and Actual Cost for the specified Item.

Extended Cost

Displays the extended Standard Cost and extended Actual Cost for the Item. The extended Cost is equal to the List Price multiplied by the Price/Inventory UOM ratio. If the Price/Inv. Ratio = 1, then the Cost and Extended Cost will be the same.

Margin

Displays the profit margin. The margin is determined by the following formula: Price - Cost / Price.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen, returning you to the previous screen.

SAVE

Creates the Item List Price.

11.2.  Update List Prices by Product Category

To update List Prices by Product Category, select the "Update List Prices by Product Category" option. The following screen will appear:

Update List Prices by Product Category

When updating List Prices by Product Category, you are presented with the following options:

All Product Categories

Select to update List Prices for all Product Categories.

Selected

Specify Product Category whose List Prices you want to update.

Pattern

Enter a Product Category pattern to select a range of Product Categories. Refine your search using Regular Expressions.

Update Prices by

Specify the percentage you want to update your List Prices by. The percentage can be either positive or negative.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without updating List Prices by Product Category, returning you to the application desktop.

UPDATE

Updates List Prices by Product Category, using the specified parameters.

11.3. Pricing Schedules

A Pricing Schedule is a grouping of sold Items indicating special Prices for specified Quantity Breaks. Pricing Schedules may be assigned to individual Customers or to groups of Customers by Customer Type. To access the master list of Pricing Schedules, select the "Pricing Schedules" option. The following screen will appear:

Pricing Schedules Master List

At the top of the screen is a "Search for" field. To search for a Pricing Schedule, begin typing in the search field. As you type, the list will automatically scroll toward the Pricing Schedule you are typing. You can also search for Pricing Schedules manually by scrolling through the list. The following filters can also be applied to your search:

Show Expired Pricing Schedules

Select to display expired Pricing Schedules.

Note

The effectivity and expiration dates for Pricing Schedules correspond to the created date for Sales Orders. Changes to Line Item quantities or scheduled dates for already-created Sales Orders can also cause Pricing Schedule effectivity to be recalculated as of the date the changes occur.

Show Future Pricing Schedules

Select to display future Pricing Schedules.

Item Pricing Schedules

Display lists Item Pricing Schedules.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

NEW

Opens screen for creating a new Pricing Schedule.

EDIT

Enables you to edit highlighted Pricing Schedule. The edit screen is the same as that for creating a new Pricing Schedule—except that when editing, the fields will contain Pricing Schedule information. Double-clicking on a Pricing Schedule will also bring you to the editing screen.

VIEW

Highlight a Pricing Schedule and then select this button to reach a read-only view of the "Edit" screen.

COPY

Highlight a Pricing Schedule and then select this button to create a new Pricing Schedule which duplicates the source Pricing Schedule.

DELETE

Highlight a Pricing Schedule and then select this button to remove the Pricing Schedule from the list.

11.3.1. Pricing Schedule

A single Pricing Schedule may contain multiple Items or Product Categories—and multiple Quantity Breaks. To create a new Pricing Schedule, select the NEW button. The following screen will appear:

Create New Pricing Schedule

Tip

When Sales Orders are entered, the system will search for Quantity Break matches between the Sales Order Item and the relevant Pricing Schedule. If duplicate Quantity Breaks are found, the lowest Price for the given quantity will be used.

When creating a new Pricing Schedule, you are presented with the following options:

Name

Enter the name of the Pricing Schedule.

Description

Enter a description to identify the Pricing Schedule.

Effective

Enter the date when the Pricing Schedule becomes effective.

Note

The effectivity and expiration dates for Pricing Schedules correspond to the created date for Sales Orders. Changes to Line Item quantities or scheduled dates for already-created Sales Orders can also cause Pricing Schedule effectivity to be recalculated as of the date the changes occur.

Expires

Enter the date when the Pricing Schedule expires.

Schedule

Display lists all sold Items or Product Categories assigned to this Pricing Schedule.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen, returning you to the previous screen.

SAVE

Creates the Pricing Schedule, adding it to the master list of Pricing Schedules.

NEW

Opens screen for creating a new Pricing Schedule Item.

EDIT

Enables you to edit highlighted Pricing Schedule Item. The edit screen is the same as that for creating a new Pricing Schedule Item—except that when editing, the fields will contain Pricing Schedule Item information. Double-clicking on a Pricing Schedule Item will also bring you to the editing screen.

DELETE

Highlight a Pricing Schedule Item and then select this button to remove the Pricing Schedule Item from the list.

11.3.1.1. Pricing Schedule Item

To create a new Pricing Schedule Item, select the NEW button. The following screen will appear:

Pricing Schedule for Item

When creating a new Pricing Schedule Item, you are presented with the following options:

Type

Specify which type of Pricing Schedule Item you want to create:

Item

Select if the Pricing Schedule is for an individual Item.

Product Category

Select if the Pricing Schedule is for a Product Category.

Tip

The screen options will differ depending on whether the Pricing Schedule is for an Item or a Product Category.

Freight

Select if the Pricing Schedule is for Freight.

Item Number

Enter the Item Number of the Item you want to add to the Pricing Schedule. The browse button located to the right of the field leads to a searchable sold Items list. Multiple sold Items may be assigned to a single Pricing Schedule.

UOM

Inventory Unit of Measure.

To define the base Pricing Schedule details for non-configured Items, select the "Base" tab. The "Characteristics" tab is only available for configured Items (i.e., Job and Reference Items).

Qty. Break

Enter the lowest quantity of the specified Item that must be purchased to receive the specified Price. The Quantity Break is measured in the Inventory Unit of Measure. Multiple Quantity Breaks may be assigned to a single Item.

Price

Enter the Price the specified Item may be purchased for if the specified Quantity Break is met. The Price is measured in the Price Unit of Measure.

Qty. UOM

Specify the Unit of Measure you want to use for the Quantity Break. By default, the Inventory UOM will appear here. However, if you have Selling UOMs defined for the specified Item, you may also select one of these. Selling UOMs are defined on the Item master.

Tip

When using a Selling UOM for the Quantity Break, you may not select an alternate Price UOM. The reason for this is that selling UOMs use the same UOM for both quantity and pricing.

Price UOM

Specify the Price Unit of Measure to be used with the specified Quantity Break UOM. If you select a Selling UOM for the Qty. UOM, you will not be able to select a Price UOM. For Selling UOMs, the Selling UOM and the Price UOM are the same.

List Price

Displays the List Price for the specified Item.

Price/Inv. Ratio

Displays the ratio between the Price and Inventory Units of Measure for the specified Item.

Cost (Pricing UOM)

Displays Standard Cost and Actual Cost for the specified Item.

Margin

The margin is determined by the following formula: Price - Cost / Price.

If the specified Item is a configured Item (i.e., Job and Reference Items), then the "Characteristics" tab will be available. Characteristics for configured Items can carry their own List Prices. These Characteristic Prices may be added to the Base Price when configured Items are sold. To define Characteristic pricing for configured Items, select the "Characteristics" tab. The following screen will appear:

Configured Item Pricing

When defining Characteristic pricing for configured Items, you are presented with the following options:

Characteristic

List displays all the Characteristic Prices which have been associated with the Pricing Schedule Item.

To the far right of the screen, the following buttons are available:

NEW

Opens screen for creating a new Characteristic pricing Item.

EDIT

Enables you to edit highlighted Characteristic pricing Item. The edit screen is the same as that for creating a new Characteristic pricing Item—except that when editing, the fields will contain Characteristic pricing Item information. Double-clicking on a Characteristic pricing Item will also bring you to the editing screen.

DELETE

Highlight a Characteristic pricing Item and then select this button to remove the Characteristic pricing Item from the list.

To add a new Characteristic pricing Item, select the NEW button. The following screen will appear:

Characteristic Pricing

When adding a new Characteristic pricing Item, you are presented with the following options:

Characteristic

Select a Characteristic from the list of Item Characteristics defined for the specified Item.

Value

Select a Value from the list of Values defined for the specified Item Characteristic.

Price

Enter a new Price for the Characteristic and Value combination. This alternate Price will be used in place of the standard Characteristic List Price when the Pricing Schedule is used.

List Price

Displays the default List Price for the Item Characteristic. The List Price for Characteristics is added to the Base Price of Sales Order Items when the Characteristic is specified at Sales Order entry time. Pricing Schedules are designed to override standard List Prices.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without creating the Pricing Schedule Item, returning you to the previous screen.

SAVE

Creates the Pricing Schedule Item and adds it to the Pricing Schedule.

If you are creating a new Pricing Schedule for a Product Category, the following screen will appear:

Pricing Schedule for Product Category

When creating a new Pricing Schedule for a Product Category, you are presented with the following options:

Product Category

Specify the Product Category you want to add to the Pricing Schedule. All Items in the Product Category will be subject to the specified Quantity Break and Discount. Multiple Product Categories may be assigned to a single Pricing Schedule.

Qty. Break (Inventory UOM)

Enter the lowest quantity that must be purchased to receive the specified Discount. The Quantity Break applies to all Items in the specified Product Category. Multiple Quantity Breaks may be assigned to a single Product Category.

Discount Percent (List Price)

Enter the Discount percentage off List Price to be used when the specified Quantity Break is reached. The List Prices for all Items in the Product Category will be reduced by the specified percentage.

11.4. Pricing Schedule Assignments

In order for Pricing Schedules to take effect at Sales Order entry, the Pricing Schedules must be linked—or assigned—to specific Customers or Customer Types. To assign Pricing Schedules to Customers, select the "Pricing Schedule Assignments" option. The following screen will appear:

Pricing Schedule Assignments

When assigning Pricing Schedules to Customers, you are presented with the following options:

Pricing Schedule Assignments

Display lists any and all Pricing Schedule Assignments.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

PRINT

Runs the report associated with this screen.

NEW

Opens screen for creating a new Pricing Schedule assignment.

EDIT

Enables you to edit highlighted Pricing Schedule assignment. The edit screen is the same as that for creating a new Pricing Schedule assignment—except that when editing, the fields will contain Pricing Schedule assignment information. Double-clicking on a Pricing Schedule assignment will also bring you to the editing screen.

DELETE

Highlight a Pricing Schedule assignment and then select this button to remove the Pricing Schedule assignment from the list of Pricing Schedule assignments.

11.4.1. Pricing Schedule Assignment

To create a Pricing Schedule assignment, select the NEW button. The following screen will appear:

Create New Pricing Schedule Assignment

When creating a new Pricing Schedule assignment, you are presented with the following options:

Selected Customer

Select to assign a Pricing Schedule to an individual Customer.

Customer #

Specify the Customer Number of the Customer you want to assign a Pricing Schedule to. The browse button located to the right of the field leads to a searchable Customers list. You may also access this list using the keyboard shortcut "CTRL + L". Once a Customer Number is entered, the Customer name and billing address will display. Select the "?" or "$" symbol next to the browse button to view Customer information for the specified Customer. If a Customer's credit is "In Good Standing," the button will feature a black question mark ("?") icon. If the icon turns to an orange dollar sign ("$"), the Customer's credit Status is "On Credit Warning." A red dollar sign ("$") indicates the Customer's credit Status is "On Credit Hold."

Selected Customer Ship-To

Specify the Customer Ship-To Address you want to assign a Pricing Schedule to. This is an optional setting which may be used in conjunction with the "Selected Customer" setting. The Ship-To option gives you the added flexibility of being able to assign multiple Pricing Schedules to a single Customer based on separate Ship-To Addresses.

Tip

When entering Credit Memos, make sure the Ship-To Address on the Credit Memo matches the Ship-To Address on the Customer's Pricing Schedule. If they don"t match, you won"t be able to issue credit for exclusively sold Items.

Selected Cust. Ship-To Pattern

Enter a Ship-To Address pattern to select a range of Ship-To Addresses for the selected Customer.

Selected Customer Type

Specify the Customer Type you want to assign a Pricing Schedule to.

Customer Type Pattern

Enter a Customer Type pattern to select a range of Customer Types. Refine your search using Regular Expressions.

Pricing Schedule

Specify the Pricing Schedule to be used when entering Sales Orders for the specified Customers.

11.5. Sales

Sales offer the opportunity for discounting Items and Product Categories across all Customer Types. Unlike Pricing Schedule Assignments, Sales cannot be limited to certain Customers or Customer Types. Instead, all Customers benefit from Sales during the period of time when a Sale is in effect. To create a Sale tied to a Pricing Schedule, select the "Sales" option. The following screen will appear:

Sales Master List

Note

If a Sale is in effect and the Sale Price is lower than the most specific Customer Price, then the Customer will be given the Sale Price.

When defining and maintaining Sale information, you are presented with the following options:

Sales

Display lists any and all Sales.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

NEW

Opens screen for creating a new Sale.

EDIT

Enables you to edit highlighted Sale. The edit screen is the same as that for creating a new Sale—except that when editing, the fields will contain Sale information. Double-clicking on a Sale will also bring you to the editing screen.

DELETE

Highlight a Sale and then select this button to remove the Sale from the list of Sales.

11.5.1. Sale

To create a new Sale, select the NEW button. The following screen will appear:

Create New Sale

Note

Sales make Pricing Schedules available to all Customers for the period of time defined by the Sale.

When creating a new Sale, you are presented with the following options:

Name

Enter the name of the Sale.

Description

Enter a description to identify the Sale.

Start Date

Enter the date when the Sale begins.

End Date

Enter the date when the Sale ends.

Schedule

Specify a Pricing Schedule to assign to the Sale. By assigning a Pricing Schedule to a Sale, you make the Prices on the Pricing Schedule available to all Customers for the period defined by the Sale.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen, returning you to the previous screen.

SAVE

Creates the Sale, adding it to the master list of Sales.

11.6. Update Prices

Update Prices section.

11.6.1.  Update Prices by Product Category

To update Prices by Product Category, select the "Update Prices by Product Category" option. The following screen will appear:

Update Prices by Product Category

When updating Prices by Product Category, you are presented with the following options:

All Product Categories

Select to update Prices for all Product Categories.

Selected

Specify Product Category whose Prices you want to update.

Pattern

Enter a Product Category pattern to select a range of Product Categories. Refine your search using Regular Expressions.

Update Prices by

Enter an amount based on the Price update option you specify:

Percent

Select to update Prices by a percentage amount.

Fixed Amount

Select to update Prices by a fixed amount.

Also Update Characteristic Prices

Select to also update Prices associated with Item Characteristics for Items in the specified Product Category range.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without updating Prices by Product Category, returning you to the application desktop.

UPDATE

Updates Prices by Product Category, using the specified parameters.

11.6.2.  Update Prices by Pricing Schedule

To update Item Prices by Pricing Schedule, select the "Update Prices by Pricing Schedule" option. The following screen will appear:

Update Prices by Pricing Schedule

Note

This utility updates Item Prices found on Pricing Schedules only. It will not update discount percentages, nor List Prices.

When updating Prices by Pricing Schedule, you are presented with the following options:

Pricing Schedule

Specify the Pricing Schedule whose Prices you want to update.

Update Prices by

Update Prices for the selected Pricing Schedule. Select Percent or Fixed Amount to specify how you want to update pricing.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without updating Item Prices by Pricing Schedule, returning you to the application desktop.

UPDATE

Updates Item Prices by Pricing Schedule, using the specified parameters.

11.7. Reports

Item Pricing Reports section.

11.7.1.  Prices by Customer Type

To display a list of Prices by Customer Type, select the "Prices by Customer Type" option. The following screen will appear:

Prices by Customer Type

When displaying Prices by Customer Type, you are presented with the following options:

Customer Type

Specify the Customer Type whose Prices you want to display.

Show Expired Prices

Select to display expired Prices.

Show Future Prices

Select to display future Prices.

Show Costs and Margins

Select to show Costs and margins using one of the following costing parameters:

Use Standard Costs

Select to show Costs and margins using Standard Costs.

Use Actual Costs

Select to show Costs and margins using Actual Costs.

Prices

Display lists Prices for the specified Customer Type. Cost and margin columns will also appear if the "Show Costs and Margins" parameter is selected. If the margin is negative, the value will display in red type.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

QUERY

Select to generate the display, using the specified parameters.

PRINT

Runs the report associated with this screen.

11.7.2.  Prices by Customer

To display a list of Prices by Customer, select the "Prices by Customer" option. The following screen will appear:

Prices by Customer

When displaying Prices by Customer, you are presented with the following options:

Customer #

Enter the Customer Number of the Customer whose Item Prices you want to view. The browse button located to the right of the field leads to a searchable Customers list. You may also access this list using the keyboard shortcut "CTRL + L". Once a Customer Number is entered, the Customer name and billing address will display. Select the "?" or "$" symbol next to the browse button to view Customer information for the specified Customer. If a Customer's credit is "In Good Standing," the button will feature a black question mark ("?") icon. If the icon turns to an orange dollar sign ("$"), the Customer's credit Status is "On Credit Warning." A red dollar sign ("$") indicates the Customer's credit Status is "On Credit Hold."

Show Expired Prices

Select to display expired Prices.

Show Future Prices

Select to display future Prices.

Show Costs and Margins

Select to show Costs and margins using one of the following costing parameters:

Use Standard Costs

Select to show Costs and margins using Standard Costs.

Use Actual Costs

Select to show Costs and margins using Actual Costs.

Prices

Display lists Prices for the specified Customer. Cost and margin columns will also appear if the "Show Costs and Margins" parameter is selected. If the margin is negative, the value will display in red type.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

QUERY

Select to generate the display, using the specified parameters.

PRINT

Runs the report associated with this screen.

11.7.3. Prices by Item

To display a list of Prices by Item, select the "Prices by Item" option under "Item Pricing." The following screen will appear:

Prices by Item

When displaying Prices by Item, you are presented with the following options:

Item Number

Enter the Item Number of the Item whose Prices you want to view. The browse button located to the right of the field leads to a searchable list of make and buy items.

UOM

Inventory Unit of Measure.

Show Expired Prices

Select to display expired Prices.

Show Future Prices

Select to display future Prices.

Show Costs and Margins

Select to show Costs and margins using one of the following costing parameters:

Use Standard Costs

Select to show Costs and margins using Standard Costs.

Use Actual Costs

Select to show Costs and margins using Actual Costs.

Prices

Display lists Prices for the specified Item. Cost and margin columns will also appear if the "Show Costs and Margins" parameter is selected. If the margin is negative, the value will display in red type.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

QUERY

Select to generate the display, using the specified parameters.

PRINT

Runs the report associated with this screen.

11.7.4.  Freight Prices by Customer Type

To display a list of Freight Prices by Customer Type, select the "Freight Prices by Customer Type" option. The following screen will appear:

Freight Prices by Customer Type

When displaying Freight Prices by Customer Type, you are presented with the following options:

Customer Type

Specify the Customer Type whose Freight Prices you want to display.

Show Expired Prices

Select to display expired Freight Prices.

Show Future Prices

Select to display future Freight Prices.

Freight Prices

Display lists Freight Prices for the specified Customer Type.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

QUERY

Select to generate the display, using the specified parameters.

PRINT

Runs the report associated with this screen.

11.7.5.  Freight Prices by Customer

To display a list of Freight Prices by Customer, select the "Freight Prices by Customer" option. The following screen will appear:

Freight Prices by Customer

When displaying Freight Prices by Customer, you are presented with the following options:

Customer #

Enter the Customer Number of the Customer whose Freight Prices you want to view. The browse button located to the right of the field leads to a searchable Customers list. You may also access this list using the keyboard shortcut "CTRL + L". Once a Customer Number is entered, the Customer name and billing address will display. Select the "?" or "$" symbol next to the browse button to view Customer information for the specified Customer. If a Customer's credit is "In Good Standing," the button will feature a black question mark ("?") icon. If the icon turns to an orange dollar sign ("$"), the Customer's credit Status is "On Credit Warning." A red dollar sign ("$") indicates the Customer's credit Status is "On Credit Hold."

Show Expired Prices

Select to display expired Freight Prices.

Show Future Prices

Select to display future Freight Prices.

Freight Prices

Display lists Freight Prices for the specified Customer.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

QUERY

Select to generate the display, using the specified parameters.

PRINT

Runs the report associated with this screen.