Version: eXtendCOIA 1.0.1 and above
Audience: User

Overview

eXtendCOIA provides a process for automatically placing customer-owned inventory in a NetSuite Location specifically designated for prepurchase customer inventory. This is accomplished through an automatic inventory adjustment.

Usage

You can trigger the customer-owned inventory adjustment (COIA) process by following the transaction flow below.

COIA Process

  1. Start a new sales order record.
  2. Set the EXTENDTECH COIA INVENTORY OWNER line item field to the inventory owner for each of the line items which is customer-owned. Typically, this field will be defaulted on the item record itself and source its value to the line item(s) without requiring user interaction.
    Image Placeholder
  3. Enable the IS EXTENDTECH COIA CUSTOMER OWNED INVENTORY? checkbox to mark the sales order as a customer-owned inventory order. This flag will trigger eXtendCOIA to create an inventory adjustment record when the sales order is fulfilled. 
    Image Placeholder 
  4. Receive the items on the linked special order purchase order.
  5. Create an item fulfillment, and specify the item quantities which are being fulfilled.Image Placeholder
  6. Upon saving the item fulfillment, the item fulfillment record will be generated for the specified item quantities, and the number of items specified will be marked as fulfilled on associated sales order.
    For COIA item fulfillment, quantities should be in the full order quantity for billing and for conversion to customer-owned inventory.
  7. After saving the item fulfillment record, an inventory adjustment record with a value of $0 will be automatically created. This record will reflect the quantity of items specified as fulfilled on the item fulfillment, and their quantities will be placed in your COIA adjustment location.
    If you specify a COIA Preferred Bin on the item record, it will override the Inventory Adjustment Bin Number specified on the COIA Setup page. For more information on bin selection, please contact your NetSuite Administrator.
    Image Placeholder
    The inventory adjustment record will contain a link to the item fulfillment which it was created from in the EXTENDTECH COIA ITEM SHIPMENT field.
    Image Placeholder

Disable COIA Process for a Sales Order

You may enable or disable the COIA process on a sales order based on the IS EXTENDTECH COIA CUSTOMER OWNED INVENTORY? checkbox. If checked, the inventory adjustment process will be processed (if the line item has an associated EXTENDTECH COIA INVENTORY OWNER defined). eXtendTech recommends using a custom sales order form specifically for COIA sales orders. This ensures that the default is in place without requiring user interaction.Image Placeholder

Frequently Asked Questions (FAQs)

Q: Are there any exceptions to the COIA process?
A: Yes, inventory adjustments will not be created for items fulfilled as Drop Ship items.

Q: What happens if an item doesn't have a COIA Preferred Bin assigned?
A: If an item does not have a COIA Preferred Bin assigned to it, the default Inventory Adjustment Bin Number from the COIA Setup page will be used.

Q: Is the Inventory Adjustment Bin Number field always visible?
A: No, the Inventory Adjustment Bin Number field will only be displayed if your NetSuite account has the Advanced Bin Management feature enabled.