Stock location report

Purpose

Use the Stock location report to review product balances and selected product master data for stock by location. The report supports advanced filtering, historical balance analysis by date, and export functionality.

The report can be used both for reviewing current inventory balances and for viewing balances as they existed on a selected historical date.

Roles involved

• Inventory controller
• Store manager
• Purchasing user

Preconditions

• The user needs permission to read the Stock location report.
• Products and balances must exist.

Navigation path

Reports → Stock location report

Step-by-step procedure

1. Open Reports → Stock location report.Use the available filters such as:

• Category
• Product type
• Vendor
• Product status
• Location
• Report date

1. If Report date is left empty, the report displays current inventory balances.
2. If Report date is specified, the report calculates and displays inventory balances as of the selected date.
3. Review the report data, including:
   1. Product number
   2. Description
   3. Standard price
   4. Last unit cost
   5. Category
   6. Vendor
   7. Location balances
   8. Total balance
   9. Export the report when needed.

Required fields

• No filter is mandatory.
• For large product ranges, it is recommended to use category, type, vendor, location, or date filters to improve performance and readability.

Report date behavior

• The Report date filter enables viewing inventory balances at a specific historical point in time.
• Historical balances are recalculated from inventory transactions and may differ from a previously exported report if transactions are later posted, corrected, approved, or reversed with an earlier transaction date.
• Export file names continue to use the report generation date and time rather than the selected report date.
• Users should refer to the report filter criteria or report content to identify the selected historical date.

Historical balance limitations

When the Report date filter is used:

• Reservation information is not available historically.
• Reservation-related columns may display zero values or may be hidden depending on the implementation version.
• Only inventory balance information that can be reconstructed from historical transactions is displayed.

Exceptions

• Some columns, such as sales price or unit cost, may be hidden if the user does not have permission to view them.
• The report structure may vary when reservation functionality is enabled.
• Historical reports may not display reservation-related information.

Common errors

• Users expect all price fields but lack the permission to view them.
• Users misread the balance total without considering reservations.
• Users expect historical balances to remain unchanged after additional transactions have been posted with backdated transaction dates.
• Users expect the selected report date to be included in the export file name.

Troubleshooting

• If prices are missing, check user permissions.
• If too many products appear, narrow the list using category, vendor, location, status, or date filters.
• If historical balances appear different from previous exports, verify whether inventory transactions have been posted, corrected, approved, or reversed with transaction dates affecting the selected period.
• If reservation values show zero for a historical date, this is expected because reservation history is not available for retrospective calculations.

Questions / Gaps

• Confirm whether the selected Report date should be displayed in the report export header or report body for easier identification of exported historical reports.
• Confirm the exact visibility rules for reservation-related columns when the Report date filter is used across different customer environments.