Inventory Worksheet

• Overview
• Filtering Results
• Making Changes to Inventory Model Fields
• Bulk Editing Inventory Model Fields
• Copying and Pasting Single Value To Selected Lines
• Copying and Pasting Multiple Values To Selected Lines
• Multiply Selected Line Values

Overview

The Inventory Worksheet is a powerful tool that will help you in managing your inventory. In the Inventory Worksheet, you can view and edit general information about your inventory, including notes, purchase cost, pricing, bin locations, gl accounts, and more.

To access the Inventory Worksheet, go to the  Inventory menu, then click Inventory Worksheet.

Filtering Results

To filter results in the Inventory Worksheet, use the fields located along the top of each column.

You can use as many fields as you need to filter results. Some fields will have a free-type field, while others will have a drop-down menu filter.

You can open up the inventory model by right-clicking and selecting "Open Model".

Making Changes to Inventory Model Fields

To edit the information found in each field of the Inventory Worksheet, click into the field and it will change into an editable field. Make the necessary adjustments, and all changes will be automatically saved when you click out of the field or press enter/return on the keyboard.

Bulk Editing Inventory Model Fields

1. Go to the  Inventory menu, then click Inventory Worksheet
2. Select the checkboxes of the lines that you would like to bulk edit
3. Locate the column you want to edit, select the 3-dot options menu, and choose "Update values on selected lines"
4. Enter the applicable information and select Update

Copying and Pasting Single Value To Selected Lines

1. Go to the  Inventory menu, then click Inventory Worksheet
2. Select the checkbox of the line that you would like to copy
3. Locate the column you want to copy, select the column's 3-dot options menu, and choose "Copy from selected line"
4. Select the checkboxes of the lines that you would like to paste the selected value to
5. Select the column's 3-dot options menu and choose "Paste to selected lines"

Copying and Pasting Multiple Values To Selected Lines

1. Go to the  Inventory menu, then click Inventory Worksheet
2. Select the checkboxes of the lines that you would like to copy
3. Locate the column you want to copy, select the 3-dot options menu, and hoover over "Copy Values of Selected Lines to" to be presented with the paste options in a sub-menu
4. Select the option of where you want the values to be pasted

Multiply Selected Line Values

This option is only available for numerical value fields.

1. Go to the  Inventory menu, then click Inventory Worksheet
2. Select the checkboxes of the lines that you would like to multiply
3. Locate the column you want to multiply, select the 3-dot options menu, and choose "Multiply selected line values"
4. Enter either a percentage or a whole number that you want to multiply the selected values by
5. If applicable, check "Round multiplied values to nearest whole number" and select Update