assemblyItemLocations
The AssemblyItemLocations table tracks the availability of assembly items across different inventory locations, aiding in logistics and stock planning.
Columns
| Name | Type | References | Description |
| atpleadtime | Integer | The number of days that are required to fulfill an Available-to-Promise (ATP) request for this assembly item at the specified location. This value determines how long it takes before the item can be committed to a sales order, factoring in supply chain constraints, open purchase orders, and production lead times. | |
| averagecostmli | Decimal | The calculated average cost of the assembly item at this location, used for financial reporting and inventory valuation. This cost is typically derived from historical purchase prices, manufacturing costs, and any additional cost allocations. It plays a crucial role in cost accounting and profitability analysis. | |
| backwardconsumptiondays | Integer | The number of days before a planned order’s requirement date during which demand can consume available supply. This setting allows NetSuite to balance fluctuations in demand by allowing sales orders or work orders to consume supply from earlier production or procurement. | |
| cost | Decimal | The standard cost that is assigned to the assembly item at this location, used as a benchmark for cost control, variance analysis, and financial reporting. Standard costing is commonly applied in manufacturing and inventory valuation to maintain consistent pricing and profitability tracking. | |
| costaccountingstatus | String | The current cost accounting status of the assembly item, indicating whether cost calculations and adjustments have been applied. This status helps businesses track whether cost updates (such as standard cost changes or revaluations) have been finalized in financial records. | |
| costinglotsize | Double | The predetermined lot size that is used for costing calculations, defining the quantity basis for cost allocations. This value influences cost-per-unit calculations in standard costing and helps determine accurate product cost structures in NetSuite’s financial and inventory management modules. | |
| currentstandardcost | Decimal | The most recent standard cost that is applied to the assembly item at this location, reflecting the expected cost per unit for financial and operational decision-making. This value is updated periodically based on cost accounting rules and is used in financial statements, inventory valuation, and profitability analysis. | |
| currentstandardcosteffectivedate | Date | The date on which the current standard cost became effective, marking the transition point for financial reporting and inventory valuation. This date ensures that any cost changes are properly tracked and applied to transactions occurring after this date. | |
| defaultreturncost | Decimal | The cost that is automatically assigned when the assembly item is returned at this location. This value is used to determine the financial impact of returns and ensure proper accounting for returned inventory, refunds, or credit memos issued to customers. | |
| demandsource | String | The primary source of demand for this assembly item at the specified location. Common demand sources include customer sales orders, work orders for manufacturing, and intercompany transfers. This information is critical for demand planning, order fulfillment, and inventory allocation strategies. | |
| demandtimefence | Integer | The number of days within which new demand (such as sales orders or work orders) is not automatically considered in planning calculations. This value helps stabilize inventory planning by preventing sudden changes to supply orders based on short-term demand fluctuations. | |
| fixedlotsize | Double | The predefined fixed lot size for replenishment and order fulfillment. This value ensures that procurement and production orders are generated in consistent batch sizes, optimizing efficiency in manufacturing and supply chain management. | |
| forwardconsumptiondays | Integer | The number of days after a planned order’s requirement date during which demand can consume available supply. This date allows inventory to be allocated flexibly, preventing short-term shortages while optimizing order fulfillment. | |
| inventorycosttemplate | String | The inventory cost template that is assigned to the assembly item, defining the cost structure and accounting rules applied at this location. Cost templates standardize how inventory costs are calculated, ensuring uniform cost management across different locations and subsidiaries. | |
| invtclassification | String | The classification category that is assigned to the inventory item, used for segmentation, reporting, and planning purposes. Inventory classifications can include fast-moving, slow-moving, obsolete, or other categories based on business rules. | |
| invtcountinterval | Integer | The interval, in days, between scheduled inventory counts for this assembly item at the specified location. Regular inventory counts help maintain accurate stock levels and prevent discrepancies in inventory records. | |
| iswip | Boolean | Indicates whether this assembly item is classified as work-in-progress (WIP) inventory at this location. WIP items are partially completed products that are still in the production process, affecting manufacturing cost tracking and financial reporting. | |
| item | String | The unique identifier (Id) or name of the assembly item associated with this inventory record. This Id is used across NetSuite for tracking, reporting, and order management. | |
| lastinvtcountdate | Date | The most recent date on which a physical inventory count was conducted for this assembly item at this location. Accurate counting ensures proper stock levels and financial reconciliation. | |
| lastpurchasepricemli | Decimal | The last recorded purchase price of the assembly item at this location, reflecting the most recent procurement cost from a vendor. This value helps determine future pricing strategies and cost trends. | |
| location | String | The specific location or warehouse where this inventory record applies. NetSuite allows businesses to manage inventory across multiple locations, and this value ensures stock movements are properly tracked. | |
| nextinvtcountdate | Date | The next scheduled date for a physical inventory count of this assembly item at the specified location. Scheduled counts help maintain accurate inventory records and prevent stock discrepancies. | |
| onhandvaluemli | Decimal | The total inventory value of the assembly item on hand at this location, calculated based on the assigned costing method. This value is used for financial reporting, tax calculations, and profitability analysis. | |
| periodiclotsizedays | Integer | The number of days that define the periodic lot-size increment for supply planning. This setting influences order scheduling and batch production, ensuring efficient use of resources and supply planning strategies. | |
| periodiclotsizetype | String | The type of periodic lot-sizing method that is used for this assembly item, affecting the supply plan's lot-sizing calculations. Common types include fixed period, min-max replenishment, and economic order quantity (EOQ). | |
| preferredstocklevel | Double | The target stock level that is maintained for the assembly item at this location to optimize inventory availability and reduce shortages. This level is used to ensure adequate supply without excessive overstocking. | |
| qtyintransitexternal | Double | The quantity of this assembly item currently in transit from external sources such as suppliers or third-party logistics providers. These in-transit quantities are expected to arrive at the location but are not yet available for use. | |
| quantityavailable | Double | The total quantity of the assembly item that is available for sale or use at this location, excluding committed or reserved stock. This value is critical for order fulfillment and inventory allocation. | |
| quantitybackordered | Double | The total quantity of this assembly item that is backordered due to insufficient stock availability at the location. Backordered items indicate demand that cannot be met currently. | |
| quantitycommitted | Double | The total quantity of the assembly item that is committed to sales orders, work orders, or other planned allocations at this location. Committed quantities are reserved and unavailable for other transactions. | |
| quantityintransit | Double | The total quantity of this assembly item that is currently in transit between locations or warehouses. These quantities are expected to be received but are not yet physically available. | |
| quantityonhand | Double | The actual quantity of the assembly item that is physically available at this location, used for stock tracking and order fulfillment. | |
| quantityonorder | Double | The total quantity of the assembly item that is currently on order but not yet received at this location. These items are expected from suppliers or internal production. | |
| reorderpoint | Double | The minimum stock level that triggers a replenishment order to avoid stockouts at this location. Reorder points ensure that inventory is replenished in time to meet demand. | |
| rescheduleindays | Integer | The number of days by which existing supply orders can be moved forward in the schedule to meet demand requirements. This information helps optimize inventory planning and prevent shortages. | |
| rescheduleoutdays | Integer | The number of days by which existing supply orders can be deferred to a later date without affecting demand fulfillment. This information helps optimize resource utilization and minimize excess inventory. | |
| supplylotsizingmethod | String | The lot-sizing method that is used for generating supply orders, such as fixed, lot-for-lot, or periodic order quantity. This method determines how purchase and production orders are sized. | |
| supplytimefence | Integer | The number of days within which new supply orders are restricted from being automatically created to stabilize planning and avoid excessive adjustments. | |
| supplytype | String | The category of supply fulfillment for this assembly item, such as make-to-stock, make-to-order, or purchase order-based supply. This classification helps define sourcing strategies. |