|
|
|
Item Costing
This screen allows you to create and maintain Last, Average and Standard Costs for Items in addition to viewing the current Item availability and Cost History.
List Tab
Display fields
The displayed fields are taken from the Item information contained in the Item Master file. 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 Costing screen.
Related: This will bring up a list of functions that are related to Item Costing. You may open and maintain information in those screens whilst still remaining in the Item Costing screen.
Reports: This will bring up a list of Reports that are related to Item Costing. You can immediately run the report whilst still remaining in the Item Costing 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
Inventory Costing Information
Last Cost: This is maintained through receipts into Inventory. For Purchased Items however the Last Cost may not be known at the time of receipt therefore it is also updated by the Purchase Invoice price if that is different to the Goods Receipt Price . There are instances, however, when the cost of the last receipt is not known, therefore you can enter that cost here if required.
Average Cost: This is maintained through receipts into Inventory. There are instances, however, when the current Average cost is incorrect, therefore you can enter the correct Average cost here if required.
Standard Cost: This is maintained here although the Standard Cost can be updated via the Cost update routine.
Inventory Information
On-Hand Qty: This is a display only field showing the current stock level across all Warehouses and Locations. For detailed on-hand information click on the adjacent button (Inventory Availability)
Inventory Availability: Clicking on this button will bring up a separate panel that shows details of the Inventory Availability for this Item. This includes
|
• |
Stock by Location segregated by Tracking Characteristic if applicable |
|
• |
Projected Availability taking into account current stock plus supply and demand |
|
• |
List of Supply and Demand orders |
For more details on this Inventory Availability screen see ‘Inventory Availability’ section
Sourced By: This is a display only field showing the normal method by which this Item is sourced. The displayed options are:
Purchasing - fully purchased Item
Assembly - Assembled in-house
Supplier Assembled - Components sent to Supplier for Assembly
Custom - Custom made in-house
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 is calculated from
(Standard Sell Price - Standard Buy Price)
------------------------------------------------------ x 100
Standard Sell Price
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.
The following list shows a complete history of cost changes made to this Item
Cost Type: Display only field showing which Cost was updated
Date Changed: Display only field showing the date when this Item’s Cost record was updated.
Old Cost: Display only field showing the cost prior to the change
New Cost: Display only field showing the cost after the change
Buttons
Close: This will close the Item Costing screen. If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.
Save: This will save the current data without exiting the screen
Cancel: Any changes made to the Cost Fields or the last time the ‘Save’ Button was pressed will be lost.
Related: This will bring up a list of functions that are related to Item Costing. You may open and maintain information in those screens whilst still remaining in the Item Costing screen.
Reports: This will bring up a list of Reports that are related to the Item Costing. You can immediately run the report whilst still remaining in the Item Costing screen.