Skip to main content

Item Cost

caution

This documentation is incomplete.

Inventory item costs are maintained in 2 different groups in inoERP

  1. Reporting Item Cost
    You can create many different versions of reporting item costs for the same item. The system does not use reporting item costs for any transactions/accounting.

  2. Frozen Item Cost
    The system uses frozen costs for all operational activities. You can only run the cost update program to create frozen costs from a reporting cost. You can't manually create/update frozen item costs.

An item cost consists of

  • a header with an item number and an organization
  • several cost elements

To create/view/update an item cost, navigate to the "item cost" screen from your dashboard/favorite.

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.

If you click on the create new button, the system will open a simple step form to create a new item cost. You can click on the detail right bottom to view all the fields available for the object.

To view the search result in a table format, click on the table icon available on 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 item cost data. Depending on the device size, the cost details are shown either right to the search result screen or on a separate screen.

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
60vvTotalAmountTotal AmountInputType.textFINANCE
70vvCostTypeCost TypedeferredSelectCONTROL
80cstItemCostHeaderIdCst Item Cost Header IdInputType.textREFERENCE
90srcEntityNameSrc Entity NamedeferredSelectDEFAULT
100srcEntityIdSrc Entity IdInputType.textREFERENCE
110cstCostTypeIdCst Cost Type IdInputType.numberCONTROL
120invOrgIdInv Org IddeferredSelectREFERENCE
130invItemMasterIdInv Item Master IddeferredSelectREFERENCE
140basedOnRollupCbBased On Rollup CbInputType.switchFieldDEFAULT
150includeInRollupCbInclude In Rollup CbInputType.switchFieldDEFAULT
160salesPriceSales PriceInputType.textFieldFINANCE
170purchasePricePurchase PriceInputType.textFieldFINANCE
220docStatusDoc StatusInputType.selectCONTROL
5180createdByCreated ByInputType.textREFERENCE
5190creationDateCreation DateInputType.textREFERENCE
5200lastUpdatedByLast Updated ByInputType.textREFERENCE
5210lastUpdateDateLast Update DateInputType.textREFERENCE

Lines

You can add multiple lines to each item's cost header. Each item cost line contains cost element code, cost element type, amount.

Navigate to the lines tab to view/add/update lines.
Click on the add new entity to add a new line. If a line already exists, click on copy entity to copy all the details. You can enable/disable fields allowed to be copied in the menu configuration.

Cost Element Code: Enter a cost element code. The system will show the base cost element type.

amount: Enter the cost amount for the cost element.

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.

Enter all the other fields and click on the save button to save the item cost. The app will post all the data to the server and will show the messages returned from the server.

All Fields
SequenceNameLabelInputTypeField Group
10vvCostElementCodeCost Element CodedeferredSelectFINANCE
10vvCostElementTypeCost Element TypeInputType.textCONTROL
20vvCostElementDescriptionCost Element DescriptionInputType.textFINANCE
30cstItemCostLineIdCst Item Cost Line IdInputType.textREFERENCE
40cstItemCostHeaderIdCst Item Cost Header IdInputType.textREFERENCE
50cstCostElementIdCst Cost Element IddeferredSelectREFERENCE
60amountAmountInputType.textFieldFINANCE
70costBasisCost BasisInputType.textFieldFINANCE
80thisLevelCbThis Level CbInputType.switchFieldDEFAULT
90statusStatusInputType.textFieldCONTROL
5100createdByCreated ByInputType.textREFERENCE
5110creationDateCreation DateInputType.textREFERENCE
5120lastUpdatedByLast Updated ByInputType.textREFERENCE
5130lastUpdateDateLast Update DateInputType.textREFERENCE

Actions

Actions allow you to update the frozen cost from an item cost.
You can also use " Cost Update Program" to update item costs for several items.
"Cost RollUp" allows you to calculate the cost of an item with BOM. The system rolls up the cost of all child component costs to the item cost.