CenterPoint® Accounting - Understanding and Using Assemblies

Related Help

View or Print as PDF


An assembly is an item that is sold from inventory and built from other inventory or component items (including non-tracked or service items). Every assembly starts out as an inventory item. Before an assembly can be produced and sold, the assembly item and the component items must first be setup as separate items in Setup > Inventory > Items, including labor, which is setup as a service item. General Ledger accounts can also pass cost to the assembled item. You may want to use account allocation for such things as overhead. Then, the assembled item must be defined in Setup > Inventory> Assemblies and then produced in Processes > Inventory > Build Assemblies to take the component items out of inventory and add the assembly quantity to inventory. Optionally, you can setup production plans which allow you to build multiple assemblies at the same time.

Follow the steps below to:

Option 1: Setup an Assembly

Option 2: Setup an Assembly in a Different Inventory Location as the Component Item Inventory Location (Prerequisite: The Inventory Location module must be Purchased and Registered)

Option 3: Setup an Assembly in the Same Inventory Location as the Component Item Inventory Location (Prerequisite: The Inventory Location module must be Purchased and Registered)

Build an Assembly

Setup a Production Run Definition

Build a Production Run


Option 1: Setup an Assembly

  1. Select Setup > Inventory > Assemblies. Click New.

  1. Click the Options button, select Add/Remove Assembly Items. Select all of the check boxes that you will use when setting up this assembly. For example, if you need to change the profit center or location for the component items. Click OK.
  1. On the right side of the screen, in the Item box, select any existing inventory item as the assembled item.
  2. The item Name displays as the default. The name can be changed. This is the name that will display in the left column for the assembled item.
  3. Click the next to the assembled item on the left side of the screen to expand the details for the assembled item. To expand/collapse all the nodes on the Assembled Item & Component List, right-click and select either the Expand All or Collapse All option.

Note: The main Assembled Item cannot be removed.

  1. On the left side of the screen, select the Quantity - Unit of Measure line.
  2. On the right side of the screen, in the Unit of Measure box select the unit of measure to use when building the assembly.
  3. Ignore the Inventory Location line.

Note: If you use the Inventory Location module, please see Option 2 or Option 3 in this document.

  1. On the bottom left side of the screen, click Add to begin adding the component items that are used to produce the assembled item.
  2. In the Item box, select a component item.
Note: When an Inventory Item is selected (type = Inventory Item, Lotted Item or Serialized Item), the Account box is not active. When a non-tracked item is selected, an Account must be selected. If the Account box is left blank, a message will display.
  1. The item Name or the account Name displays as the default depending on whether you selected an account in lieu of an item. This name can be changed. This is the name that will display in the left column for the component item.
  2. Click the next to the component item on the left side of the screen to expand the details for the component item.
  1. On the left side of the screen, select the Quantity - Unit of Measure line.
  2. On the right side of the screen, in Quantity box, enter the number of this component to use (components can be saved with a zero quantity) when building the assembly and in the Unit of Measure box select the unit of measure to use when building the assembly.
  3. Repeat steps 11-15 for all component items used in the assembly item.
  1. Click Save.
  2. Continue with the Build an Assembly section in this document to immediately build the assembly or continue with the Production Run section in this document to build the assembly with other assemblies and post your build.

Option 2: Setup an Assembly in a Different Inventory Location as the Component Inventory Item Location

Prerequisite

The Inventory Location module must be purchased and registered.

  1. Select Setup > Inventory > Assemblies.
  2. Click New.

  1. Click the Options button, select Add/Remove Assembly Items. Select all of the check boxes that you will use when setting up this assembly. For example, if you need to change the profit center or location for the component items. Click OK.
  2. On the right side of the screen, in the Item box, select any existing inventory item as the assembled item.
  3. The item Name displays as the default. The name can be changed. This is the name that will display in the left column for the assembled item.
  4. Click the next to the assembled item on the left side of the screen to expand the details for the assembled item. To expand/collapse all the nodes on the Assembled Item & Component List, right-click and select either the Expand All or Collapse All option.

Note: The main Assembled Item cannot be removed.

  1. On the left side of the screen, select the Quantity - Unit of Measure line.
  2. On the right side of the screen, in the Unit of Measure box select the unit of measure to use when building the assembly.
  3. On the left side of the screen, select the Inventory Location line.
  4. On the right side of the screen, if you want the inventory location to always be the same, in the Type box, select Always the Same and in the Value box, select the inventory location for the assembled item. If you want to select the inventory location at the time the assembled item is built, select Choose From List and in the Default box, select the default location. Change the caption to "Build Location," so that it is easily identifiable on the Build Assemblies screen
  1. On the bottom left side of the screen, click Add to begin adding the component items that are used to produce the assembled item.
  2. In the Item box, select a component item.
Note: When an Inventory Item is selected (type = Inventory Item, Lotted Item or Serialized Item), the Account box is not active. When a non-tracked item is selected, an Account must be selected. If the Account box is left blank, a message will display.
  1. The item Name or the account Name displays as the default depending on whether you selected an account in lieu of an item. This is the name that will display in the left column for the component item.
  2. Click the next to the component item on the left side of the screen to expand the details for the component item.
  1. On the left side of the screen, select the Quantity - Unit of Measure line.
  2. On the right side of the screen, in Quantity box, enter the number of this component to use (components can be saved with a zero quantity) when building the assembly and in the Unit of Measure box select the unit of measure to use when building the assembly.
  1. On the left side of the screen, select the Inventory Location line.
  2. On the right side of the screen, if you always want the component's inventory location to be the same, in the Type box, select Always the Same and in the Value box, select the inventory location the component item is from. If you want to select the component inventory location at the time the assembled item is built, select Choose From List and in the Default box, select the default location. Change the caption to "Component Location," so that it is easily identifiable on the build assemblies screen.
  1. Repeat steps 11-17 for all component items used in the assembly item. For additional component items, the "Inventory Location" will normally be copied from the first component selected, unless components come from different locations. Set the Type to Copy for the Inventory Location line for all additional components. For Labor component items, set the Type to Copy and then under Extended Properties select the assembled item inventory location.

  1. Click Save.
  2. Continue with the Build an Assembly section in this document to immediately build the assembly or continue with the Setup a Production Run Definition section in this document to build the assembly with other assemblies and then follow the Run a Production Run section.

Option 3: Setup an Assembly in the Same Inventory Location as the Component Item Inventory Location

Prerequisite

The Inventory Location module must be Purchased and Registered.

  1. Select Setup > Inventory > Assemblies.
  2. Click New.

  1. Click the Options button, select Add/Remove Assembly Items. Select all of the check boxes that you will use when setting up this assembly. For example, if you need to change the profit center or location for the component items. Click OK.
  2. On the right side of the screen, in the Item box, select any existing inventory item as the assembled item.
  3. The item Name displays as the default. The name can be changed. This is the name that will display in the left column for the assembled item.
  4. Click the next to the assembled item on the left side of the screen to expand the details for the assembled item. To expand/collapse all the nodes on the Assembled Item & Component List, right-click and select either the Expand All or Collapse All option.

Note: The main Assembled Item cannot be removed.

  1. On the left side of the screen, select the Quantity - Unit of Measure line.
  2. On the right side of the screen, in the Unit of Measure box select the unit of measure to use when building the assembly.
  3. On the left side of the screen, select the Inventory Location line.
  4. On the right side of the screen, in the Type box, select Always the Same and in the Value box, select the default inventory location for the assembled item. If you want to select the inventory location at the time the assembled item is built, select Choose From List and in the Default box, select the default inventory location. Change the caption to "Build Location," so that it is easily identifiable on the Build Assemblies screen
  1. On the bottom left side of the screen, click Add to begin adding the component items that are used to produce the assembled item.
  2. In the Item box, select a component item.
  3. The item Name or the account Name displays as the default depending on whether you selected an account in lieu of an item. This name can be changed. This is the name that will display in the left column for the component item.
  4. Click the next to the component item on the left side of the screen to expand the details for the component item.
  1. On the left side of the screen, select the Quantity - Unit of Measure line.
  2. On the right side of the screen, in Quantity box, enter the number of this component to use (components can be saved with a zero quantity) when building the assembly and in the Unit of Measure box select the unit of measure to use when building the assembly.
  1. Repeat steps 11-15 for all component items used in the assembly item.

  1. Click Save.
  2. There are a couple of reports that can be run from Reports > Reports > Setup Lists > Assemblies to verify your setup:
    • Assembly Components Where Used -Displays each component and the assembled items where they are used. Component quantities needed for each assembled item are also included.

    • Assembled Items - Assembled Items - Displays the assembled item and lists each component .along with quantities to build assemblies.

  3. Continue with the Build an Assembly section in this document to immediately build the assembly or continue with the Setup a Production Run Definition section in this document to build the assembly with other assemblies and then follow the Run a Production Run section.

Build an Assembly

A finished product or sub-assembly must be built (produced) before the item can be sold or used in an assembled item. Use the build process to remove the components from inventory and add the built quantity to the finished product. or sub-assembly.

  1. Select Processes > Inventory > Build Assemblies.
  2. Select the Company this assembly is being built for.
  3. Select the Assembled Item you want to build.
  4. Determine if you Require all Components to be On Hand when the assembly is built.
  5. Verify the Transaction # and Date.
  6. Enter the Build Quantity.

  1. The Component button will be green if all of the components needed to build the assembly item have a Quantity On Hand greater than or equal to the Quantity Needed to build the assembly item. If the button is Red, either the Quantity On Hand is less than the Quantity Needed for a component item or a sub-assembly in the assembled item. If the button is Yellow, the Quantity Needed is less than or equal to the Quantity on Hand and a sub-assembly has a Quantity on Hand less than the Quantity Needed to build the assembled item. Click the Component button to view the Components Lists for the build. The Material Shortage button will identify which components triggered the color change on the Component button.

  1. Click OK.
  2. To print reports about this build assembly, click the Reports button and select either the Material Requirements, Material Shortage or Assembled Item Cost report.
HINT: If you need to gather the materials for the build prior to actually completing the build, print the Materials Requirements report (click the Reports button and select Material Requirements) prior to clicking the Build Assemblies "Save" button and without actually completing a build you can use the Assembled Item Cost report for "What If" planning.
  1. Click Build to remove the components from inventory and add the built quantity to the finished product. or sub-assembly. If the Require all components to be on hand check box is select and there is a shortage of any required component the build will fail.
Note: Once a component item is used in an assembly transaction such as a Build, it cannot be removed. If you need to remove a component from this assembly, copy it and create a new assembly without the component.

Setup a Production Run Definition

Production runs are used to build multiple assemblies at the same time. First define the production run and then run then Build the Production Run to complete the build process.

  1. Select Setup > InventoryProduction Run Definitions.
  2. Click New.

  1. Enter an Abbreviation and Name for the Production Run Definition.
  2. Select the Company the Production Run Definition is for.
  3. Select the Assemblies and Quantity to build in the Production Run Definition. Repeat for all assemblies to be built at the same time.
Hint: If one assembled item requires a another assembled item as one of its components (subassembly), the sequence of the subassembly should be a lower number than the item requiring it.

 

  1. Click Save.
  2. Click Close.

Build the Production Run

  1. Complete the Setup a Production Run Definition section of this document.
  2. Select Processes > Inventory > Production Runs.

  1. The button in the Material Shortage column will be green if all of the components needed to build the assembly item have a Quantity On Hand greater than or equal to the Quantity Needed to build the assembly item. If the button is Red, either the Quantity On Hand is less than the Quantity Needed for a component item or a sub-assembly in the assembled item. If the button is Yellow, the Quantity Needed is less than or equal to the Quantity on Hand and a sub-assembly has a Quantity on Hand less than the Quantity Needed to build the assembled item. Click the button in the Material Shortage column to go to the assembly and view the components list by clicking Components.
  2. If a component location needs to be selected for a build, click the Detail button and select the component location.

  3. To print reports about this production run, click the Reports button and select either the Material Requirements, Material Shortage, Assembled Item Cost, or Assembled Item Planning Using Last Cost report.
HINT: If you need to gather the materials for the build prior to actually completing the build, print the Materials Requirements report (click the Reports button and select Material Requirements) prior to clicking the Build Assemblies "Save" button and without actually completing a build you can use the Assembled Item Cost report for "What If" planning.
  1. Click Build.
  2. Click Close.
Note: Once a component item is used in an assembly transaction such as a Production Run, it cannot be removed. If you need to remove a component from this assembly, select the Quantity - Unit of Measure line for the component and enter 0 in the Quantity box.

 

Document: 3229

Concept Link IconSee Also