SOP Invoice Subtotals by Item Class

[barbola]

Is there such a monster or does anyone know where I would put the footer for this?

I joined the Item Class Master table. My item details are in a header. The first footer (after body) is comment1, then Comment2, then something called component footer (which has comment 3). I tried putting an item class footer everywhere. The first one gives me the footer for every line item, does not break after the item class.

Crystal is not an option for me.

thanks,
Barb

 

[RobertC22]

Do you want to group all Items from the SAME Item Class together, rather than the order shown on the screen, and have a subtotal after each group?
Or do you want a subtotal that pertains to each Item Class group at the end of the report, having shown all item lines already?
The former is possible within Report Writer, the latter not.

How to get Subtotalling on Item Class?
The following is a simple way, but does mean that Line comments will NOT print. Having done this mod, it is unlikely to print as expected should you have kits, serialised items or lot numbered items.

1. Change the Sorting.
Include the fields: (first seven represent the original index, whilst the 8th field represents your grouping)

Location Code of table Sales Document header temp
Document Type of table Sales Document header temp
Sequence Number of table Sales Document header temp
User ID of table Sales Document header temp
Document Print of table Sales Document header temp
Sop Type of table Sales Document header temp
Sop Number of table Sales Document header temp
Item Class Code of table Item Master

2. Within the Layout,
remove the fields in the BODY section
Move the fields in H2 into Body Section
Remove any fields in F1 to F5 (this should only the the comment array)

3. Change the Additional Headers and Footers
a. Change the seoncd header (labelled 'Item').
Currently it is set to 'Sales transaction Amounts Work'.'Line Item Sequence'.
Amend this to 'Item Master'.'Item Class Code'
b. Remove the remaining additional headers (3, 4,& 5)

c. Remove the first three additional Footers
d. Change the additional footer (previously the fourth, now the first) 'Comment 4' break field from
'Sales transaction Amounts Work'.'Line Item Sequence'.
Amend this to 'Item Master'.'Item Class Code'

5. Footer Two [F2] is where you can now put your subtotalling.


------
Robert

 

[barbola]

Wow thank you ... I will give this a try.

b.

 

[barbola]

I can't seem to get this to work. I tried making the modifications to our modified report and it would print each item class on a separate page.

So then I started fresh with the original SOP Invoice and now it won't even print any items.

In both cases, the first page shows a total $ amount, but it's incorrect. Then there is a second page with a total of 99,999,999.99.

I don't use line comments but we do have comments on our invoices. Would this be affected by removing the comments from the footer?

thanks.