- 26 Sep 2024
- 1 Minute to read
- Print
- DarkLight
Create a Inventory Item Detail
- Updated on 26 Sep 2024
- 1 Minute to read
- Print
- DarkLight
Create Inventory Item Details
UI Location: ASSET MANAGEMENT - Inventory - Setup - Item Master
Basic authentication
Unique Row ID, leave blank
Key Value 3; Reference (with CITEMD_COMP_CODE) to the CIITEMTYPE table.
Affiliate sales revenue account. Reference to the ACCOUNT table.
If using the Average Cost method of inventory valuation, specify whether to update the average cost of this inventory item by the total inventory (‘I’), or by the inventory within a specified location (‘L’).
Revenue account. Reference to the ACCOUNT table.
Key value 2; Inventory item code or number. If the fixed length flag is set in the control file, this code must be of the length specified in the control file.
Location code where this item is stored. Reference (with CITEMD_COMP_CODE) to the CILOCATION table.
Cost of goods sold account. Reference to the ACCOUNT table.
Suspense account. Reference to the ACCOUNT table.
Write-off account. Reference to the ACCOUNT table.
Variance account. Reference to the ACCOUNT table.
Not used. Set this to ‘N’
Key value 1; Company code
Inventory account. Reference to the ACCOUNT table.
‘Y’ or ‘N’. Set this to ‘N’ unless CITEMD_SERIAL_FLAG = ‘Y’ and CITEMD_COST_METH_CODE = ’F’
Customer sales revenue account. Reference to the ACCOUNT table.
Adjustment account. Reference to the ACCOUNT table.
Successful response