eSuite – Reports – Items

Information

Item reports give an overview of item information such as POS, active price, next price and cost.

Access the item reports

The item reports are available from eSuite's common modules.

To access the item reports:

1. In the launcher, click on Items.
2. Click on Master: the Start window opens, displaying the item-related options.
   
3. Select the type of report in the right column.

Single total

The Single total report displays one amount for all totalizers combined, for the selected period, target and items.

Criteria selection is possible through the Items - single total wizard.

The More criteria button adds criteria related to movement and items.

The wizard allows you to break down the report by date and by store, and to view only the items with no movement.

To access the Single total report, execute the wizard or press Enter on your keyboard.

In the bottom menu:

• Edit gives access to all item tables.
• Analyze breaks down the report by date and by store.
  It gives access to transaction details (TRS), saved transactions (SAV) and to the electronic journal (XML).
  It performs item subqueries and item linked queries.

Multi totals

The Multi totals wizard offers criteria selection that includes period, date range, target, totalizer start and stop, item code start and stop. It allows breaking down the information by store, by date and only items with no movement. Criteria related to movement and item may be added with the Add criteria button.

The Multi totals report displays all totals by item.

In the bottom menu:

• Edit provides access to all item tables.
• Analyze allows performing subqueries and linked queries.

Compare totals

The Compare totals wizard offers criteria selection that includes movement, departments, sub-departments, family code, category code, report code, vendor code and batches. It allows breaking down the information by store, by date and only items with no movement. Criteria related to movement and item may be added with the Add criteria button.

The Compare totals report displays transaction quantity and total sales from one store compared to another and/or a totalizer compared to another, by item.

In the bottom menu:

• Edit provides access to all item tables.
• Analyze allows performing subqueries and linked queries and displaying the information by store and by date.

Cost of goods

The Cost of goods wizard offers criteria selection that includes period, target and item code range. It allows breaking down the information by date, by store, by item, by sub-department and showing items using the batch number.

The Cost of goods report displays the details of each transaction (UPC code, date, store number, movement quantity, amount, weight, cost, profit, margin, retail price, markdown and discounts).

In the bottom menu:

• Edit provides access to all items tables.
• Analyze allows performing subqueries and linked queries.
• Action allows assigning/unassigning promotions and generating labels.

Movement by store

The Movement by store wizard offers criteria selection that includes period and target. It allows breaking down the information by date, by store, by item, by sub-department and showing items using the batch number.

The Movement by store report displays the item movement by store.

In the bottom menu:

• Edit provides access to all item tables.
• Analyze allows performing subqueries and linked queries.
• Action allows assigning/unassigning promotions and generating labels.