Reporting groups 1 and Reporting groups 2 ( for Accounts, Debtors, Creditors, Stock, Documents and Cost centres) is added in Groups on the Setup ribbon. Salespersons, payment types, Projects and Languages is also added in Groups on the Setup ribbon

setup-groups-types

Each of these groups contains a WTYPEID and a SDESCRIPTION in the V_TYPES table. 

These WTYPEID in the V_TYPES table were used to add Reporting group 1 to the Parameters (Report options).

WTYPEID

(V_TYPES table)

Description

20

Account group 1

21

Account group 2

22

Debtor group 1

23

Debtor group 2

24

Creditor group 1

25

Creditor group 2

26

Stock group 1

27

Stock group 2

28

Document group 1

29

Document group 2

30

Payment types

31

Salesperson

1000

Projects

1002

Cost centre 1

1003

Cost centre 2

1004

Language


For example, to reference these Groups in the V_TYPES table, you need to add "GROUPS22" 

Note this must be Entered in the Plural followed by 22 and entered in UPPERCASE i.e. GROUPS22. If this is not entered correctly, it will not list the Debtor groups, but display "SQL error".