Skip to main content

Frozen Item Cost

caution

This documentation is incomplete.

The system uses frozen item costs for all operational purposes and thus does not allow users to create/update frozen costs directly. The restrictions are in place at the front end and the database level.

Run the " Cost Update Program " to create frozen costs for a new item. You can also create frozen costs from item costs by using the cost update action.

Navigate to the "item cost" screen from your dashboard/favorite to view an item cost.

Enter the organization/item cost details or any other criteria in the search form and click on the search button to view an existing item cost.

If you don't enter organization details, the system will show you all the item costs. If your organization has configured to make any field mandatory for search, then you have to enter those fields to search item costs.
The application will fetch all the server data and take you to the search result screen. The search result screen looks a bit different on desktop and mobile devices.

To view the search result in a table format, click on the table icon in the bottom left corner.

To view specific item cost details, click on the menu of that record, and click on view/fetch & view.

You can also click on the expand icon against any item on the search result screen to view the item cost header details, such as item number, UOM, etc.

The system will fetch all the selected document detail line data. The document details are shown either right to the search result screen or in a separate screen, depending on the device size.

Scroll left, right, up, down to view all the details. The document line and details are shown in a separate tab.. The default configuration shows fields in various functional groups such as

  • Finance
  • Entity
  • Reference
  • Data
  • Control
  • Etc

You can configure the application to show which fields should be shown under which group. You can also create new groups as per your business requirements.

All Fields
SequenceNameLabelInputTypeField Group
10vvInvOrgCodeInv Org CodedeferredSelectENTITY
10vvItemNumberItem NumberdeferredSelectDEFAULT
20vvItemDescriptionItem DescriptiondeferredSelectDEFAULT
30vvCostingMethodCosting MethodInputType.textFINANCE
40vvCostingEnabledCbCosting Enabled CbInputType.textFINANCE
50vvUomCodeUom CodedeferredSelectDEFAULT
60cstFrozenCostHeaderIdCst Frozen Cost Header IdInputType.textREFERENCE
70srcEntityNameSrc Entity NamedeferredSelectDEFAULT
80srcEntityIdSrc Entity IdInputType.textREFERENCE
90invOrgIdInv Org IddeferredSelectREFERENCE
100invItemMasterIdInv Item Master IddeferredSelectREFERENCE
110cstItemCostHeaderIdCst Item Cost Header IdInputType.textREFERENCE
120amountAmountInputType.textFieldFINANCE
130costDetailsCost DetailsInputType.textFieldFINANCE
140docStatusDoc StatusInputType.textFieldCONTROL
5150createdByCreated ByInputType.textREFERENCE
5160creationDateCreation DateInputType.textREFERENCE
5170lastUpdatedByLast Updated ByInputType.textREFERENCE
5180lastUpdateDateLast Update DateInputType.textREFERENCE

Lines

You can have multiple lines for each item cost header. Each item cost line contains cost element code, cost element type, amount.

Navigate to the lines tab to view lines.

Cost Element Code: The system copies the cost element code from the item cost.

amount: The system copies the amount value from the item cost.

The reference groups show various ids for reference only. You don't need to enter any information in this section. When you save an item cost for the first time, the system will auto-populate the newly created header id and line ids.

Scroll left, right, up, and down view all other fields.

All Fields
SequenceNameLabelInputTypeField Group
10costElementCodeCost Element CodedeferredSelectFINANCE
10costElementTypeCost Element TypeInputType.selectCONTROL
20costElementDescriptionCost Element DescriptionInputType.textFieldFINANCE
30cstFrozenCostLineIdCst Frozen Cost Line IdInputType.textREFERENCE
40srcEntityNameSrc Entity NamedeferredSelectDEFAULT
50srcEntityIdSrc Entity IdInputType.textREFERENCE
60cstFrozenCostHeaderIdCst Frozen Cost Header IdInputType.textREFERENCE
70cstItemCostLineIdCst Item Cost Line IdInputType.textREFERENCE
80cstCostElementIdCst Cost Element IddeferredSelectREFERENCE
90amountAmountInputType.textFieldFINANCE
100costBasisCost BasisInputType.textFieldFINANCE
110thisLevelCbThis Level CbInputType.switchFieldDEFAULT
120statusStatusInputType.textFieldCONTROL
170docStatusDoc StatusInputType.selectCONTROL
5130createdByCreated ByInputType.textREFERENCE
5140creationDateCreation DateInputType.textREFERENCE
5150lastUpdatedByLast Updated ByInputType.textREFERENCE
5160lastUpdateDateLast Update DateInputType.textREFERENCE

Current Frozen Cost

Curr Frozen Item Cost is the last frozen cost added for a given item. When you update cost from item to frozen cost, the system creates a new record for frozen cost and always uses the latest value for all operations.

Header

Navigate to the "frozen cost" screen from your dashboard/favorite to view a frozen cost.

Enter the organization/frozen cost details or any other criteria in the search form and click on the search button to view an existing frozen cost.

If you don't enter organization details, the system will show you all the frozen costs. If your organization has configured to make any field mandatory for search, then you have to enter those fields to search frozen costs.
The application will fetch all the server data and take you to the search result screen. The search result screen looks a bit different on desktop and mobile devices.

To view the search result in a table format, click on the table icon in the bottom left corner.

To view specific frozen cost details, click on the menu of that record, and click on view/fetch & view.

You can also click on the expand icon against any item on the search result screen to view the frozen cost header details, such as item number, UOM, etc.

The system will fetch all the selected document detail line data. The document details are shown either right to the search result screen or in a separate screen, depending on the device size.

Scroll left, right, up, down to view all the details. The document line and details are shown in a separate tab.. The default configuration shows fields in various functional groups such as

  • Finance
  • Entity
  • Reference
  • Data
  • Control
  • Etc

You can configure the application to show which fields should be shown under which group. You can also create new groups as per your business requirements.

All Fields
SequenceNameLabelInputTypeField Group
10vvInvOrgCodeInv Org CodedeferredSelectENTITY
10vvItemNumberItem NumberdeferredSelectDEFAULT
20vvItemDescriptionItem DescriptiondeferredSelectDEFAULT
30vvCostingMethodCosting MethodInputType.textFINANCE
40vvCostingEnabledCbCosting Enabled CbInputType.textFINANCE
50vvUomCodeUom CodedeferredSelectDEFAULT
60cstFrozenCostHeaderIdCst Frozen Cost Header IdInputType.textREFERENCE
70srcEntityNameSrc Entity NamedeferredSelectDEFAULT
80srcEntityIdSrc Entity IdInputType.textREFERENCE
90invOrgIdInv Org IddeferredSelectREFERENCE
100invItemMasterIdInv Item Master IddeferredSelectREFERENCE
110cstItemCostHeaderIdCst Item Cost Header IdInputType.textREFERENCE
120amountAmountInputType.textFieldFINANCE
130costDetailsCost DetailsInputType.textFieldFINANCE
140docStatusDoc StatusInputType.textFieldCONTROL
5150createdByCreated ByInputType.textREFERENCE
5160creationDateCreation DateInputType.textREFERENCE
5170lastUpdatedByLast Updated ByInputType.textREFERENCE
5180lastUpdateDateLast Update DateInputType.textREFERENCE

Lines

You can have multiple lines for each frozen cost header. Each frozen cost line contains a cost element code, cost element type, amount.

Navigate to the lines tab to view lines.

Cost Element Code: The system copies the cost element code from the item cost.

amount: The system copies the amount value from the item cost.

The reference groups show various ids for reference only. You don't need to enter any information in this section. When you save a frozen cost for the first time, the system will auto-populate the newly created header id and line ids.

Scroll left, right, up, and down view all other fields.

All Fields
SequenceNameLabelInputTypeField Group
10costElementCodeCost Element CodedeferredSelectFINANCE
10costElementTypeCost Element TypeInputType.selectCONTROL
20costElementDescriptionCost Element DescriptionInputType.textFieldFINANCE
30cstFrozenCostLineIdCst Frozen Cost Line IdInputType.textREFERENCE
40srcEntityNameSrc Entity NamedeferredSelectDEFAULT
50srcEntityIdSrc Entity IdInputType.textREFERENCE
60cstFrozenCostHeaderIdCst Frozen Cost Header IdInputType.textREFERENCE
70cstItemCostLineIdCst Item Cost Line IdInputType.textREFERENCE
80cstCostElementIdCst Cost Element IddeferredSelectREFERENCE
90amountAmountInputType.textFieldFINANCE
100costBasisCost BasisInputType.textFieldFINANCE
110thisLevelCbThis Level CbInputType.switchFieldDEFAULT
120statusStatusInputType.textFieldCONTROL
170docStatusDoc StatusInputType.selectCONTROL
5130createdByCreated ByInputType.textREFERENCE
5140creationDateCreation DateInputType.textREFERENCE
5150lastUpdatedByLast Updated ByInputType.textREFERENCE
5160lastUpdateDateLast Update DateInputType.textREFERENCE