Batch Cost Update

This screen enables you to update the Cost of all, or selected Items and Descriptors.  The Batch Price Update process comprises the following Steps

•

Create a Cost Update Batch enter the selection and update criteria

•

Generate the Lines from the selection criteria

•

Review the lines for the new costs

•

Select, amend, confirm Lines

•

Go back to the Batch Header

•

Update the Costs against lines that have been flagged

 

 

List Tab

 

Display fields

 

The displayed fields are taken from the Cost Batch 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 Updated Status - By default the display will only show Batches that have not been updated.   If you wish to see all batches including those that have been updated then ‘check’ this checkbox.

 

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 Cost Update screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

 

Add: This will bring up the ‘Detail’ tab for entry of a new Cost Update Batch.

 

Save: Not applicable to the List panel

 

Cancel: Not applicable to the List panel

 

Delete: This only becomes ‘active’ when linked to a Cost Update Batch with status ‘In Progress’.  In this instance it enables you to delete the selected Batch.

 

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

 

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

 

 

Detail Tab

 

This tab enables you to create and maintain a Cost Update Batch Header.  

 

Entry and Display fields

 

Costing Batch No: This is a unique number automatically allocated by the program.  It cannot be amended.

 

Status: This is the status of the Costing Batch and is maintained by the program.  The displayed variants are:

Planned - The Costing Batch is still being worked on

Updated - The Costing Batch has been ‘Posted’ and the records updated against the included Items

 

Reference: Enter a brief description of the Costing Batch.  No validation checks will be carried out on this field.

 

Costing Date: This is prefilled with the system date.  It can be amended at any time up to Posting the Batch by entering the date or by clicking on the drop-down menu and selecting the date.

 

Selection Criteria

 

In this section you define what you want to update

 

Items or Descriptors: Click on the appropriate ‘Radio’ button to select whether this Update batch covers Items or Descriptors.

 

Specific Site: If this is 'checked' then this update will apply to Costs for a Specific Site

 

Site: This will become active if the previous field is 'Checked'.  Select the Specific Site from the drop-down list against which this Batch Cost Update is to be carried out

 

Update Record Selection: The following selection criteria can be entered to restrict the Items or Descriptors that will appear in the Costing Update Batch.  

•

Category: From the drop-down list select the ‘From’ and ‘To’ Category Range.  If nothing is selected then all Categories will be assumed.

•

Code: This will display a list of Items or Descriptors dependent upon the Radio Button selected above.   From the drop-down list select the ‘From’ and ‘To’ Range.  If nothing is selected then all will be assumed.

•

Sourced By: From the drop-down list select the sourcing method.  The options are

o

All

o

Purchasing

o

Assembly

o

Custom

 

Update Settings

 

In this section you define what Costs you want to update

 

Update Area: Any one of two Cost areas can be selected for update.  These are:

•

Update Standard Cost (applicable to Items and Descriptors)

•

Update Average Cost (applicable to Items only)

 

Click on the appropriate ‘Radio’ button to select which you are updating.  This will define which of the following fields become activated for entry of parameters

 

Update Standard Cost: These parameters are required if the ‘Update Standard Cost’ Radio button has been selected.

% Change: Specify the required percentage change relative to the Cost defined in the next field.  This can be positive or negative.

Based On: From the drop-down List select the basis against which the Price Update will be applied.  The options are:

- Std Buy Price (For Items and Descriptors)

- Last Cost (For Items and Descriptors)

- Average Cost (For Items Only)

- Standard Cost (For Items Only)

 

Update Average Cost: This will only be visible if the ‘Items’ Radio Button is selected.   When visible these parameters are required if the ‘Update Average Cost’ Radio button has been selected

% Change: Specify the required percentage change relative to the price/cost defined in the next field.  This can be positive or negative.

Based On: From the drop-down List select the basis against which the Cost Update will be applied.  The options are:

- Std Sell Price

- Std Buy Price

- Last Cost

- Average Cost

- Standard Cost

 

Update Costing with Changes: Clicking this button will update the relevant cost against those records whose ‘Select’ field in the ‘Lines’ tab have been ‘checked’. 

 

Notes: Extended Notes for your own information can be attached to this Cost Update Batch.   Whenever you click on this field an icon will appear in the top-right.   By clicking on this Icon you can bring up the Frequently Used Text table.   Select the text to be copied and either press the OK Button in that screen or double-click the selected record.

 

Buttons

 

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

 

Add: This will show a blank screen for entry of a new Cost Update Batch.

 

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

 

Cancel: Any changes made to the current Costing Update Batch Header record or the last time the ‘Save’ Button was pressed will be lost.

 

Delete: If the Costing Update Batch status is ‘Planned’ then it can be deleted at any time.  ‘Updated’ batched cannot be deleted.

 

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

 

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

 

 

Lines Tab

 

This tab enables you to add and maintain Cost Update lines.   The Costing Update Batch Number and status will be displayed at the top of the panel.  Also at the top of the panel is the following information:

•

The Cost being updated (Standard or Average)

•

The % change being applied

•

The revised Cost Basis

 

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

 

Entry and Display fields

 

Select: ‘Check’ the checkbox where you want the Cost Update to be made.  You have the option to click on the ‘Select All Codes’ Button at the bottom of this panel to select all the records.  You may also click on the ‘De-select All Codes’ Button at the bottom of this panel to ‘un-select’ all the records

 

Code: Display only field showing the Item Number or Descriptor reference

 

Description: Display only field showing the description of the Item or Descriptor

 

Unit: Display only field showing the Unit of Measure of the Item or Descriptor

 

Buy Price: Display only field showing the current Buy Price of the Item or Descriptor

 

Last Cost: Display only field showing the Last Cost of the Item or Descriptor

 

Average Cost: Display only field showing the Average Cost of the Item

 

Old Std Cost: Display only field showing the current Standard Cost of the Item or Descriptor

 

New Std Cost: The system calculated Cost based on the criteria set in the Detail panel. This Cost can be amended prior to update.

 

%Change: Display only field showing the percentage change of the New Cost relative to the Old Cost.

 

Buttons

 

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

 

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

 

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