Reports Menu -> Inventory -> Inventory Value Reports -> Sales Inventory Value Report
This program can be used to generate the inventory value reports
for sales items.
Separate output is generated for Serialized Sales inventory and for
Non-Serialized Sales parts.
The reports can be based on the company-wide On Hand quantities or
by the quantity at each location, and the product value can be
calculated at the class level or for the individual products.
This report lists the current inventory value, unless the option to Print By Date is selected.
This Date option reconstructs the Inventory quantity as of the
selected date in the past, using the Inventory Adjustment records,
Warehouse Receipts and the Detailed Revenue History (Sales History
INSH).
The total value in a Print By Date report will not
necessarily be accurate, as it still uses the current
average cost in the product file, and the average cost has probably
changed as it is updated each time a product is purchased and
receipted.
Note: If there is no value for an item in the output, check the
cost type in Sales Inventory.
If the cost type is Zero Cost the assumption is that the
stock has already been expensed upon purchase, therefore no
inventory value for reporting purposes is required.
The reported Margin percent value is useful on the individual
products, but less useful as a Class Margin Total or for the Report
Margin Total.
This is because the Margin is calculated on each transaction before
totalling. Then that total is divided by the number of transactions
to provide the Class/Report Total Margins.
This formula for the Total Margin does not consider the difference
in the value of the products so is not always an accurate margin
value overall, and may not calculate consistently between
reports.
The prompts to generate the report are:
Note: When balancing the Inventory Value from this report to the General Ledger, use the Product Class filter and include all classes that post to the same GL account assigned in the Sales Product Classes for Inventory.
Check this box to include the details for each product in the selection range.
Check this box to generate a separate product/class inventory
value record for each location selected in the Location, ALL, or
SEL filter, based on the quantities at that location.
With this option it is recommended to output the resulting report
information to a spreadsheet which includes a location column for
each product record, however if document format is requested then
the Sort By selection should be by 'Location' for easier
interpretation of the data.
Note: This option is automatically checked if the Sort By selection is by "Location".
Check this box to calculate the inventory value according to the quantities as of a prior date, and the with current cost.
Note: The utility Inventory Transaction History can be used to run an audit on rental product history.
Check this box to list the serialized sale items individually on
a separate report from the Non-Serialized inventory.
The serialized products are defined in Sales
Inventory in the Serial# field.
Uncheck this box to exclude the Time-of-Sale serialized sale items as they often do not have serial numbers yet.
Check this box to include all serialized sale items whether or
not they have serial numbers.
The text TIME OF SALE ITEMS prints on the report in place of
the serial number for items with no serial numbers.
Select Product to sort the product records by product
number regardless of class.
If this option is selected, the Print Product Detail is
automatically checked.
Select Location to sort the product records by
location.
If this option is selected, the formula to Calculate Quantities
by Location is automatically applied and the option to generate
a New Page per Location is enabled.
Select one of the following location options:
Note: The location selection is restricted to the Divisional Restricted Views assigned to the
operator, so the inventory value reported will only be reflected
for this operator's divisions.
The location selection is NOT restricted to just locations
currently flagged as Inventory in Divisions as this could distorted the report if
transactions were omitted from divisions that may previously have
qualified as inventory locations.
If Cost by Location processing has not been activated, the average cost is used automatically.
Location Summary: When the output does not Calculate
Quantities by Location, a summary "Location" column is included
on the spreadsheet output listing all the RSIL location codes for
each product, regardless of the selected reporting locations,
regardless of quantities at those locations, and regardless of any
restricted views.
If an RSIL record exists for more than one location, the locations
will all be included in the same column separated by commas,
allowing 16 locations per column with a maximum of 10 Location
columns.
Check this box to start a new page for each new Product Class
with a sub-total for each Product Class.
If the Excel option was selected for the output, then the
information for each class will be on a separate tab on the
spreadsheet.
Uncheck this box to continue printing all Product Classes together with a sub-total for each Product Class on the report output.
Check this box to start a new page for each new Location with a
sub-total for each Location.
If the Excel option was selected for the output, then the
information for each Location will be on a separate tab on the
spreadsheet.
Uncheck this box to continue printing all Locations together with a sub-total for each Location on the report output.
On the spreadsheet output, a separate tab is generated for each Product Class on the two reports.
Warning re: GRAND TOTAL
Two separate reports will print: one for Serialized Sales inventory
and one for Non-Serialized Sales inventory.
To get the GRAND TOTAL of both types of inventory, print the report
for all classes and manually add the two reports together.
Note: Because they do not affect inventory, any received (INWR)
quantities for re-rentals or for services through associated parts,
that were ordered using the P.O./Contract link feature, are not
reflected in this report.
Refer to Contract/Purchase Order Link
Overview for details on this processing.
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |