Field descriptions:  Items

Item type

The options that appear in the dropdown list depend on the application through which you’re adding the item. The possible options are:

• Inventory: Select this type for items that will be available in inventory, sales, and purchasing transactions.
• Non-inventory: Select this type for items that will be available in both sales and purchasing transactions or contracts.
• Non-inventory (purchase only): Select this type for items that will only be available in purchasing transactions or contract expenses.
• Non-inventory (sales only): Select this type for items that will only be available in sales transactions or contracts.
• Kit: Select this type for the parent item of a kit (to be assembled at the time of the order). This type is only available if Kits is enabled on the Configure Order Entry or Configure Inventory Control page. Kits cannot be added as supplies items.
• Stockable kit: Select this type for the parent Item of a stockable kit (assembled and stored before order). This type is only available if stockable kits is enabled on the Configure Inventory Control page.

After you've saved an item, you cannot change its type. You can always delete the item and start over if you meant to select a different type.

Item is inactive

Indicates whether the item is available for use in transactions. The default is unchecked (active).

Select the status checkbox if you do not want to use the item in transactions. Inactive items do not appear on transaction selection lists. To view inactive items in lists or reports, you can select the filter, 'Include inactive'.

Supplies item

Select this checkbox to indicate this item is for internal use only. Supplies items are available for employee supplies requests. Supplies items might be office supplies, computer accessories, or items you need to deliver services and programs.

• Non-inventory (sales) and Kit type items cannot be tracked as supply items.

• Supplies items cannot be used in Order Entry transactions.

• If an inventory item has been used in a transaction, you cannot change it to a supply item.

Whether to include the item in the Software Digital Board Book calculations of monthly recurring revenue.

This field is only applicable if your company subscribes to the Software Digital Board Book.

On order

The item total for the quantity on order. Item totals are combined for all warehouses and automatically displayed based on transaction entries. In addition, you can view totals per warehouse.

In transit

The item total in warehouse transfers that are in transit. Item totals are combined for all warehouses and automatically displayed based on transaction entries. In addition, you can view totals per warehouse.

This field appears if in-transit warehouse transfers is enabled.

On hand

The item total for quantity on hand. Item totals are combined for all warehouses and automatically displayed based on transaction entries. In addition, you can view totals per warehouse.

On hold

The item total for the quantity on hold. Item totals are combined for all warehouses and automatically displayed based on transaction entries. In addition, you can view totals per warehouse.

Available

The item total for the quantity available. Item totals are combined for all warehouses and automatically displayed based on transaction entries. In addition, you can view totals per warehouse.

Quantity available is typically calculated as quantity on hand minus quantity on hold, but might also include quantity on order and quantity in transit. The calculation depends on how Inventory Control is configured.

See Specify how quantity available is calculated.

Reserved

Appears if Inventory Control is enabled for fulfillment or your company is using the feature, for committing quantities in Order Entry transactions.

The item total that's been set aside to fill sales orders. Reserved quantity is considered to still be on the warehouse shelves but not available to be used anywhere else. For example it's the quantity of the item in fulfillment that is not in Open status.

Item totals are combined for all warehouses and automatically displayed based on transaction entries. In addition, you can view totals per warehouse.

Allocated

Appears if Inventory Control is enabled for Fulfillment or your company is using the feature for committing quantities in Order Entry transactions.

The item total that's been assigned to fill sales orders. Allocated quantity is considered to be picked from the warehouse shelves, dedicated to specific orders and not available to be used anywhere else. The quantity cannot be taken away to fulfill different orders. For example, when the quantities that are picked or packed for an order are entered in fulfillment, the reserved quantity is decreased and the allocated quantity is increased.

Item totals are combined for all warehouses and automatically displayed based on transaction entries. In addition, you can view totals per warehouse.

Uncommitted

Appears if Inventory Control is enabled for fulfillment or your company is using the feature for committing quantities in Order Entry transactions.

The item total that can still be used to fulfill orders. It's calculated as the quantity on hand minus the quantity reserved minus the quantity allocated.

Item totals are combined for all warehouses and automatically displayed based on transaction entries. In addition, you can view totals per warehouse.

Item ID

Enter a unique identifier, which can be up to 30 characters.

Name

Enter a unique name for the item as it will appear when the item is entered in transactions.

Product line ID

Enter the ID of the product line to which this item belongs. If you do not know this ID, select the dropdown list to display a list of existing product lines from which to choose. To create a new product line, select Add at the top of the list..

Extended description

Enter a detailed description of the item. This is most useful if you have many items that have only slight variations. The description is used as the default Item description when the item is entered in Order Entry, Purchasing, and Inventory Control transactions.

Cost method

This field appears if multiple cost methods is enabled on the Configure Inventory Control page and the item type is Inventory. After you've saved an item, you cannot change its cost method.

Select the accounting method to use for determining the cost of inventory:

• Standard cost: The planned or expected costs. This method is used in situations where purchase costs remain relatively stable over time.
• Average cost: Takes the weighted average of all units available for sale and uses that average to determine the value of COGS and ending inventory.
• First-in, first-out (FIFO): Assumes the first item into your inventory is sold first.
• Last in, first-out (LIFO): Assumes the last unit into your inventory is sold first.

You cannot select a cost method for kits because:

• Standard kits do not have a cost method.
• Stockable kits always use FIFO by default.

The cost method affects how the inventory cost layers are used, the total valuation is determined, and the unit cost is derived for an inventory item. Learn more about cost methods.

Description on purchase transactions and Description on sales transactions

Appears if the item is created or edited from the Purchasing or Order Entry application. These fields allow for a cross-reference to the item description that was used in a legacy accounting system during implementation or data migration. The fields can also be used to allow for additional item details for internal reporting purposes or in API calls. The description entered in either field does not appear in any transactions and does not print on any documents.

Unit of measure

Use the dropdown list to select the unit of measure for the item.

You cannot change the unit of measure for an item. If you want an item to have a different unit of measure, you can duplicate the item and change the unit of measure on the new item. Then set the original item to inactive.

Learn more about units of measure.

Note

Use this field to enter in any notes or details that are not provided elsewhere.

Default conversion type

For non-inventory items, such as services, choose whether to calculate transactions based on the price or quantity on orders and invoices.

Attachment

Add one or more files you want to store with the item. This could be information for internal teams who need packing details, or product specifications. Attachments remain accessible throughout a workflow.

Learn who can add attachments.

Expense account

Use the dropdown list to select the account that you want to use to track expenses when this item is used in transactions.

Appears only for Non-inventory and Non-inventory (purchase only) items.

Accounts Receivable GL account

Use the dropdown list to select the default Accounts Receivable account to use for this item. This account will override the AR account set on the Configure Order Entry page.

Accounts Payable GL account

Use the dropdown list to select the default Accounts Payable account to use for this item. This account will override the AP account set on the Configure Purchasing page.

Fulfillment

Select to enable the item for fulfillment. Use this option when you keep the item in inventory but don't want to physically track or count on hand quantities because you purchase and expense them instead.

Non-inventory items marked for fulfillment appear as line items as you work with Order Entry transactions on the Fulfillment pages. Non-inventory items not marked for fulfillment do not appear on the Fulfillment pages; however, a final OE sales invoice will correctly include the line items for non-inventory items.

Appears only for items with an item type of Inventory or Non-inventory (sales only).

Inventory account

Select the General Ledger account that you want to use for inventory when this item is used in transactions.

Appears only for inventory items

Shipping weight

Enter the item's total shipping weight.

Appears only for inventory items.

GL group

Select the item GL group to which this item belongs.

An item GL group enables you to categorize items for the purpose of posting to specific GL accounts. For example, you might set up OE sales invoices in your company so that all items in a "Services" Item GL group post revenue to "Revenue-Services" while all items in the "Hardware" Item GL group post revenue to "Revenue-Hardware.

Learn more about GL groups in advanced workflows.

Auto-print label

Select only if you’re using a third-party label scanner product to print barcode labels when processing the item in a Purchasing transaction, such as a receipt. The option triggers label printing for the received quantity. This option is meant for use with scanner integrations and has no functionality within Sage Intacct.

Appears only for inventory items and stockable kits if the Integrated scanner product in use option is selected on the Configure Inventory Control page.

This field only appears for Inventory and Non-inventory (including Purchase only and Sales only) items. The field does not appear for Inventory items with a standard cost method in multi-entity shared environments enabled for multiple base currencies.

Enter the item's standard cost value. If the Enable automatic price variance posting checkbox is selected on the Configure Purchasing page, Sage Intacct compares this price to the actual purchase price from a PO purchase invoice and posts any difference to the configured Purchase price variance GL account. You can monitor the Purchase Price Variance report to decide whether to update an item's standard purchase price.

COGS account

Select the General Ledger account that you want to use to track the cost of goods sold (COGS) when this item is used in transactions.

Appears only for Inventory, Non-inventory, and Non-inventory (Purchase only) items.

Base price

For sales items: Enter the base price of the item. Does not appear for Non-inventory (purchase only) items.

Revenue account

Select the General Ledger account that you want to use for revenue when this item is used in transactions.

Does not appear for Non-inventory (Purchase only) items.

Taxable

If the sale of the item is taxable, select this checkbox.

Item tax group

The ability to assign items to their own tax groups enables you to apply different tax schedules to different items.

For example, say that your company distributes a product that's considered a luxury item in one locale where luxury items have a separate tax of 3%. You would create an item tax group called "3% Lux Tax" in the Item Tax Group page so you can assign the appropriate items to that tax group. When the tax is applied, Sage Intacct then knows to call the appropriate tax schedule. If your company uses the Avalara AvaTax Integration, note that this setting has no effect there.

Tax code

Appears if your company is subscribed to the Avalara AvaTax integration. Enter the Avalara tax code for this item to enable Avalara to calculate tax on the item. Avalara maintains a list of about 2000 standard tax codes, which specify the type of item sold, to calculate (or not calculate) the relevant tax. The Avalara system determines the taxability and tax rates, computes the tax amounts, and sends the rates, jurisdictions, and amounts to Intacct.

For a list of the Avalara tax codes, go to Avalara Get AvaTax codes for goods and services where you can export the tax codes into an Excel file (.xlsx).

Available for drop ship

Indicates that a Purchasing transaction will be automatically generated when the Order Entry transaction is created to fulfill the stock for the customer's order and that the item will be shipped from the supplier directly to the customer.

This field is only available when the item type is Inventory or Non-Inventory because the item must be available in both Order Entry and Purchasing. This field only appears if drop ship is set up for your company.

Available for buy to order

Indicates that a Purchasing transaction will be automatically generated when the Order Entry transaction is created to fulfill the stock for the customer's order. The item is not shipped directly from the supplier to the customer as with drop ship, but instead is shipped to your company or warehouse for repackaging, additional processing, or just to confirm it's been received.

This field is only available when the item type is Inventory or Non-Inventory because the item must be available in both Order Entry and Purchasing. This field only appears if buy to order is set up for your company. This field is not available for supply items.

Deferred revenue account

Select the balance sheet liability to use for reporting amounts received in advance of being earned.

Default revenue recognition template

Select the default template that contains the desired revenue recognition schedule.

Default delivery status

Options are:

• Delivered: The item's revenue recognition schedule will start on the applicable start date.
• Undelivered: The item's revenue recognition schedule will be on hold until the item is delivered.

Default deferral status

Options are:

• Defer until item is delivered: The revenue schedule for this item will be placed on hold until this item is delivered.
• Defer bundle until item is delivered: The revenue schedules for all items on the sales transaction will be placed on hold until this specific item is delivered.

Fair Value category

This field is only applicable to MEAs within Order Entry.

This field appears if Advanced revenue recognition under Order Entry is selected on the Configure Revenue Management page.

If the item can be sold as part of a multiple-element arrangement, select the category that identifies the performance obligation. When a sales transaction that includes a bundle is saved, Sage Intacct evaluates each included item's fair value category to calculate the revenue allocation for each item. Learn more about MEA allocations.

Options are:

• Product: Specified
• Product: Unspecified
• Software
• Upgrade: Specified
• Upgrade: Unspecified
• Services
• Post Contract Support (PCS)

Billing template

Revenue template 1 and Revenue template 2

Use the dropdown lists to select the default revenue template for the applicable journals.

Expense template 1 and Expense template 2

Use the dropdown lists to select the default expense template for the applicable journals.

Contract fair value category

Sage Intacct uses fair value categories to distinguish products or services included in an MEA that will be used in the algorithm that determines another item's estimated standalone selling price.

If the item can be sold as part of a multiple-element arrangement, select the category that identifies the performance obligation. Learn more about fair value categories in contracts.

This field is only applicable if your company is subscribed to Contract Advanced Revenue Recognition.

Default contract delivery status

Options are:

• Delivered: the contract line's recognition event has occurred
• Undelivered: the contract line's recognition event has not occurred

Learn more about setting up event-driven recognition.

Default contract deferral status

Options are:

• Defer revenue until item is delivered: the revenue schedule for this item will not start until this item has Delivery status = "Delivered".
• Defer revenue until all items are delivered: the revenue schedule for this item will not start until all contract lines in the contract have Delivery status = "Delivered".

Default bundle

Indicate whether this item is to be included in the default bundle when an MEA allocation that includes this item is created. Users can choose to exclude the item when they create the MEA allocation.

This field is only applicable if your company is subscribed to Contract Advanced Revenue Recognition.

Warehouse ID

Use the dropdown list to select a warehouse that stocks this item.

Currency

The 3-character ISO code that represents the currency of the unit item costs for the warehouse. The currency for a warehouse is the base currency of the entity to which the warehouse belongs, for both single and multi-entity companies.

This field is read-only.

On order

In transit

On hand

On hold

Available

Reserved

Allocated

Uncommitted

Last unit cost

Last date sold

Last date received

These fields are read-only.

Storage area

Enter the location within the warehouse where the item is normally stored, such as Aisle 23, Row 12, Shelf 3, which typically is abbreviated as A23 R12 S3.

Inventory cycle default

Select any optional inventory cycle. This is for your information purposes only; inventory cycles do not affect the system.

Default bin

The default bin for the item. This field has no effect unless the item is bin-tracked.

Override replenishment values on the Vendor history tab

Select this checkbox to override the replenishment information on the Vendor history tab for the item in this warehouse. Sage Intacct will use the replenishment override information you specify for the warehouse to determine when to recommend reordering the item for this warehouse and how much to order.

Safety stock

Enter the extra quantity that you want to have in inventory to avoid stockouts. The default is 1. Valid values are 0 and positive integers.

Maximum order quantity

Enter the maximum quantity of this item to order. Sage Intacct might suggest a quantity to purchase that's a little more than the maximum so the quantity to purchase is a multiple of the economic order quantity.

The default is blank, which means there’s no maximum order quantity. Valid values are blank and positive integers.

Replenishment method

The replenishment method determines what's included in the calculations used to determine when to suggest reordering the item for the warehouse, from which suppliers, and the quantity to purchase:

• Demand forecast by single value: Includes the forecasted demand of the item during supplier lead time. A single value that you enter for each supplier in the Supplier entries table represents the demand. This method is useful when demand for the item is stable during the year.
• Demand forecast by fluctuating values: Includes the forecasted demand of the item during supplier lead time. The replenishment fluctuating demand forecast for the item includes entries for the expected quantities needed on each given date regardless of supplier. The sum of the forecast quantities with dates during the time period between the As of date plus the supplier's lead time represents the demand during supplier lead time. This method is useful when demand for items fluctuates greatly during the year, such as for highly seasonal items.
• Reorder point: Does not include any forecasted demand of the item during supplier lead time. Intacct uses the quantity for the reorder point as a starting point to determine when items need to be reordered.

Learn more about the replenishment methods and calculations.

Add a forecast and View fluctuating forecast

These buttons appear if the replenishment method is Demand forecast by fluctuating values:

• Add a forecast: The item does not have a fluctuating demand forecast. Select the button to create one. The item will be considered for replenishment in the warehouse only if a forecast exists.
• View fluctuating forecast: The item has a fluctuating demand forecast. Select the button to edit it.

Reorder point

Enter the quantity of inventory of the item that you do not want the item to fall below. When the current net inventory falls to the reorder point plus the safety stock, the item is triggered for reorder. The default is 1. Valid values are blank and positive integers.

This field appears if the replenishment method is Reorder point.

Quantity to reorder

Enter the quantity to reorder when the item needs reordering. The default is 1. Valid values are blank, 0, and positive integers. If you leave the field blank, Sage Intacct uses a value of 0.

In the calculations, the Quantity to reorder is rounded up to be a quantity that's a multiple of the economic order quantity. So, Sage Intacct might suggest ordering a little more than quantity you enter. The user can always override the suggested Quantity to purchase in the Replenish Inventory page to be the Quantity to reorder.

This field appears if the replenishment method is Reorder point.

Preferred supplier

Select the checkbox to identify this supplier as the preferred supplier for replenishing this item for this warehouse. On the Replenish Inventory page, when Preferred supplier is selected as the Supplier ordering option, this supplier and related pricing is displayed on the main line for the item if it needs reordering to streamline the replenishment process. If the item can also be purchased from other suppliers, the user can select another supplier from the Supplier name dropdown before generating the purchase orders.

You can select only one preferred supplier. If you do not select a preferred supplier, the first supplier listed in the table is automatically selected as the preferred supplier when you save the item.

Supplier ID

Enter or select the supplier ID.

Stock number

Enter the stock number the supplier uses for this item. You can enter up to 50 characters.

Lead time (days)

Enter the number of days that it takes the supplier to deliver this item to you after receiving the order. The default is the Lead time default (days) from the supplier record. Valid values are blank, 0 and positive integers.

Demand forecast during lead time

Enter the quantity of this item that's expected to be sold during the lead time. The default is blank. Valid values are blank, 0, and positive integers.

This field appears if the replenishment method is Demand forecast by single value.

Economic order quantity

Enter the quantity that makes the cost of reordering this item the most economical. The default is 1. Valid values are blank, 0, and positive integers.

Supplier minimum order qty

Enter the minimum quantity of this item the supplier is willing to sell. The default is 1. Valid values are blank, 0, and positive integers.

Units of measure

The units of measure the supplier sells this item in. For example, the supplier might sell in dozens instead of each. The default is the base unit of the item's UOM group.

Best cost

The lowest price that you paid for the item. This is a read-only field.

Last unit cost

The most recent price that you paid for the item. This is a read-only field.

Effective start date and Standard cost

Use the table to enter the standard cost of the item for the warehouse. You can use different standard costs for different date ranges:

• Effective start date:The date from which the cost on the row will be effective until the next effective date. The cost is used in the journal entries to debit Costs of Goods Sold and credit Inventory.

  Any postings before the first effective start date will use a cost of zero. The cost for the last effective start date is used for any postings after that date until a subsequent effective start date is entered.

• Standard cost: Enter zero or a positive number of up to 15 characters.

Enable for Contracts

Indicates the kit item can be used in the Contracts application. This field must be selected in order to use the kit item in Contracts.

When this field is selected, Intacct automatically sets Revenue posting to Component level and Print format to Kit. This means that revenue is tracked on the kit component items and invoicing is managed on the kit item. You cannot change these fields.

This field is only applicable if your company is subscribed to Contracts. Learn about kits in contracts.

Revenue posting

For a standard kit (the item type is Kit), select how you want revenue to post:

• Component level: Revenue is posted to the GL accounts associated with the items in the kit.
• Kit level: Revenue is posted to the GL account associated with the kit.

If Enable for Contracts is selected, this field defaults to Component level and cannot be changed.

Print format

For a standard kit (the item type is Kit), select whether you want the components to print out as individual items on the sales transaction or if you only want the kit to be listed.

If Enable for Contracts is selected, this field defaults to Kit and cannot be changed.

Item ID

Select the item ID for a kit component item.

If Enable for Contracts is selected, kit component items must have the following defined:

• Item type = Non-Inventory or Non-Inventory (Sales only)
• A valid Item GL group
• At least one default revenue template. All kit component items in a particular kit must have a default revenue template for the same journal. For example, if you are using two journals, all kit component items must have a default revenue template defined either only for journal 1, only for journal 2, or for both.

Item description

The Item description defaults from the selected kit component item. Edit the kit component item to edit the item description.

Allocation percent

Kits in Order Entry transactions

• If you are using Standard revenue recognition: the percentage of revenue to invoice for each kit component.
• If you are using Advanced revenue recognition: the percentage of revenue to recognize for each kit component.

Kits in Contracts

The percentage of revenue to recognize for each kit component item.

The following is the expected behavior for the Allocation percent value:

• The percent value will round to two decimal places. For example, if you enter 10.009, the percent used will be 10.01.
• You can use 0.00 for a kit component item.
• The total Allocation percent for all kit component items must = 100.00.

Number of units

Enter the quantity of the kit component item to include in the kit item. Defaults to 1.

This field is required.

Standard unit of measure

The unit of measure defined on the kit component item.

This field is read-only on the kit item.

Default delivery status

Options are:

• Delivered: The item's revenue recognition schedule will start on the applicable start date.
• Undelivered: The item's revenue recognition schedule will be on hold until the item is delivered.

This field is only applicable to companies that use event-based revenue recognition.

Default deferral status

If you are using event-based recognition for Order Entry:

• Defer until item is delivered: The revenue schedule for this item will be placed on hold until this item is delivered.
• Defer bundle until item is delivered: The revenue schedules for all items on the sales transaction will be placed on hold until this specific item is delivered.

If you are using event-based recognition for Contracts:

Options are:

• Defer revenue until item is delivered: the revenue schedule for this item will not start until this item has Delivery status = "Delivered".
• Defer revenue until all items are delivered: the revenue schedule for this item will not start until all contract lines in the contract have Delivery status = "Delivered".

Substitute item

If a requested item is out of stock, select the item to use as an acceptable substitute item.

Enable serial tracking

Select this checkbox to enable tracking by serial number.

Serial number mask

You can specify the format for the serial number. The serial numbers for the item or stockable kit must then conform to that mask.

Enable lot tracking

Select this checkbox to enable tracking by lot number.

Lot category

If you select lot tracking, then select the lot category to be tracked.

Enable bin tracking

Select this checkbox to enable tracking by bin number.

Enable expiration tracking

Select this checkbox to enable tracking by expiration date.

UPC

The Universal Product Code (UPC) assigned to the item.

Decimal places for unit cost: Inventory, Sales, and Purchasing

These values control item unit cost precision in transactions. This setting overrides the Default decimal place setting configured in Inventory Control, Order Entry, and Purchasing.

For example, an item with a unit cost of £0.00456 requires five decimal places. Depending on your needs, you can assign the item a different decimal precision to display in each application. You might want to enter 4 in Purchasing and Inventory and 2 in Sales.

While Intacct uses the number of decimal places specified here for the item in transactions, it rounds values to 10 decimal places for costing calculations, to 2 decimal places for the General Ledger, and to 2 decimal places for reports.

If your company is subscribed to Contracts, the value of Decimal places for unit cost - Sales must either be blank or 10. In this scenario, the best practice is to leave this field blank.

The Sales field is not available for supply items.

Enable distribution of landed costs to this item

Select this checkbox to have Sage Intacct distribute landed costs to this item. This field appears only for Inventory items (excluding supplies items).

Landed costs distribution table

Use this table to specify the count, volume, and weight of the item expressed in the base unit of the unit of measure (UOM) so a landed cost is distributed proportionately to the item when a landed cost is distributed across multiple items.

• Active: Select to have costs distributed to the item
• Distribution method: A read-only field that's Count, Volume, and Weight
• Value: The ratio multiplier that represents the item in the base unit of the given Distribution method.
  What to enter as a Value

  The value you enter depends on the unit of measure (UOM) for the item on the General tab. If the item's UOM:

  • Is the same as the distribution method, enter 1. The field defaults to 1 if it's left blank.
  • Is not the same as the distribution method, enter a number that represents the item in the base unit of the distribution method. For example, if the base unit for Weight is Ounce and the item weighs 1 pound, enter 16, which represents 1 pound in ounces (16 ounces in a pound x 1 pound = 16).
• Base unit: A read-only field that specifies the base unit for the Distribution method.

This field appears if Enable distribution of landed costs to this item is enabled.

Enable as a landed cost

Select this checkbox to identify the item as a landed cost. These items are used to enter the actual landed cost amounts (such as for shipping, insurance, and customs) for which you’re invoiced after purchasing inventory items.

This field appears only for Non-inventory and Non-inventory (purchase only) items.

Enable start and end dates

Select this checkbox to identify this item as having a default term. In Order Entry transactions, this also makes this item eligible for renewals and price proration. For Contracts, select this checkbox if you want to set up automatic price proration for this item. Learn more about prorating a contract line.

Periods measured in

Select the period of duration to use to measure the item's term. Options are: Days, Weeks, Months, or Years.

Number of periods

Enter the default number of periods to include in the item's term. For example, if Periods measured in is Months and Number of periods is 6, then the item's default term is 6 months.

Required if you selected the Enable start and end dates checkbox.

Allow prorated pricing

Select this checkbox if you want the system to automatically prorate the price when the sales transaction line or contract line term is less than the item's default term. For Order Entry, this field prorates the fair value in a multiple-element arrangement (when also subscribed to Advanced Revenue Management).

For Order Entry only, leave this checkbox cleared if you want the option to manually prorate the price using the prorate button in a sales transaction.

Default renewal template

Select the default renewal instruction set for this item in sales transactions.

This field only displays if the following conditions are met:

• The company is subscribed to Revenue Recognition for Order Entry.
• There is at least one transaction definition where Enable renewals = Generate.

This field is not applicable to the Contracts application.

Learn more about renewal templates for Order Entry.

Enable replenishment for this item

Select to include this item in the replenishment process, which suggests which items need to be reordered and enables purchase transactions to be automatically created.

The default value is the value of the Replenishment method default field on the Configure Inventory Control page.

Units of measure default

Enter the units of measure for these replenishment fields:

• Safety stock
• Maximum order quantity
• Reorder point
• Quantity to reorder
• The quantities in the fluctuating demand forecast for the item, if one exists
  

The default is the base unit of the item's UOM group. Learn more about units of measure.

Safety stock

Enter the extra quantity that you want to have in inventory to avoid stockouts. The default is 1. Valid values are 0 and positive integers.

Maximum order quantity

Enter the maximum quantity of this item to order. Sage Intacct might suggest a quantity to purchase that's a little more than the maximum so the quantity to purchase is a multiple of the economic order quantity.

The default is blank, which means there's no maximum order quantity. Valid values are blank and positive integers.

Replenishment method

The replenishment method determines what's included in the calculations used to determine when to suggest reordering the item for the warehouse, from which suppliers, and the quantity to purchase:

• Demand forecast by single value: Includes the forecasted demand of the item during supplier lead time. A single value that you enter for each supplier in the Supplier entries table represents the demand. This method is useful when demand for the item is stable during the year.
• Demand forecast by fluctuating values: Includes the forecasted demand of the item during supplier lead time. The replenishment fluctuating demand forecast for the item includes entries for the expected quantities needed on each given date regardless of supplier. The sum of the forecast quantities with dates during the time period between the As of date plus the supplier's lead time represents the demand during supplier lead time. This method is useful when demand for items fluctuates greatly during the year, such as for highly seasonal items.
• Reorder point: Does not include any forecasted demand of the item during supplier lead time. Intacct uses the quantity for the reorder point as a starting point to determine when items need to be reordered.

Learn more about the replenishment methods and calculations.

Add forecast and View fluctuating forecast

These buttons appear if the replenishment method on the Supplier history tab or for one of the item-warehouse combinations in the Warehouse section on the General tab is Demand forecast by fluctuating values:

• Add forecast: The item does not have a fluctuating demand forecast. Select the button to create one.
• View fluctuating forecast: The item has a fluctuating demand forecast. Select the button to edit it.

Reorder point

Enter the quantity of inventory of the item that you do not want the item to fall below. When the current net inventory falls to the reorder point plus the safety stock, the item is triggered for reorder. The default is 1. Valid values are blank and positive integers.

This field appears if the replenishment method is Reorder point.

Quantity to reorder

Enter the quantity to reorder when the item needs reordering. The default is 1. Valid values are blank, 0, and positive integers. If you leave the field blank, Intacct uses a value of 0.

In the calculations, the Quantity to reorder is rounded up to be a quantity that's a multiple of the economic order quantity. So, Intacct might suggest ordering a little more than quantity you enter. The user can always override the suggested Quantity to purchase on the Replenish Inventory page to be the Quantity to reorder.

This field appears if the replenishment method is Reorder point.

Preferred supplier

Select the checkbox to identify this supplier as the preferred supplier for replenishing this item for warehouses that do not have specific suppliers specified. On the Replenish Inventory page, when Preferred supplier is selected as the Supplier ordering option, this supplier and related pricing is displayed on the main line for the item if it needs reordering to streamline the replenishment process. If the item can also be purchased from other suppliers, the user can select another supplier from the Supplier name dropdown before generating the purchase orders.

You can select only one preferred supplier. If you do not select a preferred supplier, the first supplier listed in the table is automatically selected as the preferred supplier when you save the item.

Supplier ID

Enter or select the supplier ID.

Stock number

Enter the stock number the supplier uses for this item. You can enter up to 50 characters.

Lead time (days)

Enter the number of days it takes the supplier to deliver this item to you after receiving the order. The default is the Lead time default (days) from the supplier record. Valid values are blank, 0 and positive integers.

Demand forecast during lead time

Enter the quantity of this item that's expected to be sold during the lead time. The default is blank. Valid values are blank, 0, and positive integers.

This field appears if the replenishment method is Demand forecast by single value.

Economic order quantity

Enter the quantity that makes the cost of reordering this item the most economical. The default is 1. Valid values are blank, 0, and positive integers.

Supplier minimum order qty

Enter the minimum quantity of this item the supplier is willing to sell. The default is 1. Valid values are blank, 0, and positive integers.

Units of measure

The units of measure the supplier sells this item in. For example, the supplier might sell in dozens instead of each. The default is the base unit of the item's UOM group.

Best cost

The lowest price that you paid for the item. The is a read-only field.

Last unit cost

The most recent price that you paid for the item. This is a read-only field.

Supplier ID

Enter or select the supplier ID.

Stock number

Enter the stock number the supplier uses for this item. You can enter up to 50 characters.

Lead time (days)

Enter the number of days it takes the supplier to deliver this item to you after receiving the order. You can enter up to 3 characters.

Economic order quantity

Enter the quantity that makes the cost of reordering this item the most economical.

Best cost

The lowest price that you paid for this item. This field is read-only.

Last unit cost

The most recent price that you paid for the item. This is a read-only field.

Reference type

Whether the cross reference is for a:

• Customer, for a customer's item tracking number.
• Supplier, for a supplier's tracking number.
• Substitute, an alternate item.
• Upgrade, a higher value item.
• Downgrade, a lesser value item.
• Complement, an item you might want to sell with the ordered item.

Alternate item ID

The item in your Sage Intacct company that will be an alternate item for Item ID.

Customer ID

The customer to create the cross reference for. This field is active only if the reference type is Customer.

Supplier ID

The vendor to create the cross reference for. This field is active only if the reference type is Supplier.

Cross-reference item ID

The identifier that the customer or vendor uses in their company to refer to the item. This field is active only if the reference type is Customer or Supplier.

Cross-reference item description

A description for the cross-reference item. This field is active only if the reference type is Customer or Supplier.

Unit

The unit for the cross-reference item. The selectable values are the units that are defined for the item's UOM group. For example: Each, Pair, or Dozen

Primary country of origin

The country that provides the greatest percentage of the components for the item. For example: CHINA 75%

Condition

A condition name or descriptor for the item.

Engineering alert

An Engineering alert name or descriptor for the item.

Specification 1

The first specification name or descriptor for the item.

Specification 2

A second specification name or descriptor for the item.

Specification 3

A third specification name or descriptor for the item.

UPC-12

The Universal Product Code for the item (12-numeric digits). Use this field for new UPC entries. Do not use the UPC field on the Advanced tab.

EAN-13

The European Article Number for the item(13-numeric digits).

Safety item

Whether the item is classified as a safety item.

Restricted item

Whether the item is classified as a restricted item.

Compliant item

Whether the item has passed a complianc test or requires one.

Engineering approval

Whether the item has been approved by Engineering or requires one.

Quality control approval

Whether the item has been approved by Quality Control or requires one.

Sales approval

Whether the item has been approved by Sales or requires one.

UOM for weight

The unit of measure (UOM) for the Net weight field.

Net weight

The actual weight of the base item only.

UOM for length, width, and height

Unit of measure (UOM) for the Length, Width, and Height fields.

Length

The length of the item.

Width

The width of the item.

Height

The height of the item.

UOM for volume

The unit of measure (UOM) for the Volume field:

Volume

The volume of the item.

UOM for thickness

The unit of measure (UOM) for the thickness fields.

Thickness

The thickness of the item. The value must be equal to or less than Maximum thickness or equal to Minimum thickness.

Minimum thickness

The minimum thickness of the item. The value must be equal to or less than Thickness.

Maximum thickness

The maximum thickness of the item. The value must be equal to or greater than Minimum thickness and Thickness.

UOM for area

The unit of measure (UOM) for the Area field.

Area

The area of the item.

UOM for diameter

The unit of measure (UOM) for the diameter fields.

Inner diameter

The inner diameter of the item.

Outer diameter

The outer diameter of the item.

UOM for density

Enter the unit of measure (UOM) for the Density field. This is a text field that has no validation.

Density

A decimal value for the density of the item. The value is expressed in the unit of measure entered in the UOM for density field.

Durometer

The hardness value of the item.

Brand

The brand for the item.

Sub brand

The sub brand for the item.

Catalog reference

The catalog reference for the item.

Category

The category for the item.

Sub category

The subcategory for the item.

Color

The color of the item.

Size 1

The first size of the item.

Size 2

The second size of the item.

Style

The style for the item.

Gift card

The item is a gift card.

Web enabled

Whether the item is sold on the Web.

Web name

Name of the item on the Web

Web short description

A short description for the item. You can enter up to 1,000 characters.

Web long description

A long description for the item. You can enter up to 2,000 characters

Warehouse

ID and name of the warehouse.

Serial number

The serial number, if the item is tracked by serial number.

Lot number

The lot number, if the item is tracked by lot.

Expiration date

The expiration date, if the item is tracked by expiration date.

Bin

The bin, if the item is tracked by bin.

Date received

This column displays for serial tracked items. The date the on hand quantity was increased.

Quantity on hand

The quantity that's on hand for the warehouse and the combination of tracking attributes.

Document ID

The document number for the transaction. Select the link in this column to open the transaction in a separate browser window.

Order date

The date of the transaction.

Customer name

The customer ID and name.

Ship to

The ship-to contact from the transaction line. If there is not one, the value is the ship-to contact from the transaction header.

Warehouse

The warehouse from the transaction line.

Reference number

The reference number from the transaction header.

State

The workflow status of the transaction.

Original qty ordered

The quantity of the item that was ordered.

Qty reserved

For sales transactions, the quantity of the item that's been reserved for the transaction. Reserved quantity is considered to still be on the warehouse shelves but not available to be used anywhere else.

Qty allocated

For sales transactions, the quantity of the item that's been assigned to the transaction. Allocated quantity is considered to be picked from the warehouse shelves, dedicated to this transaction, and not available to be used anywhere else.

Shipped

The quantity of the item that's been shipped if the transaction line has been partially converted to a transaction that decreases the quantity on hand.

On hold

The quantity of the item that's on hold for the transaction, assuming the transaction increases the ONHOLD quantity. Unless the line has been partially converted to a transaction that decreases the quantity on hand, the value is the same as the quantity ordered.

Ship date

The ship date from the transaction line. If there is not one, the value is the ship date from the transaction header.

Customer PO number

For sales transactions, the purchase order number given by the customer. The value is from the transaction header.

Drop ship

For sales transactions, whether the line for the item is marked as drop ship.

Buy to order

For sales transactions, whether the line for the item is marked as buy to order.

PO doc ID

If the line for the item is marked as drop ship or buy to order, the document number for the associated purchase transaction. Select the link in this column to open the purchase transaction in a separate browser window.

Document ID

The document number for the transaction. Select the link in this column to open the transaction in a separate browser window.

Order date

The date of the transaction.

Supplier name

The supplier ID and name.

Warehouse

The warehouse from the transaction line.

Reference number

The reference number from the transaction header.

State

The workflow status of the transaction.

Original qty ordered

The quantity of the item ordered.

Received

The quantity of the item that has been received if the transaction line has been partially converted to a transaction that increases the quantity on hand.

On order

The quantity of the item that's on order for the transaction, assuming the transaction increases the ONORDER quantity. Unless the line has been partially converted to a transaction that increases the quantity on hand, the value is the same as the quantity ordered.

transaction

Due date

The due date from the transaction line. If there is not one, the value is the ship date from the transaction header.

Drop ship

If the transaction line was generated for a sales transaction marked as drop ship.

Buy to order

If the transaction line was generated for a sales transaction marked as buy to order.

OE doc ID

If the transaction line was generated for a sale transaction marked as drop ship or buy to order, the document number for the associated sales transaction. Select the link in this column to open the sales transaction in a separate browser window.

Transfer out doc ID

The document identifier for the system-generated transfer-out transaction.

Transfer doc date

The date the warehouse transfer was created.

Transfer out date

The transfer out date from the warehouse transfer.

Transfer in doc ID

The document identifier for the system-generated transfer-in transaction.

Est transfer in date

The estimated transfer in date from the warehouse transfer.

From warehouse

The source warehouse from the warehouse transfer, the warehouse the item is being transferred from.

To warehouse

The destination from the warehouse transfer, the warehouse the item is being transferred to.

Description

The description from the warehouse transfer.

Reference number

The reference number from the warehouse transfer.

State

The state of the warehouse transfer, which is In transit.

In transit quantity

The quantity of the item currently being moved or shipped from the source warehouse to the destination warehouse.