QuickBooks Inventory Management Software | Acctivate

QuickBooks Inventory Management Software

  • Home
  • Solutions
  • Explore
  • Support
  • Contact
  • Free Trial
  • Onboarding
  • Training
  • Downloads
  • Documentation
  • Knowledge Base
 

Manage Product Components

For products requiring a component list, a Bill of Materials type must be selected. Acctivate supports a variety of manufacturing options, including assemblies (build for stock), kits (build to order), and assortments (matrix).
IN THIS ARTICLE
 •  Add Components
 •  Update Components
 •  Import Components

The following Bill of Materials choices are available.

  • Assembly (Standard): An inventoried item created by combining one or more components from raw materials into a finished good. The list of components is static. This requires an inventory assembly session to be posted.
  • Assembly (Custom): Same as Assembly (Standard), but with the option of marking components as variable and entering actual quantity used. This also allows the user to modify the components used on the assembly session itself without updating the standard list.
  • Assembly (Process): Same as Assembly (Custom), but with the option of specifying a different yield from the build quantity on the assembly session. When modifying the yield, the actual quantity used for components marked as variable will remain the same while non-variable components will fluctuate.
  • Kit (Standard): A non-inventoried item created by combining one or more components from your warehouse based on customer orders (build to order or just in time stock). The list of components is static. No additional inventory transaction required to build the item.
  • Kit (Custom): Same as Kit (Standard) with the additional option of variability in the components. Users can add and remove components, as well as adjust the Component Quantities for a single Sales Order.
  • Assortment: Allows the ability to add a list of components for each option available in this matrix. This is typically used in the garment/shoe industry. The customer orders 100 pairs of shoes and the user entering the order can specify how many of each size and/or style need to be fulfilled.

Depending on the package purchased, some of these may be add-on modules. Contact your sales rep to purchase new modules, if needed.

Adding Components to a Product

  1. Follow the instructions listed here to create new products or select and Edit the product needing to be updated to enable components.
  2. In the Bill of Materials field, select the proper option from the list above.
  3. To assign component, click the Components / Assortment tab.
  4. Type the sequence number in the # field to set the sort order of the components on the assembly transaction.
  5. Type the Product ID followed by tab or use the lookup to select the component from a list.
  6. Choose the default Warehouse you need this component to be pulled from on the session. Users can change when needed on the transaction.
  7. Specify the component Quantity. This is the quantity used of this component to build one unit.
  8. If Custom or Process BOM type, check the Variable box for any non-static component.
  9. Repeat these steps 4-8 for each additional component that needs to be added.
  10. When all the products have been added to the component list, click the Save button.


Product Component List

Update Existing Component Lists on Product Window

Any changes made to these items will be reflected in new transactions. This will not update existing transactions.

  1. Navigate to the product needing to be updated:
    1. Product List > Search and select > Edit.
    2. Inventory > Edit Product > Type ID followed by tab or look up and select from a list > click Edit.
    3. Product icon > Type product ID followed by tab or lookup and select from a list > Edit.
  2. Select Components tab.
  3. Make updates to list:
    1. Override sequence # to reset the order of components shown on assembly transaction.
    2. Choose different default Warehouse from list.
    3. Update Quantity.
    4. To delete a component, select the row and press Delete key on keyboard.
    5. Add new components on row marked with *. This will update to a pencil icon once product selected.
  4. Save changes when finished.

Update Existing Component Lists via Import

Acctivate includes the ability to import the component lists for products with a bill of materials from above. When importing, you’ll need the following information as columns in a spreadsheet:

  • Parent Product ID: The assembly, kit, or assortment product ID. This is repeated down the column for each new component.
  • Component Product ID: Product ID for the components which will create the parent.
  • Component Warehouse: The warehouse you wish to utilize as a default on the transactions for this component. This is optional field.
  • Component Quantity: Quantity used to build one parent. This is based on the stocking unit of both the component and parent product.
  • Sequence: Sort order for components. Number each row accordingly.
  • Variable: Yes / No value based on whether the component has variation in the process. This is optional.

Product Component Import ExampleImporting the component list will clear out existing components for the mapped parent products. It’s extremely important to have the complete list of components included in the import. The full list of steps to import components can be found here.


Next Steps

Previous Training Topic

Previous Topic:
Import Products 

Basics Training

Training:
Basics 

Purchasing Training

Training:
Purchasing 

Next Training Topic

Next Topic:
Manage Alternate Units of Measure on Products 

 •  Overview

General

 •  Getting Started

 •  Windows & Features

 •  Create & Modify Filters on Lists

 •  Synchronize with QuickBooks

Business Activities

 •  Activities List

 •  Relate Activities to Documents & Transactions

 •  Business Activity Review

 •  Overview

Product Basics

 •  Product List

 •  Create a New Product

 •  Product Prices

Product Management

 •  Import Products

 •  Manage Product Components

 •  Manage Alternate Units of Measure on Products

 •  Setup Catch Weight/Variable Pricing

 •  Overview

Create a Purchase Order

 •  Create a PO Manually

 •  Reorder Inventory Based on Demand

 •  Purchase Order Statuses

Receive & Invoice a Purchase Order

 •  Purchase Order Receipt

 •  Purchase Invoice

 •  Allocate Other Amounts on Vendor Bill via Landed Cost

Additional Processes

 •  Vendor Returns

 •  Purchase with Catch Weights

 •  Overview

Sales Basics

 •  Sales List

 •  Customer Price Check Utility

Quotes

 •  Create a Sales Quote

 •  Print & Email a Quote

 •  Manage Quotes

 •  Convert Quote to Order

Order Entry

 •  Create a Sales Order

 •  Import Online Orders via Webstore Sync

 •  Import Sales Quotes & Orders

 •  Mobile Order Entry

Order Processing Basics

 •  Approve Credit Holds

 •  Send Order Acknowledgment

 •  Rescheduling Sales Orders

 •  Kitting on Sales Orders

Service Orders

 •  Add Time & Materials to Business Activities

 •  Create Service Orders

 •  Service Scheduling

 •  Service Billing

Advanced Order Processing

 •  Drop Shipments

 •  Special Orders

 •  Process EDI Transactions

 •  Catch Weight Pricing on Sales Quotes & Orders

 •  Create/Edit Existing Sales Order Import Template

Order Picking

 •  Pick Ticket

 •  Create a Pick List

 •  Select Bin Locations on Orders

 •  Select Lot or Serial Numbers on Orders

 •  Mobile Order Picking

 •  Mobile Pick Lists

Order Packaging

 •  Packing Slips

 •  Packaging Management

 •  Create a Shipment in Packaging Manager

 •  Packaging Shipment in Packaging Manager

Order Shipping

 •  Process Shipments via Shipping Workstation Integration

 •  Shipping with Packaging Manager

Payment Entry

 •  Enter Customer Payments

Order Invoicing

 •  Create Invoices from a Sales Order

 •  Batch Invoices

Credit Memos

 •  Create a Credit Memo

 •  Invoice a Credit Memo

 •  Overview

Edit Customer Window Overview

 •  Update Basic Customer Information

 •  Manage Customer Ship To Locations

 •  Customer Contact Management

 •  Customer Credit Specifications

 •  Product Invoice History for Customer

 •  Customer Orders

 •  Customer Specific Product IDs

 •  Invoice & Payment History for Customer

 •  Sales History, Marketing Information & Webstore Customer ID

 •  Emails Sent from Customer Window

 •  Customer Pricing Rules

 •  Business Activities Related to Customer

Customer List & Credit Management

 •  Customer List

 •  Credit & Collection Features

Create Customers

 •  Create New Customer Manually

 •  Import Customers

 •  Create Customer Jobs

 •  Overview

Receipts

 •  Purchase Order Receipt

 •  Mobile Receiving

 •  Inventory Receipt for Lot Number Split/Product Breakdown

Adjustments

 •  Inventory Adjustment

 •  Inventory Balance Adjustment

 •  Inventory Issue

 •  Inventory Count

 •  Mobile Inventory Counts

Transfers

 •  Inventory Transfer

 •  Mobile Inventory Transfers

Assemblies

 •  Inventory Assembly

 •  Mobile Inventory Assemblies

 •  Assembly Workflow Status Configuration

Landed Cost

 •  Vendor Bill Allocation to Inventory Cost

Track & Trace

 •  Track & Trace Inventory Movement for Lot/Serial Items

Void Transactions

 •  Void Inventory Sessions

 

Company

  • About Acctivate
  • Branding
  • Privacy & disclaimers
  • Careers
  • Contact us

Community

  • Technology partners
  • Referral program
  • Partner directory
  • Partner program
  • Partner resources
  • Inventory glossary
  • Blog

Features

  • Barcoding software
  • Bill of materials (BOM), Kitting & Assemblies
  • Tracking inventory task activity
  • Catch weight management
  • Credit management
  • Customer management
  • Dropshipping software
  • eCommerce inventory management
  • EDI management software
  • Hosted inventory management
  • Import export software
  • Inventory dashboard
  • Inventory forecasting
  • Landed cost
  • Manufacturing
  • Matrix inventory
  • Multi-channel inventory management
  • Multi currency
  • Order fulfillment
  • Order management
  • Platform
  • Pricing tools
  • Process manufacturing
  • Purchasing management
  • Reporting
  • Retail counter sales
  • Service and repair management software
  • Traceability
  • Wholesale distribution

How to buy

  • Learn Acctivate
  • Acctivate Benefits
  • Inventory Module Features
  • Acctivate Onboarding
  • System requirements
  • Free Trial
Connect with us
Acctivate on Facebook Acctivate on Instagram Acctivate on Linkedin Acctivate on Twitter Acctivate on YouTube

© 2022 Alterity, Inc. All rights reserved. ACCTivate! is a registered trademark of Alterity, Inc., registered in the U.S.
Privacy & Disclaimers