Item Pricing section.
To create or modify the List Price for an Item, select the "Item List Price" option. The following screen will appear:
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:
Enter the Item Number of the Item you want to create or modify a List Price for.
Inventory Unit of Measure.
Enter the List Price for the specified Item.
Displays the Price UOM for the specified Item.
Displays the ratio between the Price and Inventory Units of Measure for the specified Item.
Displays the Inventory Unit of Measure Price for the Item.
Displays Standard Cost and Actual Cost for the specified Item.
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.
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:
Closes the screen, returning you to the previous screen.
Creates the Item List Price.
To update List Prices by Product Category, select the "Update List Prices by Product Category" option. The following screen will appear:
When updating List Prices by Product Category, you are presented with the following options:
Select to update List Prices for all Product Categories.
Specify Product Category whose List Prices you want to update.
Enter a Product Category pattern to select a range of Product Categories. Refine your search using Regular Expressions.
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:
Closes the screen without updating List Prices by Product Category, returning you to the application desktop.
Updates List Prices by Product Category, using the specified parameters.
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:
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:
Select to display expired Pricing Schedules.
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.
Select to display future Pricing Schedules.
Display lists Item Pricing Schedules.
To the far right of the screen, the following buttons are available:
Closes the screen, returning you to the application desktop.
Opens screen for creating a new Pricing Schedule.
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.
Highlight a Pricing Schedule and then select this button to reach a read-only view of the "Edit" screen.
Highlight a Pricing Schedule and then select this button to create a new Pricing Schedule which duplicates the source Pricing Schedule.
Highlight a Pricing Schedule and then select this button to remove the Pricing Schedule from the list.
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:
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:
Enter the name of the Pricing Schedule.
Enter a description to identify the Pricing Schedule.
Enter the date when the Pricing Schedule becomes effective.
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.
Enter the date when the Pricing Schedule expires.
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:
Closes the screen, returning you to the previous screen.
Creates the Pricing Schedule, adding it to the master list of Pricing Schedules.
Opens screen for creating a new Pricing Schedule Item.
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.
Highlight a Pricing Schedule Item and then select this button to remove the Pricing Schedule Item from the list.
To create a new Pricing Schedule Item, select the NEW button. The following screen will appear:
When creating a new Pricing Schedule Item, you are presented with the following options:
Specify which type of Pricing Schedule Item you want to create:
Select if the Pricing Schedule is for an individual Item.
Select if the Pricing Schedule is for a Product Category.
The screen options will differ depending on whether the Pricing Schedule is for an Item or a Product Category.
Select if the Pricing Schedule is for Freight.
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.
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).
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.
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.
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.
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.
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.
Displays the List Price for the specified Item.
Displays the ratio between the Price and Inventory Units of Measure for the specified Item.
Displays Standard Cost and Actual Cost for the specified Item.
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:
When defining Characteristic pricing for configured Items, you are presented with the following options:
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:
Opens screen for creating a new Characteristic pricing Item.
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.
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:
When adding a new Characteristic pricing Item, you are presented with the following options:
Select a Characteristic from the list of Item Characteristics defined for the specified Item.
Select a Value from the list of Values defined for the specified Item Characteristic.
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.
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:
Closes the screen without creating the Pricing Schedule Item, returning you to the previous screen.
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:
When creating a new Pricing Schedule for a Product Category, you are presented with the following options:
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.
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.
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.
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:
When assigning Pricing Schedules to Customers, you are presented with the following options:
Display lists any and all Pricing Schedule Assignments.
To the far right of the screen, the following buttons are available:
Closes the screen, returning you to the application desktop.
Runs the report associated with this screen.
Opens screen for creating a new Pricing Schedule assignment.
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.
Highlight a Pricing Schedule assignment and then select this button to remove the Pricing Schedule assignment from the list of Pricing Schedule assignments.
To create a Pricing Schedule assignment, select the NEW button. The following screen will appear:
When creating a new Pricing Schedule assignment, you are presented with the following options:
Select to assign a Pricing Schedule to an individual 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."
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.
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.
Enter a Ship-To Address pattern to select a range of Ship-To Addresses for the selected Customer.
Specify the Customer Type you want to assign a Pricing Schedule to.
Enter a Customer Type pattern to select a range of Customer Types. Refine your search using Regular Expressions.
Specify the Pricing Schedule to be used when entering Sales Orders for the specified Customers.
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:
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:
Display lists any and all Sales.
To the far right of the screen, the following buttons are available:
Closes the screen, returning you to the application desktop.
Opens screen for creating a new Sale.
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.
Highlight a Sale and then select this button to remove the Sale from the list of Sales.
To create a new Sale, select the NEW button. The following screen will appear:
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:
Enter the name of the Sale.
Enter a description to identify the Sale.
Enter the date when the Sale begins.
Enter the date when the Sale ends.
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:
Closes the screen, returning you to the previous screen.
Creates the Sale, adding it to the master list of Sales.
Update Prices section.
To update Prices by Product Category, select the "Update Prices by Product Category" option. The following screen will appear:
When updating Prices by Product Category, you are presented with the following options:
Select to update Prices for all Product Categories.
Specify Product Category whose Prices you want to update.
Enter a Product Category pattern to select a range of Product Categories. Refine your search using Regular Expressions.
Enter an amount based on the Price update option you specify:
Select to update Prices by a percentage amount.
Select to update Prices by a fixed amount.
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:
Closes the screen without updating Prices by Product Category, returning you to the application desktop.
Updates Prices by Product Category, using the specified parameters.
To update Item Prices by Pricing Schedule, select the "Update Prices by Pricing Schedule" option. The following screen will appear:
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:
Specify the Pricing Schedule whose Prices you want to update.
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:
Closes the screen without updating Item Prices by Pricing Schedule, returning you to the application desktop.
Updates Item Prices by Pricing Schedule, using the specified parameters.
Item Pricing Reports section.
To display a list of Prices by Customer Type, select the "Prices by Customer Type" option. The following screen will appear:
When displaying Prices by Customer Type, you are presented with the following options:
Specify the Customer Type whose Prices you want to display.
Select to display expired Prices.
Select to display future Prices.
Select to show Costs and margins using one of the following costing parameters:
Select to show Costs and margins using Standard Costs.
Select to show Costs and margins using Actual Costs.
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:
Closes the screen, returning you to the application desktop.
Select to generate the display, using the specified parameters.
Runs the report associated with this screen.
To display a list of Prices by Customer, select the "Prices by Customer" option. The following screen will appear:
When displaying Prices by Customer, you are presented with the following options:
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."
Select to display expired Prices.
Select to display future Prices.
Select to show Costs and margins using one of the following costing parameters:
Select to show Costs and margins using Standard Costs.
Select to show Costs and margins using Actual Costs.
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:
Closes the screen, returning you to the application desktop.
Select to generate the display, using the specified parameters.
Runs the report associated with this screen.
To display a list of Prices by Item, select the "Prices by Item" option under "Item Pricing." The following screen will appear:
When displaying Prices by Item, you are presented with the following options:
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.
Inventory Unit of Measure.
Select to display expired Prices.
Select to display future Prices.
Select to show Costs and margins using one of the following costing parameters:
Select to show Costs and margins using Standard Costs.
Select to show Costs and margins using Actual Costs.
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:
Closes the screen, returning you to the application desktop.
Select to generate the display, using the specified parameters.
Runs the report associated with this screen.
To display a list of Freight Prices by Customer Type, select the "Freight Prices by Customer Type" option. The following screen will appear:
When displaying Freight Prices by Customer Type, you are presented with the following options:
Specify the Customer Type whose Freight Prices you want to display.
Select to display expired Freight Prices.
Select to display future Freight Prices.
Display lists Freight Prices for the specified Customer Type.
To the far right of the screen, the following buttons are available:
Closes the screen, returning you to the application desktop.
Select to generate the display, using the specified parameters.
Runs the report associated with this screen.
To display a list of Freight Prices by Customer, select the "Freight Prices by Customer" option. The following screen will appear:
When displaying Freight Prices by Customer, you are presented with the following options:
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."
Select to display expired Freight Prices.
Select to display future Freight Prices.
Display lists Freight Prices for the specified Customer.
To the far right of the screen, the following buttons are available:
Closes the screen, returning you to the application desktop.
Select to generate the display, using the specified parameters.
Runs the report associated with this screen.