Item Pricing

This screen allows you to create and maintain Sell and Buy Prices for Items

 

List Tab

 

Display fields

 

The displayed fields are taken from the Item information entered into the ‘Detail’ tab.  The selection of which fields to display is at the user’s discretion.  To select the fields to display simply ‘right mouse’ in the main panel and select ‘Customize List Fields’.   On the displayed panel you can:

•

Click on the ‘Show field’ checkbox to display the field

•

Amend the column heading by changing the content of ‘Display Label’

•

Define the sort sequence of the records by going to the lower panel and dragging the field from ‘Available Fields’ to ‘Sort By’.

•

Click the ‘Save’ Button when done.

 

Data Display Options

 

Field Position - On the List screen you can move the field position by dragging the column heading left or right to the position where you want it to appear.

 

Filtering and Sorting - If you ‘check’ the checkbox then the displayed data is available for filtering and sorting:

•

To sort the data in a selected column simply click on the column heading.  Clicking against will sort in descending order.

•

Click on the black ‘down arrow’ to the right of your selected column heading and you can either select a specific entry to display all records containing that entry, or you can select (Custom…) to enter detailed selection criteria.

 

Include Obsolete Status - If this is checked then the displayed list will include those Items whose status is ‘Obsolete’

 

Searching - If you enter some text into the ‘Search’ field and click on the ‘binoculars’ Icon then all records will be interrogated and those records that contain the entered text will be displayed.  To revert back to displaying all records click on the ‘Eraser’ Icon

 

Buttons

 

Close: This will close the Item Pricing screen. 

 

Related: This will bring up a list of functions that are related to the Item.  You may open and maintain information in those screens whilst still remaining in the Item screen.

 

Reports: This will bring up a list of Reports that are related to the Item.  You can immediately run the report whilst still remaining in the Item screen.

 

 

Detail Tab

 

Entry and Display fields

 

Item Code:  Display only field that shows the current selected Item

 

Unit: Display only field that shown the base Unit of Measure for the Item

 

Description: Display only field that shown the description as held against the Item

 

Pricing Group: Display only field that shown the Pricing Group as held against the Item

 

Status: Display only field that shown the current status of the Item. The options are:

Active - Is currently used throughout Ostendo

Planned - Can be Purchased only

Runout - Cannot be ordered but can be used until stock is zero

Obsolete - Cannot be ordered, Issued, or received

 

 

Sell Price Update Settings

 

Round to the nearest: You can specify that, after any price calculations and discounts have been applied, the resultant sell-price is rounded up to the nearest factor. 

The allowable rounding factors are 0.000001, 0.00001, 0.0001, 0.001, 0.01, 0.05,  0.10,  0.25,  0.50,  1.00,  5.00, 10.00,  25.00,  50.00,  100.00

 

 

Inventory Information

 

Last Cost: Display only field that shows the Actual Cost of the Item when it was last received into stock.

 

Average Cost: Display only field that shows the current Average Cost of the Item across all Warehouses and Locations.

 

Standard Cost: Display only field that shows the Standard Cost of the Item as held against the Item record.

 

 

Activity Dates

 

Last Receipt: Display only field showing the date when this Item was last received.

 

Last Sale: Display only field showing the date when this Item was last sold.

 

Last Price Update: Display only field showing the date when this Item’s Price was last updated.

 

 

Standard Prices

 

Standard Sell Price: Display only field showing the current Standard Sell Price as held against the Item record

 

Standard Buy Price: Display only field showing the current Standard Buy Price as held against the Item record

 

Standard Margin%: Display only field showing the current Margin.  This calculated from

 

(Standard Sell Price - Standard Buy Price)

-------------------------------------------------------------       x    100

               Standard Sell Price

 

 

Sell Price Tab

 

Price Level: From the drop-down list select the Pricing Level.   Pricing Levels are user-defined in Pricing>Settings>Price Levels and represent the level of pricing offered to (say) Retail, Trade, Wholesale, etc

 

Price Calculation Cost Method: Against each Item the user can - for each Price Level - define both a sell price that is evaluated using the following criteria:

               Std Sell Price

               Std Sell Price + $ Value

               Std Sell Price - $ Value

               Std Sell Price + % Value

               Std Sell Price - % Value

               Std Buy Price + $ Value

               Std Buy Price - $ Value

               Std Buy Price + % Value

               Std Buy Price - % Value

               Fixed Price $ Value

               Last Cost + $ Value

               Last Cost - $ Value

               Last Cost + % Value

               Last Cost - % Value

               Std Cost + $ Value

               Std Cost - $ Value

               Std Cost + % Value

               Std Cost - % Value

 

% Value or $ Value: Dependant upon what Price Calculation Cost Method was selected the column title will change between ‘% Value’ and ‘$ Value’.   The entry into this field represents that Value.   

 

Unit Price: Display only field showing the calculated Sell price.  Taking the previous two fields into account this field would contain a Unit Price as follows.  For example:

If the Standard Sell Price is $80

Price Calculation Method is ‘Std Sell Price - % Value’

Entry in ‘% Value or $ Value’ field is 10

Then the Unit sell price would be evaluated at $72 ($80 - (80 * 10 / 100))

 

Quantity Breaks: You can enter up to 5 Quantity Breaks.  These breaks are in the form of

If Order quantity greater than aa then Percentage Discount = ss%

If Order quantity greater than bb then Percentage Discount = tt%

If Order quantity greater than cc then Percentage Discount = uu%

If Order quantity greater than dd then Percentage Discount = vv%

If Order quantity greater than ee then Percentage Discount = ww%

 

The screen will allow entry of order quantities and Discount % and, from these, will calculate and display the Sell Price.

 

Currency: Display only field showing the currency code for the Price Level

 

 

Buy Price Tab

 

Restrict to listed Suppliers: If this is ‘checked’ then the purchase of this Item in the Purchasing Module can only be made from these Suppliers

 

(Primary Supplier): Only active if the previous field is ‘Checked’.  Entry is optional and facilitates automatic ordering from the Replenishment run if required.

 

Supplier: From the drop-down list select a Supplier.

 

Currency Code: Display only field showing the Currency held against this Supplier.

 

Unit: This is prefilled with the base Unit of measure for the Item.  By using the drop-down list it can be amended to any other Unit applicable to this Item

 

Conversion:  This represents the conversion factor between the Supplier’s Unit of Measure and the Item’s base Unit of Measure as defined in the Item Master record.  This is used as follows.  If the Supplier’s Unit of Measure is ‘Drum’ and the base Unit of Measure in Ostendo is ‘Litres’ and 1 drum contains 50 Litres then enter 50 into this field.  This allows you to order and receive in the Supplier’s UOM but place into Inventory in your own UOM.  This field is prefilled with a conversion factor of 1 but can be amended as required.

 

Supplier Item Code: This is an optional entry and allows you to identify the Supplier’s Item Number if it is different than your own internal number.  Both numbers are available for printing on the Purchase Documents.

 

Supplier Item Code: This is the Supplier's description of the item.

 

Unit Price: Upon creating this line it is prefilled with the Standard Buy Price.  You can amend this if the Supplier’s Price is different.

 

Quantity Breaks:  Up to 5 Quantity Breaks can be defined.   These breaks are in the form of

If Order quantity greater than aa then Percentage Discount = ss%

If Order quantity greater than bb then Percentage Discount = tt%

If Order quantity greater than cc then Percentage Discount = uu%

If Order quantity greater than dd then Percentage Discount = vv%

If Order quantity greater than ee then Percentage Discount = ww%

 

Buttons

 

Close: This will close the Item Pricing screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

 

Add: The cursor will go to a new line for entry of a Sell or Buy Price record

 

Save: This will save the current data without exiting the screen

 

Cancel: Any changes made since the line was accessed or the last time the ‘Save’ Button was pressed will be lost.

 

Delete: This will delete the current Sell or Buy Price record

 

Related: This will bring up a list of functions that are related to Item Pricing.  You may open and maintain information in those screens whilst still remaining in the Item Pricing screen.

 

Reports: This will bring up a list of Reports that are related to the Item Pricing.  You can immediately run the report whilst still remaining in the Item Pricing screen.