Hello, Is there a solution to group information on standard ReceiptTemplate's purchase order?! (maybe some kind of "for each" solution like SQL's "group by" method on Active Reports)
We have 200 matrix items and 50.000 standard items with subdescriptions
1,2,3 (variant, size, color) that are linked to matrix items. Items in different variants and sizes can have different price (but in same colors have same price)
On standard purchase order we have: code: Quantity: Price:
00011-112-321 1 7,5$
00011-112-232 2 7,5$
00011-113-345 4 8,5$
00011-113-234 6 8,5$
00011-114-543 3 9,5$
00011-114-342 8 9,5$
Is there a way to group items to matrix (itemclass.id), subdescription1 (item.subdescription1) then subdescription2 (item.subdescription2) to receive an aggregated view?!
Example: code: Quantity: Price:
00011-112 3 7,5$
00011-113 10 8,5$
00011-114 11 9,5$
Thanks for any help.