Rules Affecting Effective Start and End Date for Standard Costing

This topic enumerates the rules affecting effective start and end date for standard costing.

The following rules apply to effectivity start and end dates for standard costing:

  • Allow multiple rows for the same Cost Type.  This is allowed for Cost types of Standard and Reference.
  • For cost type of Last, multiple rows are not allowed. Only one row for this cost type for any particular project is allowed.
  • No two rows are effective at the same time.
  • If there are multiple rows for a particular cost type, there cannot be a gap in effective date coverage.
  • Rows with overlapping effective start/end dates is not allowed.
  • Deletion of previously saved rows is not allowed (previously allowed), in order to keep a history of cost changes.  It is expected that users will enter new rows with new effectivity dates for any cost changes that need to be applied.
  • Manual update to a previously saved row, in case user made a mistake during data entry, is allowed.
  • If user changes the standard cost on a currently effective row, and inventory valuation is based on the project standard costs, inventory costs are also updated automatically for all abbreviations associated with that particular project and part/revision.
Note: Only cost updates to the currently effective row in project item cost will update inventory.

Example

Assuming current date falls between 03/01/17 and 06/30/17, you will have to modify the cost in the middle row (existing Material Cost = 100) in order to affect inventory rows. Changes made to the first or third rows will have no impact on inventory.

Cost Type Start End Material Cost
Standard 07/01/17 110
Standard 03/01/17 06/30/17 100
Standard 01/01/17 02/28/17 90