itemLocationConfiguration
Contains item location settings, including inventory rules, locations, and configurations for item management in NetSuite.
Columns
| Name | Type | Description |
| id [KEY] | Integer | A unique internal identifier assigned by NetSuite to track this item-location configuration. |
| advancewarningthreshold | Integer | The number of days before an expected stockout when a warning notification is triggered, helping prevent inventory shortages. |
| atpleadtime | Integer | The lead time, measured in days, used in Available-to-Promise (ATP) calculations to estimate when stock will be available for new orders. |
| backwardconsumptiondays | Integer | The number of days into the past used for aggregating historical demand when forecasting inventory needs. |
| buildtime | Double | The estimated time, in days, required to build, manufacture, or assemble this item before it is ready for sale or use. |
| cost | Decimal | The standard or average cost per unit of the item, used in financial and cost accounting calculations. |
| costinglotsize | Double | The batch size used for cost calculation, defining the quantity for which cost estimates are generated. |
| customform | String | The name or identifier of the custom form applied to this item-location configuration, ensuring tailored data input and tracking. |
| defaultreturncost | Decimal | The default cost applied when items are returned to inventory, used for financial reconciliation and returns processing. |
| demandsource | String | Specifies the primary source of demand for this item, such as 'Sales Orders,' 'Work Orders,' or 'Transfer Orders,' affecting planning calculations. |
| demandtimefence | Integer | The number of days within which changes to demand (for example, new sales orders) are locked and cannot affect planning adjustments. |
| externalid | String | A unique identifier for this configuration in external systems, facilitating integrations with third-party applications or data imports. |
| fixedlotsize | Double | The fixed order quantity used when generating planned orders, ensuring consistency in procurement or production. |
| forwardconsumptiondays | Integer | The number of days into the future used to aggregate expected demand for planning inventory replenishment. |
| inventorycosttemplate | String | The template applied for calculating inventory costs, defining costing methods such as 'FIFO,' 'LIFO,' or 'Standard Costing.' |
| invtclassification | String | The inventory classification code (such as 'A,' 'B,' or 'C'), categorizing items based on sales velocity, value, or other parameters. |
| invtcountinterval | Integer | The interval, in days, between scheduled cycle counts for this item to maintain inventory accuracy. |
| isautolocassignmentallowed | Boolean | Indicates whether automatic location assignment is enabled for this item, allowing NetSuite to determine the best stocking location. |
| isautolocassignmentsuspended | Boolean | Indicates whether automatic location assignment is temporarily suspended, preventing the system from reassigning item locations. |
| iswip | Boolean | Specifies whether this item is a Work-In-Progress (WIP) item, meaning it is part of an incomplete manufacturing process. |
| item | String | The unique identifier or name of the item for which this location configuration applies. |
| latedemandthreshold | Double | The maximum allowable delay, in days, for fulfilling demand before it is considered overdue, helping prioritize urgent orders. |
| leadtime | Integer | The average number of days required to replenish the item, accounting for supplier lead times or internal production schedules. |
| location | String | The name or identifier of the location where this item configuration applies, such as a warehouse or store. |
| locationallowstorepickup | Boolean | Indicates whether customers can pick up this item from the specified location, affecting order fulfillment options. |
| locationstorepickupbufferstock | Integer | The quantity of buffer stock reserved at this location for store pickup orders, ensuring availability for in-person collection. |
| memo | String | Additional notes or comments related to this item-location configuration, providing contextual information for planning and decision-making. |
| minimumrescheduledays | Integer | The minimum number of days before a planned order can be rescheduled, helping stabilize inventory planning. |
| name | String | The descriptive name assigned to this item-location configuration for easier identification and management. |
| nextinvtcountdate | Date | The scheduled date for the next inventory count for this item at the specified location, ensuring inventory accuracy. |
| pastdueforecastdays | Integer | The number of days past due that forecasts are still considered in demand planning, preventing premature write-offs. |
| periodiclotsizedays | Integer | The number of days covered by each periodic lot-sizing calculation, determining batch sizes for production or procurement. |
| periodiclotsizetype | String | The type of periodic lot-sizing method used, such as 'Fixed' or 'Variable,' influencing order quantity calculations. |
| poreceiptcost | Decimal | The cost per unit recorded from the most recent purchase order receipt, providing updated cost information for financial analysis. |
| preferredstocklevel | Double | The optimal inventory level to maintain at this location to meet demand without excessive overstocking. |
| reorderpoint | Double | The inventory level at which a reorder is automatically triggered to replenish stock before a potential stockout occurs. |
| rescheduleindays | Integer | The number of days within which an order can be rescheduled earlier to better meet demand. |
| rescheduleoutdays | Integer | The number of days within which an order can be rescheduled later without significantly impacting operations. |
| safetystocklevel | Double | The minimum stock quantity maintained as a buffer to prevent stockouts during unexpected demand fluctuations. |
| savedleadtime | Integer | The previously recorded lead time value, used for reference or comparison with updated lead time calculations. |
| savedpreferredstocklevel | Double | The previously recorded preferred stock level, used for tracking changes in inventory planning. |
| savedreorderpoint | Double | The previously recorded reorder point, providing historical context for adjustments in replenishment strategy. |
| subsidiary | String | The name or identifier of the subsidiary associated with this item configuration, ensuring proper financial reporting across business units. |
| supplylotsizingmethod | String | The method used for calculating supply lot sizes, such as 'Fixed Order Quantity' or 'Economic Order Quantity (EOQ).' |
| supplytimefence | Integer | The number of days within which supply changes (such as new purchase orders) are locked to prevent disruptions in planning. |
| supplytype | String | The primary source of supply for this item, such as 'Purchase Order,' 'Work Order,' or 'Transfer Order,' influencing replenishment strategies. |
| templatestored | Boolean | Indicates whether this configuration template is stored in NetSuite, allowing it to be reused for future item-location setups. |