Accounting Services
Icon-14-2
Outsourced Accounting

Expertly trained accountants with a deep understanding of the software and your industry,

Icon-15-1
Family Office Accounting

High-touch technology family office accounting services that ensure security and privacy.

Icon-16-1
Bill Pay

Outsourced bill pay solution with cash flow reporting and tracked expenses.

RESOURCE CENTER
What Are Outsourced Accounting Services and Do I Need Them?

If you are asking yourself these two questions, you've come to the right place.

What’s the Difference Between CFO and a Controller - and What Do I Need?

Although these two important roles are sometimes viewed as interchangeable there are important differences between them.

Industry Expertise
Icon-17-1
Our Key Industries

Expert knowledge and high-quality software solutions for our 5 key industries.

Icon-18-1
Construction & Real Estate

Real-time financial data and integrated job costing to generate reports and improve accountability.

Icon-19
Manufacturing & Distribution

Track billing of materials, implement inventory control systems, manage supplier base, and reduce unnecessary costs.

Icon-20
E-Commerce

Our team has the expertise needed to navigate deposits, refunds, chargebacks, and processing fees to maximize efficiency.

Icon-21
Professional Services

Streamline financial operation and increase overall profitability to enable faster and smarter decisions.

Icon-15-1
Family Office Accounting

High-touch technology family office accounting services that ensure security and privacy.

RESOURCE CENTER
Why does industry expertise matter?

Industry focus allows us to be experts in the accounting needs of the companies that operate within these industries.

Why Plumb Works With These Industries

This is another one of our favorite questions. The answer is easy: we know these industries.

Software Expertise
Icon-22
Sage Software

Innovative software to manage your accounting, people, payroll, payments, and more.

Icon-23
NetSuite Software

Integrated cloud business software suite, including business accounting, ERP, CRM and ecommerce software.

Icon-24
QuickBooks Software

Scalable solutions for reporting, transactions, month-end close, analysis, and more.

RESOURCE CENTER
QuickBooks to NetSuite Migration: A Comprehensive Guide

Migrating from one accounting software platform to another is a critical undertaking for businesses. This is especially true when considering a transition from QuickBooks to NetSuite.

How do I know which Software is right for my company?

Selecting the "right" software for your company might seem like an overwhelming task, but we'd like to help make this process easier for you.

Sage
Icon-262
Sage Software

Innovative software to manage your accounting, people, payroll, payments, and more.

Icon-26
Sage Intacct

Automate the critical processes, reduce the spreadsheet headaches, and get greater visibility into real-time business performance.

Icon-27
Sage 300 CRE

Sage 300 Construction & Real Estate connects finances and operations to help ensure maximum profit.

Icon-28
Sage 100 Contractor

The all-in-one construction software that goes beyond basic accounting to put you in total command of your projects.

Icon-29
Sage Estimating

Build bids quickly and precisely, plus integrate with other Sage software solutions to streamline operations.

Plumb_Icon-119
Sage Paperless

Easily store, retrieve, and route documents for accounting and operations.

Icon-30
Sage Service

Streamline service calls and construction projects from start to finish with web-based real-time information.

Icon-31
Additional Solutions

Add-on these services to improve workflow and enhance data and analytics.

RESOURCE CENTER
How and When to Choose Construction Accounting Software?

The right tools can help you manage your construction projects efficiently, provide clarity of your finances, and ultimately help improve profitability and job success.

5 Types of Visibility Every Construction Firm Should Have.

Here we list 5 key elements to help capture insights that are pivotal to running an efficient and lucrative constriction firm.

ABOUT
Icon-32-1
About Plumb

Plumb seeks to empower business owners and leaders to gain clarity about their financials to grow their business.

Icon-33-1
Case Studies

Learn more about our work with clients in a variety of different industries.

Icon-34-1
Meet the Team

Learn more about the Plumb leadership team.

Icon-35-1
The Plumb Promise

Icon-36-1
Careers

Want to join us? Check out our current open positions and apply today.

RESOURCE CENTER
What can Plumb Do for Your Business?

At Plumb we pride ourselves on providing "clarity in accounting and stewardship in service." But what does that actually mean?

What's the Plumb Promise and What's in it for You?

We're on a continuous journey to go above and beyond for our clients. Here's how we do that.

How to Handle Assemblies in NetSuite for Outsourced Manufacturing

Posted on December 21, 2021 at 7:53 PM
Written by Justin Atneyel

NetSuite Tips & Tricks

How to handle assemblies in NetSuite for outsourced manufacturing

Want to learn how to handle assemblies in NetSuite for outsourced manufacturing?

Many companies use third-party manufacturing companies to build their finished goods from raw materials owned by the company. With the use of the NetSuite manufacturing module (that includes features such as Assembly Items and Work Orders), your organization can achieve proper inventory control and costing even when an outside organization creates the finished good.

Need additional accounting help with your NetSuite software?  Plumb specializes in outsourced accounting services and accounting help for NetSuite users.


The basic process flow is this:

  • Company has inventory of raw materials on hand
  • An Assembly Item/Bill of Materials exists that defines the finished good.
  • A “Vendor Consigned Inventory” location exists within NetSuite and has the “Make Inventory Available” flag set to checked
  • A Vendor Bill is created to capture the cost of shipping raw materials to the vendor so that those costs can be factored into finished good
  • Company creates a Transfer Order to transfer inventory of raw materials to Vendor Consigned Inventory location
  • Typically the finished goods are sent to the company with a bill for the manufacturing service, shipping, etc. With the quantity of finished goods known, the company performs an Assembly Build (standalone or via a Work Order) to replenish inventory in the amount of the received finished goods and deplete inventory of the component, raw materials items. Since the location of the raw materials is in “Vendor Consigned Inventory”, the Assembly Build will be created within that location.
  • Once the Assembly Build is complete, any additional vendor bills for any freight-in charges must also be entered before the final transfer from “Vendor Consigned Inventory” to the physical warehouse location. This is to ensure that landed costs are reflected accurately in the item.
  • Another Transfer Order is created to move inventory and current costs from “Vendor Consigned Inventory” to the physical inventory location.

1. Establish Raw Material (Component) Item “On Hand” Quantities

Use a Purchase Order –> Item Receipt or a Vendor Bill to bring in inventory of the Raw Materials into the physical inventory location

2. Create Assembly Item/Bill of Materials (BOM) for the Finished Good

Include all component items with quantities and unit of measure

3. Create a Vendor Bill for the Transfer Shipping Charges (HQ to Manufacturer)

When creating the vendor bill, if you use Landed Costs (recommended), make sure on the line items of the bill to call out the Landed Cost Category so that those costs can be allocated to the item properly.

* Note that when using Transfer Orders when you want to items costs to be included in the Transfer Order, the preference to “Use Item Cost as Transfer Cost” must be enabled. This feature is enabled via Setup –> Accounting –> Accounting Preferences –> Order Management –> Transfer Orders.

4. Transfer Components to Vendor (Consignment) Warehouse

  • Create Transfer Order 
    • Input component items to transfer
    • Enter quantities to transfer
    • Enter the Lot # of the items to transfer, if your components are Lot-Numbered inventory items
    • Save the Transfer Order
  • Approve the Transfer Order

  • Fulfill Transfer Order (ship items to the manufacturing company) 
    • Select items to be transferred
    • Enter shipping info, if necessary but do not enter shipping cost if you are tracking landed costs
    • Save. The items (and costs) are moved from inventory asset account to Inventory In Transit account
  • Receive Transfer Order (items are received in the manufacturing facility location) 
    • Select items to be received
    • For tracking landed costs, use the Landed Cost subtab (or line item landed cost checkbox) to enter the shipping costs
    • Select the desired cost allocation method (weight, value, or quantity)
    • For the Landed Cost Categories applicable from your Vendor Bill (in this example, Freight) under “Source” choose “Other Transaction” and in the drop-down menu that appears, search for the Vendor Bill containing the freight charges.
      * Note that your Vendor Bill must have a Reference Number or Memo or the vendor bill will not be clickable in the list that appears
    • Save the Transfer Order Item Receipt. Items are moved from Inventory In Transit and Freight expense accounts to Inventory Consignment asset location

5. Perform Assembly Build

Create and process the assembly build within the “Vendor Consigned Inventory” location

6. Enter Vendor PO and Bill for Manufacturing and return freight

When the manufacturer send the finished goods back to your company, you will at the same time receive their bill. Their bill can include freight, or you may have used your own account within the shipping company, in which you will get a separate bill for the freight. On the Item Receipt (or the subsequent Vendor Bill) you will want to apply any service, shipping, or tax vendor bills as Landed Costs on the receipt so that the landed costs can be allocated to the received goods.

7. Transfer Finished Goods back to the Physical Inventory Fulfillment Location

At this point you have finished goods still in the “Vendor Consigned Inventory” location however you should move this inventory over to the fulfillment location which is where you will be fulfilling orders from. You will use a Transfer Order to perform this.

  • Create a new Transfer Order
  • Enter the finished goods/Assembly items to transfer, along with quantities and lot information if you are using Lot-Numbered Assembly Items
  • Save the Transfer Order
  • Approve the Transfer Order
  • Fulfill the Transfer Order
  • Receive the Transfer Order (this final step is what actually moves the inventory over)
  • On the Item Receipt, use the Landed Cost subtab to apply any of the costs from Step 6 onto the receipt of the finished goods

Plumb provides outsourced accounting services for companies using NetSuite.

Read more blog posts

The 8 Most Important KPIs for a Manufacturing Business

Key Performance Indicators (KPIs) are crucial metrics that help...

Why Does Industry Expertise Matter?

We love this question, because it really gets to the heart of who we...

Why Plumb Works With These Industries

This is another one of our favorite questions. The answer is easy: we...

Sign up now:

Receive actionable business and accounting insights directly to your inbox.

Submitting this form subscribes you to emails from Plumb. View our privacy policy.