Hi folks,
We are about to send out our competition invoices for our school and we are using an old info maker receipt that includes price types so the parents can see what they're being charged for. This year we added pricing layers so we could code things to different GL's on the same price type. We are now running into the fact that our receipt is splitting out the price layers by line so it looks like the parent is paying for the same item twice with different prices. (Which they technically are, but the amount of questions this will raise makes my head hurt.) I'm wondering if anyone has any insight into how we can edit the receipt to make the pricing layers combine and just show up as a total due for that price type. Here is a screen shot of what's set up:
Here is what the receipt looks like (spacing is off but I can fix that):
So those two lines should be combined into one.
Alternatively, does anyone have the knowledge on how to add a price type description and performance code to an HTML template or have code for one you've done that includes that that you'd be willing to share?
Thanks, all!
Nicki
Nicki LeGrand, I'm comfortable with Infomaker! (I know, I know, I'm a hit at parties. ;))
You need to create a group and then show the sum of the amounts on the group header or footer. In Infomaker, go to Rows->Create Group and then choose the fields you want to group on (maybe customer # and item #?). Then you can put the grouped data on the header or footer for that group.
In my not very applicable example below, the data is being grouped by category_desc and category (probably redundant). The header row for the group shows category_desc.
The detail section shows every row that's returned by the query/proc. Below that is the footer/trailer for the group, and here we see examples for aggregates. These could be in the header or the footer. Either is fine.
The Summary row at the bottom displays at the end of the report and totals all of the data.
Feel free to ping me if you need more guidance. Good luck!
Thanks, Katie!!