Korisnički alati

Site alati


Brix | Goods & Services
Menu > Basic data

Goods & Services Groups

Item groups enable grouping1) and marshalling2) in various stocks and sales reports.

The following rules apply:

  • A group code is comprised of up to four characters.
  • Any character can be used in the group code. Lower and uppercase letters are differenciated.
  • Marshalling in the report will be done in the alphabetical order of the group codes.
  • Group codes with one, two or three characters are used solely for marshalling the report.
  • An item can only be assigned a single four character group code.

An example arrangement of group codes for goods:

  • E - Electric
    • Ec - computer components
      • Ec00 - Motherboards
      • Ec01 - Graphic cards
    • EcM - Memory
      • EcMd - DDR memory cards
      • EcMh - Hard disk drives
      • EcMs - SD memory cards
    • Ee - electronic components
      • EeR - Resistors
        • EeRS - SMD Resistors
        • EeRT - Through hole Resistors
      • EeC - Capacitors
        • EeCX - Capacitors
  • M - Mechanical
    • M000 - Mechanical components

Items can only be assigned to the bold groups and reports would be marshalled in the above shown alphabetical order with totals and subtotals.
For example:

Group/Item Qty Value
E - Electric 9568 1725.00
Ec - computer components 168 1575.00
Ec00 - Motherboards 6 35.00
* Asus 1 10.00
* HP 2 12.00
* Lenovo 3 13.00
Ec01 - Graphic cards 10 100.00
* Nvidia 10 100.00
EcM - Memory 152 1440.00
EcMd - DDR memory cards 22 220.00
* 1Gb 4 40.00
* 2Gb 5 50.00
* 4Gb 6 60.00
* 8Gb 7 70.00
EcMh - Hard disk drives 30 300.00
* 1TB 10 100.00
* 2TB 20 200.00
EcMs - SD memory cards 100 900.00
* 16Gb 50 400.00
* 32Gb 50 500.00
Ee - electronic components 9400 150.00
EeR - Resistors 8600 90.00
EeRS - SMD Resistors 8000 50.00
* 100k/0.25W 5000 40.00
* 120k/0.125W 3000 10.00
EeRT - Through hole Resistors 600 40.00
* 56k 300 20.00
* 82k 300 20.00
EeC - Capacitors 800 60.00
EeCX - Capacitors 800 60.00
* 10mF 100 20.00
* 22mF 300 20.00
* 47mf 400 20.00
M - Mechanical 50 370.00
M000 - Mechanical components 50 370.00
* Desktop case 5 50.00
* Mini tower case 10 100.00
* Maxi tower case 15 100.00
* Embedded Al Housing 20 120.00

Note! Group Ec0 is not defined so there is no subtotal in the report.

For aplication where not more than 10 leveles per character are not expected we recommed using only numerals in the group code as it makes it easier to alphabeticaly sort. If you ever need to go above 10 levels you can do so by carring on with letters that will alphabetically come after the numerals
For example the above could be done in the followong way:

  • 0 - Electric
    • 00 - computer components
      • 0000 - Motherboards
      • 0001 - Graphic cards
    • 001 - Memory
      • 0011 - DDR memory cards
      • 0012 - Hard disk drives
      • 0013 - SD memory cards
    • 01 - electronic components
      • 011 - Resistors
        • 0111 - SMD Resistors
        • 0112 - Through hole Resistors
      • 012 - Capacitors
        • 0120 - Capacitors
  • 1 - Mechanical
    • 1000 - Mechanical components
1)
refers to presenting similar items with similar qualities together under a common head inside reports
2)
arrangement and order of items in the report
en/brix/groups.txt · Zadnja izmjena: 08/10/2019 15:06 od Zoran Spoja