Sub Assembly

Column-by-column details for the Sub Assembly tab of the data load spreadsheet

Parts that are of type Sub Assembly are made in-house then later consumed into another production step or finished good.

Part Number

Required - Alpha Numeric
Syncs with QuickBooks - Inventory Item Name

Anything uniquely tracked in inventory needs it's own part number. Add your existing part numbers to this column of the upload sheet. If you will be creating new part numbers, keep them simple. Smart part numbers are not recommended. Generally, a part number should be created for WIP/Sub Assemblies if they are not always consumed the same day they are produced.


Required - Alpha Numeric
Syncs with QuickBooks - Inventory Item Sales and Purchasing Description

The description field holds the full text human readable definition/name of the part.

Produced By UOM

Required - Alphabetic

Produced-by Unit of Measure, is the measure most often given to this part after it has been PRODUCED. For example: If a Sub Assembly part is produced by the tote, then it's 'Produced By UOM' = tote.

Cost per Produced By UOM

Required - Numeric
*Syncs with QuickBooks - Inventory Item Cost

How much does it cost to produce this sub assembly? This standard cost equals the value of both inventory and labor/direct overhead inputs.


Hard to calculate?

This is often a hard number to calculate. Going forward DataNinja will track this for you automatically for each run. Why do you need to fill this in with our best guess now? - If you have any inventory on hand at the time of your first physical inventory labeling, we need to make sure it gets a good ballpark valuation when synced to your finance system.

QC Sampling Plan Required?

Required - Y/N
Whenever this sub assembly is produced, will samples need to be recorded and evaluated against pass/fail criteria?

Part Class

Optional - Alpha Numeric
Syncs with QuickBooks - Inventory Item Category

Class fields are used to "tag" parts into strata for sorting, grouping, and reporting. Used to group parts by category i.e. Bulk, WIP, Upper Assembly etc.

Other Classifications/Categories

*Optional - Alpha Numeric**

Do you have additional allergens, Classifications, or Categories? Use this column to capture extra details not recorded elsewhere. Your Implementation Engineer will help make sure this data is captured.



WIP Liquid
Bulk Blend
Kit Assembly
Batch Blend

What’s Next

The Finished Good Tab