I use Dynamics GP 10, and Crystal Reports 2008 to print my sales documents (via Forms Printer from Accountable Software). I'd like to be able to print a subtotal in the body of the sales quote form, based on the last occurance of a certain item number.
For example, I have a large quote that references several areas of a building. I would like to show a subtotal for each area. The last line item in each area is a part number called "ROOM". This part number signifies the end of the equipment for that room.
Any help you can provide is greatly appreciated!