This chapter describes the RMS reports available through the Report Request window.
The reports are organized according to module, as listed in the List of Modules window.
The following section describes the Control report.
Module: Control
Description: A regularly scheduled batch program deletes records that you have marked for deletion. Some records may not be deleted if the system determines that the record is still in use in RMS. If an item is marked for deletion the dlyprg.pc program checks that the item was not put on order later in the day. If the relations are found to exist, a record is written to an error table (DAILY_PURGE_ERROR_LOG).
Parameters: None
The following section describes the Cost Management reports.
Module: Cost Management
Description: The Cost Overlap/Conflicts report identifies any conflicting cost changes that are entered into the system.
Parameters: None
The following section describes the Finance reports.
Module: Finance
Description: This report shows the fixed deal data for accounting entry by deal and supplier.
Parameter: None
Module: Finance
Description: The Letter of Credit Amendments report displays the details of amendments made to a given letter of credit.
Parameter: Letter of credit ID (this is a mandatory field)
Module: Finance
Description: The Letter of Credit Details report displays the details of a given letter of credit.
Parameter: Letter of credit ID (this is a mandatory field)
Module: Finance
Description: This report shows the inventory valuation for a fiscal year at the location and division level.
Parameter: Fiscal Year
The following section describes the HTS Maintenance reports.
Module: HTS Maintenance
Description: The HTS Mass Update Impact report lists the items and purchase order/items that were affected by a change in the harmonized tariff schedule.
Parameters:
Displays only item (restricts the report to the affected items or to the affected items on all purchase orders)
Displays only unapproved orders
Effective date (effective date of the HTS change)
The following section describes the Item report.
Module: Items
Description: You can enter a request in RMS to make the same change to multiple items. The Mass Item Change Rejection report lists those changes that are rejected by the system and why the request could not be completed.
Parameter: Change type (item indicator, location-level attributes, merchandise hierarchy, seasons/phases, replenishment, substitute items, user-defined attributes, VAT indicator).
The following section describes the Orders reports.
Module: Orders
Description: This report shows details about purchase orders that are not fully received.
Parameters:
Division
Group
Dept
Class
Subclass
Item
Item list
Supplier
Supplier trait
Not before/not after date
Location
Location list
Start date (this is a mandatory field)
End date
Module: Orders
Description: This report shows open-to-buy and related information by week for a selected department, class, or subclass for a selected time period.
Parameters:
Dept
Class
Subclass
Start date (this is a mandatory field)
End date (this is a mandatory field)
Module: Orders
Description: Sometimes orders are distributed to a dummy location (also referred to as a redistribution warehouse) because the order is placed before the buyer knows which locations need the ordered items. The Order Redistribution report lists those purchase orders that must be redistributed by a specified buyer. If a buyer is not specified, the report lists such orders for each buyer.
Parameter: Buyer
The following section describes the Point of Sale report.
The following section describes the Shipping and Receiving reports.
Module: Shipping and Receiving
Description: This report displays relevant information for each item on a bill of lading, such as the quantity, unit cost, and unit retail price for each item.
Parameters:
Location
Ship date
Bill of lading number
Note: You must supply either the bill of lading number, or the location and ship date. |
Module: Shipping and Receiving
Description: This report shows details about inbound purchase order shipments for a specified time range and location. The warehouse can use this report along with the Open PO report to aid in creating schedules.
Parameters:
To location
Start date
End date
Module: Shipping and Receiving
Description: This report shows information about open transfers and allocations that have been shipped. Optionally, the report can include information about transfers and allocations that have been approved but not yet shipped.
Parameters:
From location
To location
Location list
Department
Class
Subclass
Item
Start date
End date
Show future
Note: When Show Future is Yes, the start date must be blank. |
The following section describes the Stock Count reports.
Module: Stock Count
Description: The Missing Stock Count Result report identifies the locations where a stock count is scheduled for the current week but for which stock count data has not yet been entered into the system.
Parameters: None
Category: Stock Count
Description: The Stock Count Variance Report displays items that exceed the unit, cost, or retail stocktake variance system settings.
Parameter: None
The following section describes the Supplier Compliance report.
Category: Supplier Compliance
Description: This report shows a summary of performance by supplier by month, including order quantities, quantities received, late receipts, and compliance percents.
Parameters:
Not before/not after date
Division
Group
Department
Class
Subclass
Supplier
Supplier trait
Start month (this is a mandatory field)
End month