Statistics related queries, topics and discussions
User avatar
By admin
#318 Trendmarkers in Purchase Statistics refer to the successive bytes of ST08013, Alt Product Group, which comes from SC01038, Alt Product Group.

See the following extract from the Stock Control Manual, Code File:
Product Groups
Use this code, which consists of up to four alphanumeric characters, to group stock. You should avoid having too many groups since the value of the information may be lost. Scala has the facility to calculate subtotals based on the first two characters in the Product Group. Use the first two characters for main Product Groups and use the other two characters to create subgroups.

Example:

Product Group Description
10 Head Gear
101 Caps
102 Hats
20 Trousers
201 Shorts
202 Long Trousers
In this example, you can print statistical reports on all items in the interval 1 to 10, which means groups 10 to 1099. You can also follow up what happens to the single group 101, Caps.
Product Group codes also apply in the stock entry field
Alternative Product Group. You can use Alternative Product Groups in the same way as Product Groups, and you can use them to group stock differently. For example, you can use them as “trend markers”. Take a cross section of your selection, with a mixture of cheaper and more expensive products. One section may be fashionable, or may have particular colors. It does not matter whether they are scarves or trousers. If you produce statistical reports showing that the trend is moving up or down for expensive woollen shorts in the latest colors and made in Japan, this can add a new dimension to purchasing, marketing and price setting decisions.

Example:
Trend marker 1 (pos 1)
Price level:
E expensive
A average price
C cheap
Trend marker 2 (pos 2)
Material:
A acrylic
W wool
C cotton
Trend marker 3 (pos 3)
Color:
R red
L lilac
W white
Trend marker 4 (pos 4)
Origin:
J Japan
S Sweden
E England
The Alternative Product Group for all stock in the range, cheap, woollen, red and made in England, is CWRE.
------------------------------------

They are also available in Sales Statistics, field ST02019, and Invoicing Statistics, field ST03019.


User avatar
By Lightcap
#686
admin wrote:Trendmarkers in Purchase Statistics refer to the successive bytes of ST08013, Alt Product Group, which comes from SC01038, Alt Product Group.

See the following extract from the Stock Control Manual, Code File:
Product Groups
Use this code, which consists of up to four alphanumeric characters, to group stock. You should avoid http://www.sleepingtrains.com/ the Provillus having too many groups since the value of the information may be lost. Scala has the facility to calculate subtotals based on the first two characters in the Product Group. Use the first two characters for main Product Groups and use the other two characters to create subgroups.


Thanks for explaining.