Inventory Report: Default Summarizing

The basic Inventory report summarizes the following data for each active inventory item:
 
  • Opening quantity - the quantity present on the date specified as a report start date (in the Opening qty column).
  • Opening value - financial value of an inventory item as of the report start date/ Total cost of the opening quantity of item as of the report start date (in the Opening value column).
  • Incoming quantity - the total quantity of the item which was purchased, received or assembled within a specified report period (in the Incoming qty column).
  • Incoming value - the financial value of the incoming quantity of the item (in the Incoming value column).
  • Outgoing quantity - the quantity of the item that has been sold, written off or transferred to another warehouse within a given period (in the Outgoing qty column).
  • Outgoing value - the total COGS amount of the outgoing quantity of the item (in the Outgoing value column).
  • Ending balance quantity - the quantity present as of the report end date (in the Ending balance qty column).
  • Ending balance value -  financial value of inventory item as of the report end date/ Total cost of the ending quantity of item as of the report end date (in the Ending balance value column).
 
The amounts are worked out by summing the original values (using the SUM function). The summarized amounts are presented in your system currency.
 
Note: Summary values are displayed at each level of the report hierarchy and at the grand total level. If no summary value is available for a certain level, nothing is displayed for it.
While moving to Warehouse sublevel of the report, total amounts and balances are broken down into the amounts associated with each warehouse according to the item’s inventory transactions involving a specific warehouse.
 
The default summarizing settings are defined in the values section of the Invoice report. To define the summarizing methods, the summable fields have been added and summarizing options have been specified for them.  Except for specific reports that do not provide for full customization (see Customize Reports), you can change the summable fields and the summarizing methods for your reports. In case of Inventory report, you are allowed to do that.

To customize the default summarizing parameters
 
1. On the page for configuring report parameters, click the Customize button.
 
2. Use the values section to view and customize the default summable fields and summarizing methods defined for them.
 
You can delete, rearrange, add new summable fields and specify summarizing methods for them.
 
For information how to customize summarizing settings, see Summarize Report Data.
 
To add a summable field:
 
  • In the values section, click the Select an option box, and then select a summable field from the list of options.
 
The list displays summable fields from the selected report type which you can use to summarize report data in columns. For Customer balance report, there is a number of fields you can use:
 

Field

Used for summarizing and displaying

Opening qty

The quantity present on the date specified as a report start date.

Opening value

Total cost of the opening quantity of item as of the report start date.

Incoming qty

The total quantity of the item which was purchased/received/manufactured during/within a specified report period.

Incoming value

The financial value of the incoming quantity of the item.

Outgoing qty

The quantity of the item that has been sold, written off or transferred to another warehouse within a given period.

Outgoing value

The total COGS amount of the outgoing quantity of the item.

Ending balance qty

The quantity present as of the report end date.

Ending balance value

Total cost of the ending quantity of item as of the report end date.
 
The SUM function is selected as a default summarizing method for all fields. 
 
In case it is necessary to change the summarizing method, you do that as follows:
 
  • Click the calculation option box to the right of the field, and then select one of the available summarizing options from the list.
 
For summarizing options, see Summarizing Methods.