Skip to main content

Create Records From Another Transaction

Many NetSuite records are created from another transaction: an item fulfillment from a sales order, a vendor bill from a purchase order, a work order issue from a work order. A bulk record sheet does the same when you fill in the record's Created From cell. This page explains how it works and how to set up each kind of record.

How It Works

  1. On a new record (blank Internal ID), fill in Created From with the source transaction. Pick it from the dropdown, for example Sales Order #SO2528, or type its internal ID (115258 or id_115258) or its document number (SO2528). Deposit Applications use the Deposit column and Vendor Prepayment Applications use the Vendor Prepayment column instead.
  2. On upload, Finsyte asks NetSuite to build the new record from the source, the same as selecting Fulfill, Bill, Receive, and so on, on the source record in NetSuite.
  3. The new record is linked to the source. The source itself is not edited, but NetSuite updates its status, as it does when you work in NetSuite. For example, creating the invoice for a fulfilled sales order moves the order from Pending Billing to Billed.

After the upload, the rows are rewritten from the new record, as for any create. Editing the record later is a normal update: change the cells and upload again.

A fulfillment created from a sales order

Remarks

  • A record is built from its source only when it is created. A row with an Internal ID is a record that already exists, and the upload updates it like any other record.
  • The Created From dropdown lists the most common source type. For another type, such as a transfer order on an item receipt, enter its internal ID or document number.
  • The new record takes its Customer or Vendor and Subsidiary from the source. You can leave those cells blank. If they are filled in, they must match the source; a different value is flagged with A record created from another transaction keeps that transaction's ….
  • If the source can't be found, or more than one transaction has that number, the Created From cell is flagged and that record is skipped. The rest of the sheet still uploads.
  • Created From builds a record from its source only for the pairs listed on this page. If the source is found but the pair is not listed, for example a credit memo with a sales order in Created From, Finsyte creates an ordinary new record and includes the Created From value as one of its fields. The source is not changed, and NetSuite may ignore the value, so the new record may not show the link.

Which Source Line Each Row Is

When NetSuite fulfills, receives, or bills a transaction, each line of the new record is tied to one line of the source. That's how the source is updated, for example the quantity fulfilled on a sales order line. So for the records in Fulfill and Receive and Bill and Credit From an Order, Finsyte needs to know which source line each row is for. Usually it works this out for you:

  • Finsyte looks for the row's Item among the source's open lines, the lines not yet fully fulfilled, received, or billed. If one open line has that item, the row is for that line.
  • If several open lines have the item, Finsyte uses the one at the row's Location. On bills, invoices, and other billing records, it also prefers a line that isn't fully billed yet.
  • If it still can't tell, it flags the row's Item cell with This item is on more than one open line of the source transaction (lines …). Add the Order Line column (in the Items group) to the template, create a new sheet, and enter one of the line numbers from the message. These are the source's line IDs, the same numbers shown in Items: Line ID when the source is downloaded on a bulk record sheet. On a work order issue, completion, or assembly build, use the Line Number column in the Component group instead. See Work Orders.

Each source line can be used by only one line of the new record. To split a line across lots, bins, or statuses, keep it as one line and give it several Inventory Assignment rows.

Fulfill and Receive

RecordCreated from
Item FulfillmentSales Order, Transfer Order, Vendor Return Authorization
Item ReceiptPurchase Order, Transfer Order, Return Authorization

Template columns: Created From and Date; on the item lines Item, Quantity, and Location; and the Inventory Assignment columns when the items use lots, serial numbers, bins, or statuses. Optional: Order Line, Fulfill or Receive, Ship Status (fulfillments).

  • Only the rows on the sheet are fulfilled or received. Every other open line of the source is sent as not fulfilled, so nothing ships or arrives by accident. To fulfill part of a line, enter the partial quantity in Quantity.
  • Inventory detail: a lot-numbered or serialized item needs its numbers in the Inventory Assignment columns. At locations that use inventory statuses, a plain item needs a status row too (Inventory Status and Quantity). Without them NetSuite rejects the line with Please configure the inventory detail in line N.
  • Shipped: set Ship Status to Shipped to save a fulfillment as shipped; otherwise it is saved as Picked. Invoices, cash sales, and transfer order receipts need the fulfillment to be shipped first.
  • Carrier shipping methods: when an order or transfer order has a UPS or FedEx shipping method, set up that carrier in NetSuite to mark it Shipped. Otherwise clear the order's Ship Via, or leave the fulfillment as Picked.
  • Transfer orders: the fulfillment ships from the transfer order's From Location, and the receipt receives at its To Location. Ship a line before you receive it. For Order Line, use the transfer order's line number as downloaded.
  • Returns: approve the return authorization before receiving it, in NetSuite or by uploading Order Status = Pending Receipt on the return's own sheet.

Bill and Credit From an Order

RecordCreated from
Vendor BillPurchase Order
InvoiceSales Order
Cash SaleSales Order
Return AuthorizationSales Order, Cash Sale
Credit MemoInvoice, Return Authorization
Cash RefundCash Sale, Return Authorization
Vendor Return AuthorizationPurchase Order

Template columns: Created From and Date; item lines with Item and Quantity, plus Rate if it differs from the source. Optional: Order Line.

  • The new record has exactly the sheet's lines, each linked to its source line. Leave a line off the sheet to leave it unbilled.
  • No item rows at all: NetSuite copies every open line of the source.
  • Other sublists: if the sheet has rows for another sublist, such as Expenses, the new record's lines for that sublist are exactly those rows. If it has none, the source's lines for that sublist are copied.
  • Order of steps: fulfill and ship a sales order before you invoice it, sell it on a cash sale, or return it. Receive a return before you refund it.
  • Cash sale: to turn an order into a cash sale, set the sales order's payment method first. Without one, NetSuite only allows an invoice and answers That is not a valid record transformation.
  • Cash refund from a return: fill in Account, the bank account the refund is paid from.
  • Vendor return from a purchase order: fill in each line's Target Subsidiary and Target Location with the purchase order's subsidiary and location.
  • Approve at creation: a return authorization or vendor return authorization can be created approved by filling Order Status with Pending Receipt or Pending Return.

From a Quote, Bill, or Requisition

RecordCreated from
Sales Order, Invoice, Cash SaleEstimate (Quote)
Vendor CreditVendor Bill, Vendor Return Authorization
Purchase OrderPurchase Requisition

These records are linked to the source as a whole; their lines are ordinary lines.

  • Fill in Item, Quantity, and Rate on each row. Order Line is not used.
  • The new record has exactly the sheet's lines. With no item rows, every source line is copied.
  • Requisition to purchase order: the vendor comes from the requisition's lines. Set Vendor on each requisition line first and leave the purchase order's Vendor cell blank; a filled Vendor is flagged.
  • Quote to cash sale: set the payment method on the sheet.

Work Orders

RecordCreated from
Work Order Issue, Work Order Completion, Work Order Close, Assembly BuildWork Order
Assembly UnbuildAssembly Build

Template columns: Created From and Date; the Component group's item and quantity for component rows (on an assembly build, NetSuite names them Assembly and Quantity to Build); and, for a work order issue, completion, or build, the Inventory Assignment columns when components or the assembly use lots, serial numbers, or bins. Optional: Line Number (Component group).

Work order issues, completions, and assembly builds upload their component rows, one row per component. Each row is matched to a component of the work order by its item. When the same item is on more than one line of the work order, add the Line Number column (in the Component group) to the template, create a new sheet, and enter the work order's line number for that component.

  • Work Order Issue: only the components on the sheet are issued. Components left off the sheet are sent with quantity 0. A work order issue with no component rows at all issues every component in full, the same as issuing from the work order in NetSuite.
  • Work Order Completion (work orders that use WIP): Quantity and Completed Quantity. A work order that uses a routing also needs Start Operation and End Operation. Their dropdowns show each operation as Title (id). A lot-numbered or serialized assembly, or a location that uses bins, also needs the assembly's inventory detail.
  • Assembly Build: Quantity, plus the assembly's inventory detail for a lot-numbered or serialized assembly or a location that uses bins. Components left off the sheet are consumed in full, at their bill of materials quantities. Add component rows only for components that need a lot, a bin, or a different quantity.
  • Assembly Build without a work order (Created From left blank): NetSuite starts from the assembly's bill of materials. Each component row is matched to its bill of materials line by item, and a component that isn't on the bill of materials can't be added. Components not on the sheet keep their bill of materials quantity.
  • Assembly Unbuild: Quantity only. Leave the assembly's Inventory Assignment columns off the template; NetSuite copies the inventory detail from the build and rejects one sent with the upload.
  • Work Order Close: Created From and Date are enough.

These messages appear on component rows when you upload:

WhereMessageWhat to do
Item cellThis item is on more than one open line of the source transaction (lines …). Add the Line Number column…Add the Line Number column and enter the work order's line number for this component.
Item cellThis item is not an open component of the work order.Check the component against the work order.
Line Number cellLine Number N is not a line of the source transaction.Check the number against the work order.

Deposits and Prepayments

  • Deposit Application: fill in Deposit (the customer deposit) and the Apply rows (the invoice and the amount).
  • Vendor Prepayment Application: fill in Vendor Prepayment, Account (the A/P account of the bills, for example Accounts Payable), and the Apply rows (the bill and the amount). Without Account, NetSuite lists no bills and answers You must enter at least one line item.
  • Customer Refund is an ordinary new record: fill in Customer, Account, and the Deposit or Apply rows for the deposit or payment being refunded.

Messages

The source transaction is checked when you upload, so these messages appear then, not when you run Validate Sheet. The rest of the sheet still uploads.

WhereMessageWhat to do
Item cellThis item is on more than one open line of the source transaction (lines …). Add the Order Line column…Add the Order Line column and fill in the source's line number.
Item cellThis item is not an open line of the source transaction (or another row already uses that line).The line is fully fulfilled, received, or billed, is closed, or isn't on the source.
Order Line cellOrder Line N is not a line of the source transaction.Check the number against the source.
Vendor cell (purchase order)Leave Vendor blank: a purchase order created from a requisition takes its vendor from the requisition's lines…Clear Vendor and set the vendor on the requisition's lines.
Created From cell'…' was not found. Use the transaction's Internal ID or pick it from the dropdown. or More than one transaction is numbered '…'. Use the transaction's Internal ID.Use the source's internal ID.
Customer, Vendor, or Subsidiary cellA record created from another transaction keeps that transaction's …Clear the cell or use the source's value.
StatusYou can not initialize …: invalid reference …The source isn't ready yet: not approved, not shipped, or not received.
Status… invalid sublist or line item operation … static sublistA line named on the sheet isn't on the new record. Check Order Line.

Records the add-in can't prepare show Error: Skipped due to validation errors in the Status column; the flagged cell's note gives the reason.

Next step: Example: Invoices Start to Finish