Inventory reports

By using the wide variety of reports for the Inventory workspace, you can promptly get detailed information about inventory and warehouses, as well as inventory revaluation data.

You can also analyse the data by various criteria, and track inventory operations for different warehouses and locations. Many of the reports in this workspace have both summary and detailed versions; you can decide which version best meets your current needs.

Because the Inventory workspace is tightly integrated lwith other workspaces, such as Purchases, Inventory, General ledger, and VAT, you can find and analyse the exact information you need. By using flexible selection options and data links, you can easily drill down from a financial report to any supporting details.

Note

Because the Inventory reports are generated by user request, they run on only accounts and subaccounts that the user is authorised to access, based on the user’s roles and membership in restriction groups.

The reports can be generated in multiple formats, including PDF and HTML. Also, you can print the report you generated or send the report by email.

The Inventory workspace includes the following reports:

Balance

Inventory balance (IN61500S): Displays detailed, up-to-date information about the quantities and unit costs of stock items at different warehouses and locations.
Historical inventory balance (IN61600S): For the chosen period, presents detailed information about the beginning and ending quantities of stock items at different warehouses and locations.
Inventory valuation (IN61550S): Displays information about the quantities on hand and the total cost of inventory by inventory account, with details for different warehouses.
Historical inventory valuation (IN61700S): For the chosen period, displays information about how the balances of the inventory accounts and the costs of the stock items at different warehouses change during the period.
Goods in transit (IN616500): Shows up-to-date information about the goods in transit, their total quantities, and their total cost.
Lot/serial numbers (IN613000): Displays information about stock items with lot or serial numbers: expiration dates, unit costs, quantities available, and expired quantities as calculated for the selected aging date.
Note
This window is only available if the Lot/serial tracking functionality is enabled in the Enable/disable functionalities (CS100000) window.

Stocktaking

Stocktaking sheets (IN620500): Generates stocktaking sheets for the selected stocktacking.
Stocktaking variance preview (IN621500): Lists the stock items included into stocktacking, and displays the book quantities and the count results for the items.

Window

Assembly confirmation (IN30702S)
Assembly picklist (IN30701S)
Stock item labels (IN619200): Generates labels for stock items received according to a particular receipt.
Location labels (IN619000): Generates labels for locations within specific warehouse with stock item or item class specified.

Audit

Preview standard cost change (IN617500): Gives you estimates of the changes in the total cost of stock items stored at various warehouses before you perform updating of the standard costs of the items.
Historical inventory balance (IN61600S): Displays the list of all open inventory documents to be posted to the specified financial period.
Inventory register (IN61400S): Presents up-to-date, detailed information about inventory operations in different warehouses within the selected financial period (or all periods).
Inventory list summary (IN610500): Displays current summary information about unreleased inventory documents: receipts, issues, adjustments, and transfers.
Inventory list (detailed) (IN61100S): Displays up-to-date summary information about every generated inventory document (receipt, issue, adjustment, or transfer).
Summary of historical inventory valuation (IN61800S)
Unreleased inventory documents (IN656000)