Inventory Summary Window

This window can be used to look at an inventory snapshot or to see how inventory has changed during a period of time. It can also be used for inventory related reporting. To understand how inventory works in Fusion, see the Inventory section of Core Concepts.

Determining What Inventory To Look At

Fusion will show inventory information for the date (or date range), locations, and items you select.

Each time you make a change to any of the above, you will need to click the Refresh Tab's Information button to have Fusion update the displayed information.

Commodities, Drugs, and Inputs

Commodities, drugs, and inputs all work in similar way. When you select an item in the list on the left, the information on the right will show the inventory information for that item. If you select multiple items, Fusion will combine the inventory information for all the items selected. See the next section to learn how each value on the right is calculated depending on whether one or multiple items is selected.

The major difference between the Commodities tab from the Drugs and Inputs tab is the Show Extra Precision checkbox. When this option is turned on, Fusion will show 6 decimal places for the quantity related figures. If the option is left off, Fusion will only show 3 decimal places. The only time it would make sense to turn this on is if you are looking at ingredients that have their Track with extra precision option turned on (see Commodity/Ingredient Edit Window).

Calculations

The following table shows how the Fusion calculates the values in the Inventory Summary window for commodities, drugs, and inputs.

Task Bar
One Item Selected Multiple Items Selected
A The beginning balance for the first day in the period. If multiple locations are selected, this is the sum of the appropriate first day for each item. The sum of A for each selected item.
B The sum of the New and the Offset In values for the period. The sum of B for each selected item.
C The sum of the Used and the Offset Out values for the period. The sum of C for each selected item.
D The ending balance for the last day in the period. If multiple locations are selected, this is the sum of the appropriate last day for each item. The sum of D for each selected item.
E B divided by days in period. The above B divided by days in period.
F C divided by days in period. The above C divided by days in period.
G A multiplied by K The sum of G for each selected item.
H Sum the New and Offset In values and multiply by the Avg Unit Cost for each day in the period. Then sum these values together. The sum of H for each selected item.
I Sum the Used and Offset Out values and multiply by the Avg Unit Cost for each day in the period. Then sum these values together. The sum of I for each selected item.
J D multiplied by N The sum of J for each selected item.
K The Avg Unit Cost for the first day in the period. If multiple locations are selected, this will be a weighted average based on begin balance. The above G divided by the above A.
L H divided by B The above H divided by the above B.
M I divided by C The above I divided by the above C.
N The Avg Unit Cost for the last day in the period. If multiple locations are selected, this will be a weighted average based on end balance. The above J divided by the above D.

(The Market Value and Bill At sections follow the same logic as the Cost section but use Avg Unit Market Value and Avg Unit Bill At values respectively.)

The Avg Unit pricing is stored with each day’s record and is recalculated automatically when pricing, equivalency (for inputs), or amounts change. It is based on the current (for that day) pricing (Cost/Market Value/Bill At attributes) applied to all in and out movement for the item. If any relevant inventory offsets had any pricing overridden, this will be taken into account for the amount of the offset.

Cattle Tab

The first principle to understand when using the cattle portion of this window is that Fusion figures out cattle inventory solely based on in and out cohorts. If you override in or out values on a lot level, or if you have extra in and out cohorts associated with a lot to cancel out mistakes that have been made, the inventory levels shown here will not be correct. For this reason we recommend not overriding in or out values and editing or deleting in and out cohorts when mistakes have been made.

When you first use this tab, Fusion will show just the total values for the time period and location(s) chosen. You can break the totals down in several ways using the options above the inventory list. You don't have to refresh the list each time you make one of these changes, so it is easy to quickly experiment with how they work.

The columns in the inventory list are calculated as follows:

Copying To Clipboard

You can click the Copy To Clipboard button to copy the values in whichever tab you are looking at to the clipboard. You could then paste it into a spreadsheet for further analysis. When you copy from the Cattle tab, it copies it just as you see it. When you copy from the other tabs, Fusion actually copies the values for every item in the list whether it is selected or not.

Note that the Show Extra Precision setting in the Commodities tab affects the values copied into the clipboard.

Printing Reports

To print an inventory report, click the Print button. From there you can create new reports or select existing reports to print from. See Inventory Summary Print Window for more information.

Note that the Show Extra Precision setting in the Commodities tab affects the values in the report.

Getting Here

You can open this window by going to Fusion Core → Lots → Lot Center.

Related Topics