How to use GroupTotalFields on an external table

ellusivelady

Example scenario:

I wish to print the items on sales line based on category (a new field added)

Under sales line, you cannot find the information of category. You need to go to item card only then category can be obtained.

I'm creating a report with data items sales header, sales line.

Question: How I can group the items based on category?

~Is there a need to create another data item inventory and link it to sales line?
~Or should i just create a record variable inventory? but how do i go grouping it?

any help is much appreciated. thanks in advance. [-o<

kine

In this case you cannot use the native grouping. You need to solve it in another way. Or you can add the field to the Sales Line and fill it when validating item no. but:

1) This is good for reporting - you can easily group the items
2) You need to be sure that the field is filled correctly each time
3) the field will take some small part of DB (if this way is heavily used, mainly on posted entries tables, the database will grow faster...).

ellusivelady

hey kine,

thanx so much for your response. really appreciate it. well, i figure so too. a bit of a hassle but it seems adding the field to sales line when validating item no. is the best way out so far.

thanks once again ya.