|
The information you want
from the system is the key to how the system must
be set up.
POSperfect
has a powerful reporting module designed to
provide summarized management reports with the
power to drill down through successive department
group levels to the stock movements and
transactions that make up the report.
3.1 Define your Reporting Groups
POSperfect
has three types of reporting groups: Standard,
Vendor, and User
Defined.
3.2 Standard Product Groups
These
are hierarchical groups like Departments and Sub
Departments.
You
can have up to four;
Division
Highest
Level
Department
Class
Subclass
Lowest
Level
Example1:
Division
=
Supermarket
Department
=
Groceries
Class
= Food
Subclass
=
Canned Food
Example2:
Division
=
Not Used
Department
=
Appliances
Class
= Home Entertainment
Subclass
=
Stereo’s
Two
levels are often sufficient in which case only Department
and Class
should be selected.
Note:
With
Standard (hierarchical) groups you cannot have two products
belonging to the same lower level group, e.g.
“Class” but with different higher level
groups, e.g. “Department”.
3.3
Vendor
This
is simply one reporting group listing all vendors.
All product related reports allow selection of a
vendor or range of vendors.
There is no planning required, only the
entries of all vendors or suppliers in the vendor
file.
3.4
User Defined Groups
This
is how POSperfect handles special reporting for
different types of merchandising.
A
User Defined group is named for a specific
purpose. You can have up to four different User
Defined reporting groups. These groups
(Non-hierarchical) are labelled in the “Features/Product
Report groups” screen in the Setup module.
When to use User Defined Groups
You
should use User Defined groups when you want to
group products from different Departments and
Classes into a common reporting group.
Example: You may want report on all products of a particular “Brand”
like “Sony”. The “Sony” products will span
several different Standard product groups like
Stereo’s, TV’s, and Video Cameras. A User
Defined group will allow you to define a group
named “Brand” in which products of the same
brand “Sony” can be grouped. The reporting
systems will then automatically give you reporting
by “Brand”.
There
are numerous uses for User Defined groups. Some
more examples;
Season
Label
Manufacturer
Country of Origin
Perishable Items
Dangerous Goods
Packaging
Type
Material Type
Refundable Item
Size (container size)
A
User Defined group can have very few or many
entries (records), e.g.. A Manufacturer group will
have many entries, but a “Perishable Items”
may only have “Perishable” and “Non
Perishable” entries.
When
you set up User Defined groups every SKU should be
assigned to every group. For example in the
“Perishable Item” group the items not relevant
to this group should be assigned to “Non
Perishable”. This is so the reporting systems
will always balance. If you had a SKU not assigned
to either Perishable or Non Perishable and ran a
report, the total on that report (of all groups)
would not match the total of another report run
for example for all departments. This may not
matter, but should be considered when designing
the inventory and reporting systems.
3.5 Products not relevant to product groups
Often
“User Defined”, “Standard” and
“Vendor” reporting groups are irrelevant for
some products. It is therefore good practice
within each reporting group (Department, Class,
Vendor, User Defined) to have an “Unknown” or
“Miscellaneous” entry so that products which
are not relevant to a known group can be located
and a report run for that group will give a
correct and balanced total.
3.6 !! Importance of
deciding correct Groupings !!
The
importance of planning groups cannot be
overemphasised. It is very difficult to change
Groups after a system is ‘up and running’.
Database tables must be altered and all
interconnections to various reports are thrown
awry. In some cases the system will not be able to
change, e.g.. altering SKU from Size/Colour to
Non-sized. New data may be added, e.g.. new size,
easily, but existing data relationships must be
kept intact. To effect some changes it is easier
to renew the system and reload ALL the data.
|